Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get list of tables used in SSRS reports Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 9:56 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:29 AM
Points: 431, Visits: 978
We have to mark the tables for replication to reporting database. What are the options to get the list of all tables that are being used by SSRS report definitions?

Thanks


=============================================================
Atif Shehzad
DBA
Zin Technologies
Post #1465801
Posted Friday, June 21, 2013 4:31 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 2:24 AM
Points: 766, Visits: 841
I dont think you can. You have to bear in mind that it may not use tables - it may use views or stored procedures or suchlike.... which then use tables.

In theory it could use a stored proc, that references a view, that references 4 views, that references 10 tables. Imagine trying to inwind all of that.

Dan
Post #1466119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse