question

srivivek avatar image
srivivek asked

How do I find when was a database last accessed in SQL 2000?

Hi, Is there a way to find when was a database last accessed/used in SQL 2000, and by whom? Thanks
sql-server-2000databaseloginconnection
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Accessed? Nope. No easy way. Unless you already have an events trace set up, or you're logging logins to the server, there's no real way to know that out of the box. Same applies to 2005, 2008, 2008R2 & 2012. You have to set up specific auditing/monitoring to know that.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.