Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Gene Wirchenko Newsgroups: comp.databases.ms-sqlserver Subject: Re: Trigger help Date: Thu, 05 Apr 2012 08:24:54 -0700 Organization: A noiseless patient Spider Lines: 27 Message-ID: <40ern79acjnml3m6smsa2unehpp733d18o@4ax.com> References: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> <17890250.1123.1333548317738.JavaMail.geo-discussion-forums@pbcoy7> <26993464.772.1333631164888.JavaMail.geo-discussion-forums@pbcov6> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Info: mx04.eternal-september.org; posting-host="wKah3EH8kutwAOV6+9FiEQ"; logging-data="29874"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18xZD6Xao5h2soylfnQQ/9553nk+wKbeL0=" X-Newsreader: Forte Agent 4.2/32.1118 Cancel-Lock: sha1:7ZsZmDVNQZWzaqNYaVI4bYq4rRI= Xref: csiph.com comp.databases.ms-sqlserver:960 On Thu, 5 Apr 2012 06:06:04 -0700 (PDT), Johnnyb wrote: >Even with 'AFTER' I get this in my replication monitor: >Command attempted: >if @@trancount > 0 rollback tran >(Transaction sequence number: 0x00000771000FB566000300000000, Command ID: 1) > >Error messages: >The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "DB02TSSNT" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391) >Get help: http://help/7391 >The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "DB02TSSNT" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391) >Get help: http://help/7391 You really ought to have posted this with your previous post. I would not have replied since it is obviously outside of what I know. Erland (and others knowledgeable) would have had more to work with. This link is *very* useful: http://www.catb.org/~esr/faqs/smart-questions.html How To Ask Questions The Smart Way [snip] Sincerely, Gene Wirchenko