Results 1 to 4 of 4

Thread: sys tables

  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Angry Unanswered: sys tables

    how do i reindex system tables of a database

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    As far as I know there's no command to do so. The alternative would be to drop all objects and recreate those you need. Generally there's no need to do so, so if you don't mind me asking, why do ask?

  3. #3
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    are you talking about a clustered index ?

    In that case, you can use DBCC indexdefrag

    Cheers,
    -Kilka

  4. #4
    Join Date
    Oct 2004
    Posts
    4

    Kaiowas

    there are two consistency errors on that table and can not be repaired by DBCC checktabel with repair allow data los option

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •