XML from SSRS catalog trancated ?

• mario17

  SSCertifiable

  Points: 6079

  More actions

  August 29, 2014 at 2:10 pm

  #397277

  Hi,

  I tried to get all rdl's from ReportServer db for full inventory using super script from Vinay Pugalia(c). and could not get complete xml, it broken/truncated I'm not sure why.

  in each case it's on different length so I assume it's not a max length problem, did anybody tried to do this?

  This is just relevant section to test.

  select LEN(Contx) FROM (

  SELECT TOP 1 CONVERT(VARCHAR(MAX), CASE WHEN LEFT(C.Content,3) = 0xEFBBBF THEN STUFF(C.Content,1,3,'''')

  ELSE C.Content END) Contx

  FROM [ReportServer].[dbo].[Catalog] CL

  CROSS APPLY (SELECT CONVERT(VARBINARY(MAX),CL.Content) Content) C WHERE CL.[Type] = 2

  )B

  Thanks

  Mario

• mario17

  SSCertifiable

  Points: 6079

  More actions

  August 29, 2014 at 3:07 pm

  #1742029

  IT works fine, I think we need to run with command line only the whole thing.