Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Query to Display Trigger Status

By Additional Articles,

Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful properties that can be returned, see help for the ObjectProperty command for more details. The code below lists all tables that have a trigger and the status of that trigger.

Total article views: 1019 | Views in the last 30 days: 2
 
Related Articles
FORUM

ObjectProperty returning Null

Trying to find out if a Trigger is enabled

FORUM

Trigger

Trigger

FORUM

Triggers

Trigger

FORUM

Triggers

Trigger

FORUM

trigger

trigger

 
Contribute