Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML from SSRS catalog trancated ? Expand / Collapse
Author
Message
Posted Friday, August 29, 2014 2:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 196, Visits: 487
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
Post #1608745
Posted Friday, August 29, 2014 3:07 PM This worked for the OP Answer marked as solution
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 196, Visits: 487
IT works fine, I think we need to run with command line only the whole thing.
Post #1608749
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse