x

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

more ▼

asked Nov 17, 2011 at 07:43 AM in Default

avatar image

srivivek
535 41 42 47

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Nov 17, 2011 at 08:18 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x501
x279
x103
x57

asked: Nov 17, 2011 at 07:43 AM

Seen: 2119 times

Last Updated: Sep 02, 2014 at 07:28 AM

Copyright 2016 Redgate Software. Privacy Policy