Answers for "search for stored procedure sql server"

sqlserver: how to search a table used in particular stored procedure

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'

Posted by: Guest on May-26-2020

search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

Posted by: Guest on October-30-2020

Code answers related to "search for stored procedure sql server"