Trigger Status?

RiyaKumar · Mar 3, 2005

Hi,

Can someone tell me how to identify if a trigger is Enabled or Disabled?

Thanks.

dbomrrsm · Mar 3, 2005

not sure you can disable a trigger in sql server as in oracle

[bandito]

[blue]DBomrrsm[/blue] [bandito]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

RiyaKumar · Mar 3, 2005

ALTER TABLE <Table_name> ENABLE TRIGGER <trig_name>
is available in SQL Server.

RiyaKumar · Mar 4, 2005

Is there any way to identify whether the trigger is enabled or disabled?

RiyaKumar.