Post reply

Table statistics?

  • 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.

  • 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/

  • February 9, 2007 at 1:21 am

    #688742

    Hi Dinesh Asanka!

    Did you receive any other suggestions?

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

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