Re: Monitoring database usage

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 12/11/02


From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Wed, 11 Dec 2002 17:07:21 -0000


A last access date for a database is not stored anywhere. Using Profiler
could be an option, to see if anything is running in this database.

Or else, simply rename the database or take the database offline and see if
anybody complains ;-)

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Jason" <jr439@hotmail.com> wrote in message
news:145d01c2a122$83b93bf0$8ff82ecf@TK2MSFTNGXA06...
> We currently have about 200 databases in our environment.
> It recently came to my attention that some of these may
> not be in use, so I'm trying to determine which of these
> has not had anyone logged in for the past several months.
> Is there a way to determine when the last user logged into
> a database?


Relevant Pages