sql server user logins

I created a sql server 2008 r2 database for a specific user and assigned them as dbowner. Is there  a way to tell if this user has been logging in and using this database?

thanks!
LVL 2
Starr DuskkASP.NET VB.NET DeveloperAsked:
Who is Participating?
 
Sreedhar VengalaConnect With a Mentor Sr. Consultant - Business IntelligenceCommented:
In MSSQL server you can run the following command...

exec sp_who2

Open in new window


This will give you a lot of information including who is logged in, application name, current command, so on and so forth.
0
 
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
That shows only events since 3/23.

How do I see event as far back as 3/20? If it doesn't show that date is it just not there? That's when I created the database. And I logged in with the account that date, but I don't see any record of it.

thanks!
0
 
Patrick TallaricoConnect With a Mentor FSEP Systems AnalystCommented:
Check out the following article:
http://www.ultimatewindowssecurity.com/sqlserver/Default.aspx

Have you checked the Windows Event Viewer?  The security collection may have a listing of the authentication to the sql server.
0
 
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
The windows event viewer doesn't show the sql server logins in the security collection.

I'll check out the other link. thanks all!
0
 
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.