disable triggers

Hi,
How do I foind out whether the triggers in a sql table is enabled or not?
THanksAre you using SQL Server? What version? In SQL Server 2005 you can look at
the is_disabled column in sys.triggers
...
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ud17l6t9HHA.5164@.TK2MSFTNGP05.phx.gbl...
> Hi,
> How do I foind out whether the triggers in a sql table is enabled or not?
> THanks
>|||Check out the metadata function OBJECTPROPERTY in SQL Server Books Online.
You can use the ExecIsTriggerDisabled for the property argument to find if a
trigger is enabled or not.
--
Anith|||I believe this is gonna work for you.
USE <your_database_name>
SELECT * FROM sys.triggers WHERE is_disabled = 1
--
Ekrem Önsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ud17l6t9HHA.5164@.TK2MSFTNGP05.phx.gbl...
> Hi,
> How do I foind out whether the triggers in a sql table is enabled or not?
> THanks
>