AFAIK in MS SQL Triggers are considered part of a insert transaction.
Does that mean that if you try to do a trigger on a bulk insert, and something fails in the trigger (even if it is in one SP that is called) the whole thing will NOT insert into the database?
If that's the case, then I may have to rethink the Trigger and the SP!
Paul
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
