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'
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