Is it possible to view (display) a Varchar(max) saved in in a Table.

• glyn_lamb

  Valued Member

  Points: 62

  More actions

  November 1, 2022 at 4:39 am

  #4107088

  I have an old database sql server 2008R2 from Microsoft Dynamics CRM 2011 which users need to view old data.

  I have been able to recreate searches for entries however have stumbled on one problem.

  1 table contains documents/spreadsheets/messages/text etc stored as a varchar(max) with a filename and a mimetype.

  [MimeType] [nvarchar](256) NULL,

  [DocumentBody] [varchar](max) NULL,

  [FileSize] [int] NULL,

  [FileName] [nvarchar](255) NULL

  Is it possible to display this data in a SSRS report or convert and save this data outside of SQL server to be read by the the appropriate software (outlook,excel,word, etc).

  I have attempted to use sp_OACreate,sp_OAMethod etc to save the files, it creates the name but does not load any data.

  Any help or assistance would be greatly appreciated.

  SSRS is 2016

  Thanks

  Glyn Lamb

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  November 2, 2022 at 5:10 am

  #4107600

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.