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
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
