Post reply

is there a way to check when a database was last used/opened

  • May 16, 2006 at 5:41 am

    #112236

    i am running server with alot of different databases on it

    all running test data for field sites.

    can i check what databases have not been opened/accessed/used within the last x amt of months etc.

    is there a script to check this

    tx ste

    i am a newbie so if it is obvious please excuse me

  • May 18, 2006 at 8:32 am

    #638750

    I'm not sure I can help you with the past accesses, but going forward, you may want to look into the SQL Profiler tool that comes with MS SQL and configure a trace that will log the activity that you are interested in.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply