Is a column of a table used in any report on the report manager?
Hello,
i want to check if I use a certain database table column in any of my Reports on the Reports Manager 2005
Do I have to check every SQL statement of every Report or is there another - more sophisticated way available?
thanks for the answer!
May 17th, 2011 6:47am
Do you have the reports in Visual Studio? If they are in a solution you can use find, option search entire solution to find all the reports that use the database table column you are after.FredSQL
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 7:38am
Thanks for your answer! What a pitty we got this column in about 20 Tables! So i have to manually decide if the column belongs to the table or not. I guess there is no way to check this automatically?!
May 17th, 2011 8:17am
Instead of searching for the column, you should be searching for the table name if the column name exists in more than one table.FredSQL
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 8:32am
Jeah, I am already doing that. But i still get a lot of findings...
May 17th, 2011 8:45am