Does it happen to you when you need to modify a table in the existing stored procedures in a large database, and that table is in a few stored procedures? Your first task is finding all the stored procedures to reference that table.
You can use the following to find them all.
-- This will find all the stored procedures which use table xyz in the current database
select distinct object_name(id)
where text like '%xyz%'
Powered by Exsilio Solutions