Ben Forta discussed a few of these issues in a recent users group presentation. I don't recall the details. You might e-mail him at [EMAIL PROTECTED] and ask. -----Original Message----- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 20, 2000 3:33 PM To: [EMAIL PROTECTED] Subject: Triggers/Stored Procedures - MS SQL 6.5 We have code within Cold Fusion which does updates to a SQL Server database. These updates execute triggers on different fields in the database. Within the triggers, stored procedures are called. When the updates are done in Cold Fusion, the trigger is started but the stored procedures do not execute properly and the update that kicked off the trigger does not complete successfully. When the exact same update statement is done in ISQL, the trigger and the stored procedure execute properly. We have also had some success when different, less processing intensive stored procedures are called from the triggers. Are there settings within Cold Fusion or within SQL Server that will alleviate this issue? Ryan Hartwich [EMAIL PROTECTED] 913-642-1600x223 ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
