Posted by Erland Sommarskog on 08/12/05 00:52

Raziq Shekha (raziq_shekha@anadarko.com) writes:
> Thanks Erland. But setting up a trace will only tell me when someone
> logs on to a database in the future. I don't think it will tell me
> whether someone logged on to a database last week.

Correct. The information you are asking for, is not available unless
you collect it.

> What I am trying to do is to determine whether there are any databases
> to which no one has connected to in a long time. And if that is the
> case, I can try and get rid of those databases.

Be aggressive! Find the most suspicious ones, set them offline, and
see if someone screams!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]