Hi, I have run a simple test on SQL 2008 and the transaction got promoted to DTC just as with SQL 2005 on opening a second connection with same connection string. But maybe there is an option to tell it to try harder to keep the transaction local.
R On Nov 10, 3:36 am, Corey Kaylor <[email protected]> wrote: > I suppose if you were using SQL Server 2008. It might be an option to keep > things transactional and have the Queue schema reside within the same > database the consumers are reading from. I'm not even sure if this is > entirely reasonable or at what point sql server will still promote the > transaction, but I'll try to put together a sample to see what happens. It > would end up looking something like below. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en -~----------~----~----~----~------~----~------~--~---
