Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disabling a Trigger
- Thread starter jfield817
- Start date
tlbroadbent
MIS
Use the ObjectProperty function.
If OBJECTPROPERTY(OBJECT_ID('TrgName'),
'ExecIsTriggerDisabled') = 1
Print 'Trigger is disabled"
Else
Print 'Trigger is enabled'
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
If OBJECTPROPERTY(OBJECT_ID('TrgName'),
'ExecIsTriggerDisabled') = 1
Print 'Trigger is disabled"
Else
Print 'Trigger is enabled'
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
- Locked
- Question