Reclaim Space from Systemtables

• JanVangorp

  SSC Veteran

  Points: 262

  More actions

  March 6, 2006 at 2:03 am

  #152804

  Hi,

  After removing the Merge replication of my database. Some systemtables still allocate "a lot" of space. (not big in MB, but big in %) Is there a way to free this data ?

  Example of my systable :

  exec sp_spaceused 'dbo.syscomments' , 'true'

  result:

  name           rows        reserved           data               index_size         unused             syscomments    736         23496 KB       5760 KB          200 KB             17536 KB

  Reindexing doens't work on systables

  Thanks,

  Jan

• klessig

  SSC Journeyman

  Points: 82

  More actions

  March 7, 2006 at 6:46 am

  #625160

  Don't forget to run DBCC UPDATEUSAGE ('table_name') before you run sp_spaceused to endure you get an accurate result.