Table statistics?

• Diema

  SSC Enthusiast

  Points: 161

  More actions

  February 9, 2007 at 12:39 am

  #61099

  Is there any statistical information about tables in SQL 2000?

  I mean information like:when table has been lastly changed.I know I can make a history with trigger and writing in another table.Does SQL keep such information in master DB (any sp_ or xp_ which give such info)?Thanks in advance.I'll be grateful for your suggestions.

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  February 9, 2007 at 1:09 am

  #688741

  I had the same requirment some time back. I used the trigger option

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Diema

  SSC Enthusiast

  Points: 161

  More actions

  February 9, 2007 at 1:21 am

  #688742

  Hi Dinesh Asanka!

  Did you receive any other suggestions?

• Paarthasarathy

  SSChasing Mays

  Points: 649

  More actions

  February 9, 2007 at 5:41 am

  #688782

  Another most frequently used option

  is to have a modified_date column in all tables with getdate() as the default option

  so as to find when the table was modified at last with statistics of row level

  Kindest Regards,
  Paarthasarathy
  Microsoft Certified Technology Specialist
  http://paarthasarathyk.blogspot.com