Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disabling a trigger for a session
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Disabling a trigger for a session
Miscellaneous
Thread ID:
00719302
Message ID:
00719302
Views:
55
Hi,

is there a way to do a update command without firing the update trigger for a session?

we can't use the "alter table table1 disable trigger UpdTrig1" because it will affect all session.


I was thinking of using the not for replication option of the trigger.
Is there a way to "fool" the trigger to believe that i'm in a replication update?

Alain
Analystik Team
1430 Belanger
Montreal (Quebec)
Canada
(514) 278-2727
analyste@analystik.ca
Next
Reply
Map
View

Click here to load this message in the networking platform