CODEWITHSUNDEEP
sql-serversql-server-2008t-sqltriggers
Vikrant More
Vikrant More

Reputation: 5442

SQL Server: check whether a Trigger is Enabled or Disabled?

How we can see which Trigger is Enabled or Disabled in SQL Server 2008?

Upvotes: 68

Views: 79435

Answers (3)

ikram.chatha
ikram.chatha

Reputation: 51

Descriptive State of Trigger help you to clearly ready about status. Also excluding triggers not related with user tables.

Check the below code:

SELECT OBJECT_NAME(parent_id) [Table_Name],[name] [Trigger_Name],
Case When is_disabled=0 then 'Enabled' Else 'Disabled' End [Trigger_Status], is_disabled
FROM sys.triggers 
where OBJECT_NAME(parent_id) is not null

Upvotes: 5

Igor Micev
Igor Micev

Reputation: 1652

In big databases you usually don't know the table for the trigger.

SELECT OBJECT_NAME(parent_id) [table_name],[name] [trigger_name],is_disabled
FROM sys.triggers

Upvotes: 8

gbn
gbn

Reputation: 432210

Using sys.triggers

SELECT name, is_disabled FROM sys.triggers

Upvotes: 113

Related Questions