Russ wrote: > Is there a way to simulate this? maybe run 2 templates and put some sleep > code in between so I can see that it's not getting the same record twice?
The easiest way to simulate this is from a command line SQL client (Enterprise Manager will also work). In the first instance run: begin; select pk from table where pk = X for update; Then in the second instance run: begin; select pk from table where pk = X for update; You will see that the second instance will do nothing until you rollback or commit the first one. Then try again but this time with the nowait option (though I don't know if MS SQL Server has that option). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
