Hi All,
A tricky question is being asked by my manager for the reports which are deployed on the production server.
He had given some set of the database objects for e.g. Table1,sps1,sps2 and questioned how many SSRS Reports are referring this tables and sps , views ?
There are thousands of the reports are deployed on the server. Do I have to download all .rdl report files open them in Visual Studio open the dataset and see to it which reports are referring these Tables or sps.
Or
Is there any trick,tool,system procedure in reportServer database/principal database by which we can find the SQL constructs, db objects used in the tables.
Much Thanks for the help I am getting here .. and tons of the wishes for the Thanks Giving Day.
-VKD