Post reply

timage data type.

  • April 11, 2003 at 12:24 pm

    #80732

    Hi,

    I have a column which stores image data type.Recently i had to delete most of the data from the table.Surprisingly i don't see the space freed up by deleting these rows??

    the way i am trying to see is by refreshing the filegroups in the enterprise manager/by running sp_spaceused.

    But i just see that the space freed up is very less compared to what it's occupied by these image rows.

    ANy idea why it soesn't show the free space??

    Thanks,

    Gutti

  • April 11, 2003 at 12:36 pm

    #453929

    Did you run sp_spaceused @updateusage = true ?

  • April 11, 2003 at 12:46 pm

    #453931

    yes.I did that but no use.

  • April 11, 2003 at 12:56 pm

    #453933

    Which version and service pack do you have in SQL Server? Check KB 272220 even though it talks about SQL Server 7.0.

    http://support.microsoft.com/default.aspx?scid=kb;%5Bln%5D;272220

  • April 11, 2003 at 1:16 pm

    #453935

    I have slq2k with 0 service packs.

  • April 11, 2003 at 1:41 pm

    #453938

    Can you try to apply latest service pack see whether you still have such issue? If it doesn't work, Follow the workaround from KB 272220.

    "To defragment the text or image data and recover the unavailable unused space, use the bulk copy program (BCP) to bulk copy the data out of the table and then back into the table so that the storage will then be contiguous."

Viewing 6 posts - 1 through 5 (of 5 total)

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