ssrs

SQL Server - Download all RDL files from Report Server

ben himself's picture
---- Allow advanced options to be changed.
--EXEC sp_configure 'show advanced options', 1
--GO
---- Update the cuently configured value for advanced options.
--RECONFIGURE
--GO
---- Enable xp_cmdshell
--EXEC sp_configure 'xp_cmdshell', 1
--GO
---- Update the cuently configured value for xp_cmdshell
--RECONFIGURE
--GO
---- Disallow further advanced options to be changed.
--EXEC sp_configure 'show advanced options', 0
--GO
---- Update the cuently configured value for advanced options.
--RECONFIGURE
--GO
 
--Replace NULL with keywords of the ReportManager's Report Path,

Tags: 

Pages

Subscribe to RSS - ssrs