var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
can a trigger on a table be fired after a bulk insert???
you can specify the option 'FIRE_TRIGGERS' in a bulk insert statement (see under bulk insert in books online). IF this option is set, insert triggers are fired after every batch. So if you use one batch, the trigger is fired only once.
If your doing a BULK INSERT, then it's most likely a batch process, so why use a trigger?
Make it part of that unit of work....
It's a Great Day for America everybody!
dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was
The physical order of data in a database has no meaning.
sorry but i don't understand... what do u mean???
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors