SELECT
o.name AS ProcedureName,
c.text AS ProcedureDefinition
FROM sysobjects o
JOIN syscomments c ON o.id = c.id
WHERE o.xtype = 'P'
AND c.text LIKE '%LockFlag = 200%';
SELECT
o.name AS ProcedureName,
c.text AS ProcedureDefinition
FROM sysobjects o
JOIN syscomments c ON o.id = c.id
WHERE o.xtype = 'P'
AND c.text LIKE '%LockFlag = 200%';