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

sql-server sql-server-2008 tsql triggers
Vikrant More picture Vikrant More · Nov 15, 2011 · Viewed 54k times · Source

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

Answer

gbn picture gbn · Nov 15, 2011

Using sys.triggers

SELECT name, is_disabled FROM sys.triggers

Related questions

How can I edit values of an INSERT in a trigger on SQL Server?

I have the table Tb ID | Name | Desc ------------------------- 1 | Sample | sample desc I want to create a trigger on INSERT that will change the value of the inserting Desc, for example: INSERT INTO Tb(Name, Desc) VALUES ('x', 'y') Will …

Read More
How do I prevent a database trigger from recursing?

I've got the following trigger on a table for a SQL Server 2008 database. It's recursing, so I need to stop it. After I insert or update a record, I'm trying to simply update a single field on that table. Here's …

Read More
SQL Server 2008 - Does a trigger run with the same permissions as the login/user?

Just a quick question: Say I put an insert trigger on a table in my database. If data is inserted into that table through a login/user "foobar". Does the trigger execute with the same access rights / permissions as "foobar"? …

Read More