Find Store Procedures and Functions in MS SQL Server.
Hi Friends , This article will help you to find Store Procedures and Functions in Microsoft SQL Server. Execute this Script which i mentioned below. ROUTINE_TYPE = 'PROCEDURE' OR 'Function' Select ROUTINE_TYPE , SPECIFIC_NAME , ROU TINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE OBJECTPROPERTY ( OBJECT_ID ( SPECI FIC_NAME ), 'IsMSShipped' ) = 0 AND ROUTINE_DEFINITION like '%PrcName%' AND ROUTINE_TYPE = 'PROCEDURE'