Database Access

Is it possible to get a list of all users that accessed a particular
Sql Server database? ThanksOnly is you had a trace running that captured the user names or logins.
Andrew J. Kelly SQL MVP
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1140541552.276198.144260@.g43g2000cwa.googlegroups.com...
> Is it possible to get a list of all users that accessed a particular
> Sql Server database? Thanks
>|||sp_who ?
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1140541552.276198.144260@.g43g2000cwa.googlegroups.com...
> Is it possible to get a list of all users that accessed a particular
> Sql Server database? Thanks
>|||No, the current users can be viewed with sp_who or sp_who2 but to see
the users in the past you have to use a log reader to see which user
issued a command against a database.
HTH, Jens Suessmeyer.|||http://msdn.microsoft.com/library/d...>
ity_2ard.asp
http://msdn.microsoft.com/library/d...>
erf_4wl5.asp
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1140541552.276198.144260@.g43g2000cwa.googlegroups.com...
> Is it possible to get a list of all users that accessed a particular
> Sql Server database? Thanks
>|||sp_you
"Ben" <bennett@.newsgroups.nospam> wrote in message
news:41773$43fb55f3$d8445835$6596@.FUSE.NET...
> sp_who ?
> "S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
> news:1140541552.276198.144260@.g43g2000cwa.googlegroups.com...
>