It is one of the DBCC Commands of SQL Server. When our DB became suspect it was recommended by Microsoft support to call this command for recovery purpose. But what...

Thank you, it may help to delete the image column and rebuild it. I found also that if I copy all the contents of the table to a new table,...

Do you have image type fields in your database? Or space/allocation problem was with regular fields?

a_k_

Thank you for your help. I tried both methods, no one removes unused space created by fragmentation of the image fields. After each attempt I run 'sp_spaceused' with 'updateusage' option...

We have SQL Server 2000. Does MS have new reallocation options for 2k?

a_k_

Image data type stored differently then normal data. They stored "outside a data row. The data row contains only a 16-byte text pointer that points to the root node of...