June 10, 2005 at 8:05 am
Hi Friends....
I want to know if exist a possibility to check who was the last user in acceding some databases, and how time passed after it.
I need to know this, because i have more than 100 databases on a clustered server and i supposed that more than 20 are unused.
Thanks all!
June 10, 2005 at 10:19 am
i think you would have to set up a profile to track logins; it's not stored anywhere, it is just an event that happens, unless you profile to a table.
I don't know if feasable in your environment, but you could take the databases you think are not used and take them offline by restricting access, and wait for people to scream.
Lowell
June 10, 2005 at 11:35 am
I always like this one... untill you remember that this can break applications if they use more than one database.
Is it possible to "close" all the database like when they have auto-clause on (so they can open when needed). Then come back one month later and delete the db that are still closed?
June 10, 2005 at 12:12 pm
What about the column "LastBatch" when u run the SP sp_who2??
June 10, 2005 at 12:28 pm
It doesn't guarantee that you will catch all the databases in use.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply