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