Are triggers pre-compiled like SPs?

I am under the impression that triggers are not pre-compiled like SP's. True or false?

Yep they are and here is the change between 2000 and 2005. Hope this helps.

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

|||Are functions also now pre-compiled in SQL Server 2005?|||

sun21170:

Are functions also now pre-compiled in SQL Server 2005?

If you mean UDF(user defined functions) I think they were precompiled even in 2000. Hope this helps.