Getting lists of DB Objects for looking at specific Tables used in Stored Procedures or Functions.

Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 187
Write below query:-
select distinct as DB_Object from syscomments A 
inner join sys.objects B
on = B.object_id
where A.text like '%your_table_name%';

Above query will return Store Procedures,Functions where your_table_name is present.

Comments or Responses

Login to post response