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 |
|
alisamiee
Starting Member
2 Posts |
 Posted - 2008-11-11 : 04:18:38
|
| in some conditions , sql adds line " alter table ... disable trigger ... " to the end of trigger !!! i think, it wants to remove it later, but cus of an error , jumps out (maybe) !?plz help me if you know about it |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 04:22:36
|
| can you illustrate any one condition when you noticed this? was it while doing some bulk insert operation? |
 |
|
|
alisamiee
Starting Member
2 Posts |
Posted - 2008-11-13 : 11:33:09
|
| the trigger i talk about is an "OnInsert" one , but i don't exactly know when this happens .i wan'a know in which cases SQL does such a foolish task. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 11:37:06
|
quote:
Originally posted by alisamiee
the trigger i talk about is an "OnInsert" one , but i don't exactly know when this happens .i wan'a know in which cases SQL does such a foolish task.
i firmly believe it might have happened during bulk insert operationhttp://msdn.microsoft.com/en-us/library/ms187640.aspx |
|
|
|
|
|
|
SQL Server disables my trigger !!!