-
Triggers off
Hello,
I've update triggers on my table, But for some of the transactions, I don't want the triggers to fire. I know in Sybase there are set triggers off. In MS SQL, Is there any similar commands which will set triggers off for particular sql statements.
Thanks A Lot
Sejal
-
You can use ALTER TABLE command to disable or enable a trigger
ALTER TABLE table1 DISABLE TRIGGER trigger1
-
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
|
|