Find procedure and function in SQL Server

By Kunal Vaishya Blogs | SQL Oct 26, 2012
Find procedure and function from this query.

ROUTINE_TYPE = 'PROCEDURE' OR  'Function'

 

Select ROUTINE_TYPE,SPECIFIC_NAME,ROUTINE_DEFINITION

FROM   INFORMATION_SCHEMA.ROUTINES

WHERE  OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0

       AND ROUTINE_DEFINITION  like '%prcleave%'

       AND ROUTINE_TYPE='PROCEDURE'
COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs