hi,

im having a urgent issue here and hope someone here could give me a clue, im using ms sql 2008 and would like to know how to retrieve info of who has login to database before for the passed 3months. is there a system table or view in mssql that stored these information?

hope to hear your advice soon.

thanks!

If you set up SQL Server to log all logins and outs then it will be in the log.

hi,

what if i dont? means no others way to overcome this?

thanks.

You can't audit this retrospectively without having set up appropriate tracking in the first place.

ok, thanks and really appreciate ur promptly reply.