XML from SSRS catalog trancated ?

  • 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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply