If you log failed and successful logins that will give you an idea of when
some one last signed in.
If you want to find out what was done you may use a third party tool
Lumigent has one which is supposed
to be pretty good
Thank you
Mike Ngong




Mandeep Bhutani <[Email Address Removed] 01:54 AM


To: "LazyDBA.com Discussion" <[Email Address Removed] cc:
Subject: Last time DB Accessed.


Hi All,

Is it possible to find out when was the database last
accessed?
Is there any system procedure or system table that
holds any such entry??

Thanks in advance.

Regards
Mandeep

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page