Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

When the last time Database used Expand / Collapse
Author
Message
Posted Sunday, October 14, 2007 2:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 11, 2007 11:33 AM
Points: 116, Visits: 1
Comments posted to this topic are about the item When the last time Database used


Post #410587
Posted Wednesday, January 16, 2008 11:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 25, 2011 1:09 AM
Points: 4, Visits: 32
This script works well for database but not at transaction level, becasue the script is actually picking up the date when the physical file details were changed. Thus if some one has used my database for insertion of a row or creation of a table, that time is not picked by the SP instead it picks the date when the physical file.mdf changes.

Please let me know how can we ammend this script to check for last transaction on the database\table.

Thanks
Yakshi
Post #444138
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse