-
How do we know if the trigger is 'on' or 'off' on a table?
Any idea where to look for?
thanks,
-
Try this:
select name, objectproperty(id,'ExecIsTriggerDisabled') as disabledTrigger
from sysobjects where objectproperty(id, 'isTrigger') = 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|