Delete rdl files from SSRS report services
Before deleting report in report server USE [ReportServer] GO --Replace NULL with keywords of the ReportManager's Report Path, --if reports from any specific path are to be deleted DECLARE @FilterReportPath AS VARCHAR ( 500 ) = NULL --Replace NULL with the keyword matching the Report File Name, --if any specific reports are to be deleted DECLARE @FilterReportName AS VARCHAR ( 500 ) = 'List Report' --Used to prepare the dynamic query DECLARE @TSQL AS NVARCHAR ( MAX ) --Prepare the query to delete the report files. SET @TSQL = STUFF (( SELECT '; ' + ' ;DELETE ' + ' F...