Textcopy Error

• mcbtiger420

  SSC Journeyman

  Points: 76

  More actions

  December 31, 2009 at 11:34 am

  #215011

  hello Dear

  My problem is to insert image in Sql server .I use Textcopy

  but it giving me Errors:Text or Image pointer and timestamp retrieval failed.My image file extention is Bitmap please reply me quickly

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  January 22, 2010 at 3:07 am

  #1107199

  What data type are you using and why?

  Consider switching to varbinary - either max if you'r images can be larger that 8000 bytes, or a more appropriate length.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com