Un posibil raspuns este folosind OBJECT_DEFINITION:
USE AdventureWorks;
GO
SELECT
OBJECT_DEFINITION (OBJECT_ID(N'HumanResources.dEmployee')) AS [Trigger Definition];
GO
For all triggers of a table:
USE AdventureWorks;
GO
SELECT
[name] as TiggerName,
OBJECT_DEFINITION([object_id]) AS [Trigger Definition]
FROM sys.triggers
WHERE parent_id=OBJECT_ID(N'Purchasing.PurchaseOrderDetail');
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro