Un altul ar fi :

select text from syscomments

where id in (select id from sysobjects where name='uDepartment') 

daca va intereseaza triggerul uDepartment din tabela HumanResources.Department din baza de date

AdventureWorks 

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)