SQL Server How to find if any stored procedure is referencing database object

madeinstein , 
select StoredProcedureName = p.name

from sys.sql_modules sm

inner join

sys.procedures p

on sm.[object_id] = p.[object_id]

where [definition] like '%Database_Object_Name%'

Comments

  1. Tales of a Starbucks Addict3 February 2011 at 17:24

    If you are using the SQL Server Management studio you can also right click on the table and view dependencies.

    Great blog by the way

    ReplyDelete

Post a Comment