Users Logged In

[RogueIT]

Is there a way in 2005 to tell what user is logged into what database
on the SQL Server?
thanks,
Scott

[Jason Lepack]

Management -Activity Monitor is my first guess.

Cheers,
Jason Lepack

On Sep 28, 12:25 pm, RogueIT <[e-mail]:

Is there a way in 2005 to tell what user is logged into what database
on the SQL Server?
thanks,
Scott

[Roy Harvey (SQL Server MVP)]

On Fri, 28 Sep 2007 16:25:41 -0000, RogueIT
<Sc*************@gmail.comwrote:

>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

[RogueIT]

On Sep 28, 2:42 pm, "Roy Harvey (SQL Server MVP)"
<[e-mail]:

On Fri, 28 Sep 2007 16:25:41 -0000, RogueIT

<[e-mail]:

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

thank you both...