Microsoft’s SQL Server Reporting Services, colloquially known as SSRS, provides a great way to expose data from SQL Server in human-consumable form, typically via a web site. Generally, it’s a good idea to use a stored procedure as the source of data for SSRS Reports. In a large SSRS environment, it can be challenging to determine which reports use a specific stored procedure.
This code provides details about SSRS Reports where the definition of the report includes any specific keyword, such as the name of a stored procedure.
Click through for a query against ReportServer.