Find procedure and function in SQL Server

By Kunal Vaishya 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'
Kunal Vaishya

We make a living by what we get, but we make a life by what we give.

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