AFAIK in MS SQL Triggers are considered part of a insert transaction. Justin
-----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 30 January 2004 10:25 To: [EMAIL PROTECTED] Subject: [ cf-dev ] SQL Server BULK INSERT/Trigger/Stored Proc issue I am doing a bulk insert and using the FIRE_TRIGGERS switch. I have created a trigger that formats the data inserted and then performs a stored proc on it. Now... One of the stored procedures fails, with a really useless error message. I have checked the DB and NO data has been inserted. Is this because the trigger is effectively a transaction, so that if it fails it kills all the updates to the data? Just wondering really. 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] -- ** 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]
