Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2009-12-17 : 16:47:23
|
| Hi,I often get the question : ’When the databases was accessed for the last time?’Is there an easy way to know it other than monitoring?Thank youAK |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-12-18 : 06:24:00
|
| No. |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-18 : 09:12:20
|
| SQL Server can log event information for logon attempts and you can view it by reviewing the errorlog. By turning on the auditing level of SQL Server.follow these steps to enable auditing of all/successfull connections with Enterprise Manager in SQL Server:Expand a server group. Right-click a server, and then click Properties. On the Security tab, under Audit Level, click all/success etc(required option).You must stop and restart the server for this setting to take effect.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
|
|
|
last time a db was accessed