Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Script to Generate Table to Stored Procedure Cross References

By Marcus Dallasandro, 2016/01/18

Lists Tables and Store Procedure references. Runs a bit slow but appears to be accurate. Just paste this script into SSMS for the desired database.

WITH TableList_CTE (TableName)
AS
(
SELECT TABLE_NAME + CHAR(32) as TableName
   FROM INFORMATION_SCHEMA.TABLES T
  WHERE t.TABLE_TYPE='BASE TABLE'
 )
SELECT TableName,OBJECT_NAME(object_id) as StoredProcedure
	FROM  sys.sql_modules S
	Join TableList_CTE on 1=1
    WHERE objectproperty(object_id,'IsProcedure') = 1
    AND CHARINDEX(TableName,Definition,0)<>0
  Order by TableName

Total article views: 4284 | Views in the last 30 days: 1