Post reply

How to get list of tables used in SSRS reports

  • June 20, 2013 at 9:56 am

    #274264

    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

    DBDigger Microsoft Data Platform Consultancy.

  • June 21, 2013 at 4:31 am

    #1626267

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply