Posted by RogueIT on 09/28/07 18:52

On Sep 28, 2:42 pm, "Roy Harvey (SQL Server MVP)"
<roy_har...@snet.net> wrote:
> On Fri, 28 Sep 2007 16:25:41 -0000, RogueIT
>
> <Scott.T.Holl...@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

thank you both...

[Back to original message]