ALZDBA (2/9/2010)
If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.This way, you will find a "database opened" message in your sqlserver errorlog file
I would be better looking at the active sessions through Activity Monitor rather than setting that option. Since it would have an impact on the Performance..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty