Saber si trigger esta activo o inactivo - SQL Server

Use mi_basedatos

GO

select    cast (name as char(60)) as [Trigger], case when (status & 0x800)= 2048 then 'Inactivo' else 'Activo' end as status

from      sysobjects

where type='TR'