When the last time Database used

• mniazi

  SSC Enthusiast

  Points: 144

  More actions

  October 14, 2007 at 2:47 am

  #180296

  Comments posted to this topic are about the item When the last time Database used

• yakshi malhotra

  SSC Rookie

  Points: 26

  More actions

  January 16, 2008 at 11:03 pm

  #769070

  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