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

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 852
Write below query:-
select distinct B.name as DB_Object from syscomments A 
inner join sys.objects B
on A.id = 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