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 |
|
havejeet
Starting Member
5 Posts |
 Posted - 2009-05-23 : 08:19:49
|
| Hi all,I have written a C# windows app, that bulk insert bunch of data into one of the SQL server table - the target table has insert trigger defined on. But sadly - the trigger does not fire with SqlBulkCopy. I tried one enumeration from .Net class - that enables the trigger to fire but - it fires only after ALL records inserted. I want trigger to fire for each individual record while is being written.please suggestthanksJeetregardsJeet |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-23 : 09:42:54
|
Trigger does not necessary fired upon every record inserted or updated. If you are having problem with your trigger, it means your trigger is not written to handle more than one records.read this http://www.sqlteam.com/article/an-introduction-to-triggers-part-i
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-23 : 11:30:59
|
| it would probably best to post your current trigger logic and then tell what exactly you're trying to do in which case somebody can rewrite it for you. |
|
|
|
|
|
|
insert trigger - sqlbulkinsert