 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / June 2006List of Procedures used in RDL on Production site
Is there a way to search all of the RDL's that have been deployed out to a Reporting Services site? I am looking for what stored procedures are being used on our production reporting site. Any help would be appreciated. All the deployed reports are stored in a table called "catalog" you can get a list by querying the table. Amarnath > Is there a way to search all of the RDL's that have been deployed out to a > Reporting Services site? I am looking for what stored procedures are being > used on our production reporting site. > Any help would be appreciated. I appreciate the response, but this is not what I am looking for. I need to search the content inside every single rdl to see what stored procedures are being used. If there isn't a way to do this in RS, is there a way to do this from vss? > All the deployed reports are stored in a table called "catalog" you can get a > list by querying the table. [quoted text clipped - 5 lines] > > used on our production reporting site. > > Any help would be appreciated. OK You said "deployed" so I gave that answer... You can search for "<CommandType>StoredProcedure</CommandType>" and the next line will be the stored procedure name. and select look in "Current project" from the find dialog box. Hey this looks very basic, is this what you want ? Amarnath > I appreciate the response, but this is not what I am looking for. > I need to search the content inside every single rdl to see what stored [quoted text clipped - 10 lines] > > > used on our production reporting site. > > > Any help would be appreciated. Deployed is correct. I need to search every single rdl deployed to our RS site. I need to find what stored procedures are used in each rdl. I do not seem to be able to do this from the ReportServer database. I know how to do this from the rdl when in working with the rdl on its own in Visual Studio, but I have over 500 reports in RS. I need a quick and painless way to search all of the rdl’s at the same time to see their stored procedures. I do appreciate the response, I just have a feeling this can not be done... > OK You said "deployed" so I gave that answer... > You can search for "<CommandType>StoredProcedure</CommandType>" and the next [quoted text clipped - 19 lines] > > > > used on our production reporting site. > > > > Any help would be appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.