image size

• Md Jahangir Hossen

  SSC Enthusiast

  Points: 131

  More actions

  March 21, 2007 at 6:22 am

  #172584

  Hi everyone

  I stored an imaged in a column that data type is image

  Image size is 114 kb

  After some days image size automatically decreased to 64 kb and it half of that image show black.

  IS there any way to fixed it. Would really appreciate some help.

  Thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 22, 2007 at 12:06 am

  #696305

  I don't think there is any fix within the sql...

  But how it got half of the original image...sql will not shrink then who did?

  MohammedU
  Microsoft SQL Server MVP

• Md Jahangir Hossen

  SSC Enthusiast

  Points: 131

  More actions

  March 22, 2007 at 2:09 am

  #696311

  Thanks for reply

  ms sql sp3 is applied

  one more thing that images replicated from Head Office server

  to branch server. Image of branch server lost partially

  but image in head office server never lost

  Jahangir