July 2009

Time and time again, I find myself trying to find all the stored procedures that reference a specific database object.  It usually comes around when I’m working on changes to a table’s structure, or I’m replacing a table with a view.  I’ll usually reach for the following query (or something like it. 1: SELECT ROUTINE_NAME…

Read More Find Stored Procedures Referencing…