Puteti folosi ca model urmatorul script:

USE AdventureWorks;
GO
SELECT
[name],
OBJECT_DEFINITION(object_id) [procedure_text]
FROM sys.procedures
WHERE patindex(N'%@StartProductID%',OBJECT_DEFINITION(object_id)) > 0

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro