Test trigger existance

Cry How To - Test trigger existance: "if exists (select * from sysobjects where name='tD_Employee' and xtype='TR')"