Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
egil
Starting Member
16 Posts |
 Posted - 2008-06-09 : 05:32:13
|
HiSo, I know, after searching these forums, that it is possible to disable a trigger before updating a table and then enabling it again afterwords, for instance, from a stored procedure.I might be dealing with hypotheticals here, but when I do a ...ALTER TABLE table { ENABLE | DISABLE } TRIGGER { ALL | trigger_name [ ,...n ] } ... from a stored procedure, will it not be database wide?Should I worry about another change to the table happening in the timespan in which the trigger is disabled (which it would be for during a single update), which the trigger should have caught?Regards, Egil. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-09 : 05:43:02
|
| If you're disabling the trigger on table, whatever changes happened to table from whatever other ways wont be captured bby trigger until its enabled again. You cant really disable a trigger to make it not pick up changes from one stored procedure only. |
 |
|
|
|
|
|
Can I disable trigger for a single sproc only?