Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: Rebuilding Indexes

    I am trying to rebuild indexes on system tables by using a script that will be called from a batch job. Does anyone have any ideas of how to do this? I know DBCC DBREINDEX does not support use on sytem tables.

  2. #2
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28
    What version of SQL?

    I'm also wondering why you want to do this. I've never even thought about it. SQL 2000 is supposed to update this stuff automatically. Maybe I shouldn't AssUme? hmm.

    I really can't find anything on the subject.
    Thanks,
    Jason

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Never ever play with system tables using DBCCs, even MS discourages and does not support to do so.

    As referred why do you want screw up your system?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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