July 13, 2009 at 2:36 pm
I have a huge (21 gb) table in my datawarehouse that I am trying to prove is never used by anything, so we can get rid of it. I did a search on my local machine of my Visual Studio projects to try to figure out if I have ever used this in a report. Zero results returned, yippy, but the results returned were so fast I thought something is up so I searched for a table I use all the time, zero results returned. So I was looking to see if I could use the database to search for the query used by the dataset, but I can't find it in the database. If I open the RDL file I can see the query, but I don't want to have to open 300+ rdl files. Suggestions?
July 13, 2009 at 10:57 pm
If you are searching the rdl files in Windows Explorer, you may have the problem I had, where it wasn't searching the files. I used Method 2 from here, which resolved the issue for me: http://support.microsoft.com/kb/309173
To search the ReportServer database, check out this link. It will return the stored procedure or query used: http://blog.beyondrelational.com/2008/01/how-to-find-all-stored-procedures-used.html
Also check out the comments. I had some issues with the code originally posted, and I posted my resolution there.
Hope that helps!
-Marianne
July 14, 2009 at 9:26 am
The first thing for the search on my local machine worked great. Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply