table with zero records and 20 GB!!

  • In my company there is an application that creates DTS packages (2000) in a 2005 on the fly and recreates the same packages every time. this morning I realized that msdb was huge and the table sysdtspackages had 20gb. I decided to delete the packages from the legacy/DTS and I did it but now the table still is 20gb big and zero records!!!what can I do to reduce the sice since shrink DB or File does not work??

    Thanks,

    Jose Maria

  • Never mind I did a truncate table and the space was deallocated...

    thanks,

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply