There's no supported way to defrag system tables. Why do you think you need
to remove fragmentation in them?
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"matt" <ma**@perfectdata.co.nz> wrote in message
news:39**************************@posting.google.c om...
can you defrag system tables. They appear in my dbcc showcontig
report. Some are worse than other but if it where a user table I
would defrag it. However the reindex commands doesnt work on system
tables.... Any ideas.
Thanks Matt.