Post reply

When was database reorged?

  • August 3, 2005 at 7:24 am

    #90296

    Hey Guys,

    I am little lost after doing lot of sailing around here and there. Can somebody tell me, how would I know if a database is being reorged (tables are being either reindexed or defragmented)?

    Is there any way I can check on this?

    Please help me!

     

    Thanks!

    Viking

  • August 3, 2005 at 12:42 pm

    #579308

    I don't think there is anything specific you can check for when the reindex/defrag occurred. You can run DBCC SHOW_CONTIG to check on the table fragmentation.

     

    --------------------
    Colt 45 - the original point and click interface

  • August 4, 2005 at 10:53 am

    #579712

    I think Phil is right. There's on date info in sysindexes. There might be something encoded, but nothing I know of.

  • August 4, 2005 at 10:56 am

    #579717

    There's always the crdate column in sysobjects for the constraints... but that's not much info.

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

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