Viewing table dependencies will show you what SP’s depend on the table, but what if you need to find those SP’s which only reference a single field. The following queries will provide you with a list of SP’s which contain the reference you are searching for. SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE ‘%look for me%’Read more about How to search all Stored Procedures for a reference[…]

To suppress the rows affected message from printing use the following TSQL statement: SET NOCOUNT ON