Home Forums SQL Server 2008 T-SQL (SS2K8) Get list of all the tables used in multiple SQL scripts RE: Get list of all the tables used in multiple SQL scripts

  • I actually prefer using sys.dm_sql_referencing_entities. I found that I was getting false positives using the LIKE operator, because people had commented out sections of code, so the table name was still in the definition, but as a comment.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA