How to find all stored procedures used by Report Server?
Report definitions [RDL files] are stored in the "catalog" table of ReportServer database. This table has a field "content" which stores the report definition as an image/text value.
The following query will extract a list of all reports and the stored procedures used by them, by querying the catalog table of report server.
SQL Server And XML: How to find all stored procedures used by Report Server?
1 comment:
Glad to know you found my post interesting. could you contact me off the list? jacob[dot]reliancesp[at]gmail[dot]com
Post a Comment