Tuesday, March 24, 2015

How Search Text In SQL Storeprocedure

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0
AND OBJECT_DEFINITION(OBJECT_ID(SPECIFIC_NAME)) like '%Procedure Name%'
AND ROUTINE_TYPE='PROCEDURE'

No comments :

Post a Comment