microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Subscription Rules and Transactions

Subject: Re: Subscription Rules and Transactions
From: Joe Webb
Date: Fri, 05 May 2006 15:24:09 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I haven't attempted to disable transactions as you've asked. But you
could consider replication or SSIS/DTS as a work around. Or you can
pull all the information you'll need in the subscription during event
collection. 

HTH...



-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On 26 Apr 2006 05:14:38 -0700, "RDV" <[email protected]> wrote:

>Hello All:
>
>When you define you subscription rule in the ADF file for a particular
>class it ultimately becomes part of a stored procedure (NSFire) that is
>called by the generator.
>
>This automatically created stored procedure encapsulates your rule in a
>transaction (Begin Transaction)
>
>I am using a linked server to retrieve some data to use in the
>subscription rule.  The OLEDB provider that I am using does not support
>transactions.
>
>The error is as follows:
>
>The operation could not be performed because the OLE DB provider
>'MSDASQL' was unable to begin a distributed transaction.
>
>Note that this is because of the underlying ODBC driver that I am using
>with the OLEDB provider for ODBC.
>
>What are my options for making this scenario work?
>
>Is there a way to disable transactions for my logic and have it
>re-enable ?

<Prev in Thread] Current Thread [Next in Thread>
  • Re: Subscription Rules and Transactions, Joe Webb <=