How long register the Databases without access??

  • 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!

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 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?

  • What about the column "LastBatch" when u run the SP sp_who2??

  • 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