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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics