viernes, 26 de junio de 2015

Search String on Multiples Stored Procedures

The goal is search the '***' string, including single comma.

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 AND definition LIKE '%''***''%';