all groups > sql server notification services > february 2007 >
You're in the

sql server notification services

group:

NS Management API & Transactions


NS Management API & Transactions Andy
2/21/2007 5:28:47 AM
sql server notification services:
Hi,

I have some subscription management code which is part of a larger
update. I'd like the whole thing to run within a transaction. If I
simply use the new TransactionScope and keep all my update logic + the
API calls within the scope, will the ENTIRE set of updates occur
within a transaction?

Andy
Re: NS Management API & Transactions Andy
3/28/2007 10:50:48 AM
[quoted text, click to view]

For those wondering, yes, this is possible, but it will cause the
transaction to promote to a distributed transaction.

Andy
AddThis Social Bookmark Button