> The article did mention trouble coming from the database > itself if ones insert caused a trigger to be fired. Then the > @@identity could return > the generated key from what ever the trigger created.
Yes, and it does. Having had that unpleasant experience once, with an older application, convinced me to switch to using SCOPE_IDENTITY(). Granted, not everyone uses triggers, or ones that involve an identity column on another table, but better safe than sorry. -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4