|
|
Posted by Roy Harvey (SQL Server MVP) on 09/28/07 18:42
On Fri, 28 Sep 2007 16:25:41 -0000, RogueIT
<Scott.T.Holland@gmail.com> wrote:
>Is there a way in 2005 to tell what user is logged into what database
>on the SQL Server?
>thanks,
>Scott
One way:
EXEC sp_who
Be aware that users are not really logged in to a database. Each user
who is logged in to the server is associated with a default database,
and anything they execute that does not have an explicit database
qualifier references that database. But there is nothing that says a
user defaulting to database Foo could not querying database Bar, or
any other database on the system.
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|