Image typed column on Linked Server

• thinknight

  SSCrazy

  Points: 2068

  More actions

  September 15, 2009 at 1:04 am

  #135014

  Hi All,

  I have problem while querying table that contains image typed column.

  I could not select top 10 record from a table which contains Image typed column.

  How do i fix it?

• oraculum

  SSCrazy

  Points: 2981

  More actions

  September 15, 2009 at 2:58 am

  #1053639

  I have just tried this and it works fine via linked server...

  select top 10 image_data from [server].database.dbo.Documents where DATALENGTH(IMAGE_DATA) is not null

  Oraculum