Hi All

Currently we are using SQL Server 2000 Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).

Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?

Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797

use ListScheduledReports sp.

EXEC ListScheduledReports 'ScheduledID'

to find out the SP check the design part of reports.