Forces SSRS catalog to update report definition based on report content.

SSRS - Force Description Update.sql

USE ReportServer;

WITH XMLNAMESPACES
(
    'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd,
    DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
)
--SELECT Report.value('(.)[1]', 'nvarchar(512)')
UPDATE c
SET c.Description = Report.value('(.)[1]', 'nvarchar(512)')
FROM dbo.Catalog AS c
    CROSS APPLY (
		SELECT CONVERT(xml, CONVERT(varbinary(MAX), Content)) AS ContentXml
	) AS ca
    CROSS APPLY ca.ContentXml.nodes('/Report/Description') AS T2(Report)
WHERE Path LIKE N'/%'
      AND c.Description <> Report.value('(.)[1]', 'nvarchar(512)');


WITH XMLNAMESPACES
(
    'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd,
    'http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition' AS cl,
    DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'
)
--SELECT Report.value('(.)[1]', 'nvarchar(512)')
UPDATE c
SET c.Description = Report.value('(.)[1]', 'nvarchar(512)')
FROM dbo.Catalog AS c
    CROSS APPLY (
		SELECT CONVERT(xml, CONVERT(varbinary(MAX), Content)) AS ContentXml
	) AS ca
    CROSS APPLY ca.ContentXml.nodes('/Report/Description') AS T2(Report)
WHERE Path LIKE N'/%'
      AND c.Description <> Report.value('(.)[1]', 'nvarchar(512)');

Thank you for publishing this script. It helped me!