Re: Monitoring database usage
From: Narayana Vyas Kondreddi (firstname.lastname@example.org)
- Next message: Chris Wood: "Re: SQL hotfix version discrepancy"
- Previous message: Narayana Vyas Kondreddi: "Re: SQL hotfix version discrepancy"
- In reply to: Jason: "Monitoring database usage"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Narayana Vyas Kondreddi" <email@example.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" <firstname.lastname@example.org> 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?