SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

8/07/2013

SSRS – Download all RDL files from Report Server in one go.

Introduction People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files) at one go out-of-box. And I am sure that many of you might have come across this requirement some day or other. Hence, today I will share a simple handy script which would help you to download all the required report files at once. Implementation SSRS uses SQL Server to store it’s details as a backend and the Catalog table is used to store the report file in binary form. The below script simply pulls...