James Holmes wrote: > Can you write an inline TSQL block and specify it in that?
No: <quote> A transaction cannot be set to SNAPSHOT isolation level that started with another isolation level; doing so will cause the transaction to abort. If a transaction starts in the SNAPSHOT isolation level, you can change it to another isolation level and then back to SNAPSHOT. A transaction starts at the BEGIN TRANSACTION statement. </quote> http://msdn2.microsoft.com/en-US/ms173763.aspx I could rip out all cftransaction tags and replace them with custom versions, but for this application that is not a very appealing prospect. If I could find how to change the default transaction isolation level from read-committed to snapshot for all transactions in the database (cross database transactions are not relevant for the issue at hand) I would be happy too, but I can not find that option either in MS SQl Server 2005. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
