Viewing 2 posts - 1 through 2 (of 2 total)
I have database with 1670 sysobjects (tables, views, defaults, fkeys, procedures, triggers). Sysobjects table has 32 pages (about 256 KB). But it has 12 extents. Fragmentatiton is more than 90%....
January 31, 2005 at 8:17 am
#539750
I'm afraid there is no answer yet. I'd like to know it too, how to defragment SYSTEM TABLES. Indexdefrag doesn't work with system tables.
Jan
January 28, 2005 at 5:13 pm
#539639