Dear. Please Help me out What system stored procedure for extracting the query from SSRS.(sql server reporting services)

Can you give more info on what you need ?Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Are you trying to use the Stored procedures from within ReportServer Catalog databases? This is technically unsupported, as there is every possibility that your Catalog DBs might get corrupted if not dealt properly. There are WMI Providers, and APIs available to extract data from SSRS Catalog databases. I would suggest you to follow that path: Reporting Services WMI Provider Class Library Reporting Services WMI Provider Library Reporting Services Web Class Library ReportService2010 ReportService2006 ReportExecution2005 ReportService2005 ReportServiceAuthentication Hope this helps.. Chaitanya( Twitter | Blogs ) Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles. This posting is provided "AS IS" with no warranties, and confers no rights.

Hello. I want to know how can i extract Sql query by system stored Procedure from sql server Reporting Services.......... It mean I have the Existing SSRS and how can i Retrieve sql query from that report.

Hello. I want to know how can i extract Sql query by system stored Procedure from sql server Reporting Services.......... It mean I have the Existing SSRS and how can i Retrieve sql query from that report.

Per my knowledge there is no ready made system proc for this. But you can extract the data from the Catalog table from Reportserver database. You can try the below Utility stored procedure to derive all the details about a report http://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c Moderator : Please merge this below duplicate thread with this one http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/95876ed5-7b1a-457b-88f3-d692f7bc7c13/#d2772264-73e6-4e84-b38f-c66e1d18df18

Also check: http://tejasnshah.wordpress.com/2009/02/21/sql-server-how-to-stored-procedure-names-used-by-reports-sql-reporting-services/ Chaitanya( Twitter | Blogs ) Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles. This posting is provided "AS IS" with no warranties, and confers no rights.