How can you tell if a trigger is enabled in SQL Server 2000

Question

This shouldn't be hard to do. I'd expect Enterprise Manager to show a folder of trigger and a list and an icon... but I don't see it anywhere. My google results get me answers where I have to write code. Are you kidding me? The only way is by writing code?

Answer 1

SELECT
CASE OBJECTPROPERTY(OBJECT_ID('trigger name goes here'), 'ExecIsTriggerDisabled')
WHEN 0 THEN 'ENABLED'
ELSE 'DISABLED'
END

Answer 2

In Enterprise Manager drill down through databases -> and select tables

In the details pane, right click on the table in question and select 'Manage Triggers' and Vuala! You should be able to find what you're looking for in there

Answer 3

This query will return all triggers and their status as well as what table the trigger is for.

SELECT so1.name as TriggerName, CASE OBJECTPROPERTY(OBJECT_ID(so1.name), 'ExecIsTriggerDisabled') WHEN 0 THEN 'ENABLED' ELSE 'DISABLED' END AS Status, so2.Name as TableName FROM SysObjects so1 JOIN SysObjects so2 ON so2.Id = so1.Parent_obj WHERE so1.type = 'TR'

Answer 4

The two answers with SQL queries were exactly what I needed. Thanks!