How to find out who has looged on to my machine yesterday

Question

How to find out who has looged on to my machine yesterday

chaithu559

SSCommitted

Points: 1574
More actions
June 9, 2012 at 1:37 am

#257574

Hi Everyone,
How to find out who has looged on or connected to my sql server instance yesterday and did some changes.
Please help me in finding out this
Thanks
Chaithanya M

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You can check the default trace, it shows schema changes. Other than that, unless you had some auditing in place you're unlikely to find much out.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sony Francis @EY SSCommitted Points: 1539 More actions · Answer 2

Use Default Trace

http://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server-2005-and-sql-server-2008/

Rock from VbCity Hall of Fame Points: 3991 More actions · Answer 3

You can do a Google search on "windows 7 last logged on user registry" some hits are worth reading.

Hope this helps,
Rock from VbCity