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.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.|||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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment