April 15, 2003 at 5:57 am
I want to disable insert triggers only when a bulk insert is performed and enable it for all other insert options. Is it possibel in SQL Server and if yes, please tell me how?
April 15, 2003 at 6:14 am
You don't have to do anything. By default, insert triggers are disabled for bulk insert anyway.
If you want them enabled, you have to specify the 'FIRE_TRIGGERS' option on the bulk insert statement
April 15, 2003 at 6:32 am
Thank you. Is there any way to disable insert and update triggers defined on a particular table for some transactions and all others they should be enabled.
April 15, 2003 at 7:01 am
No, it's all or nothing. You could modify the trigger so that it would ignore changes from a particular user or host, that way you could leave the trigger enabled.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply