Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-sqlserver > #960

Re: Trigger help

From Gene Wirchenko <genew@ocis.net>
Newsgroups comp.databases.ms-sqlserver
Subject Re: Trigger help
Date 2012-04-05 08:24 -0700
Organization A noiseless patient Spider
Message-ID <40ern79acjnml3m6smsa2unehpp733d18o@4ax.com> (permalink)
References (1 earlier) <XnsA029F1A89853BYazorman@127.0.0.1> <17890250.1123.1333548317738.JavaMail.geo-discussion-forums@pbcoy7> <argpn754h51a6qub9pgha9v5sjtbg3ca3c@4ax.com> <XnsA02C5CF1FE1D4Yazorman@127.0.0.1> <26993464.772.1333631164888.JavaMail.geo-discussion-forums@pbcov6>

Show all headers | View raw


On Thu, 5 Apr 2012 06:06:04 -0700 (PDT), Johnnyb
<john.lutheran@gmail.com> 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

Back to comp.databases.ms-sqlserver | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-03-29 05:47 -0700
  Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-03-30 07:35 -0700
  Re: Trigger help bradbury9 <ray.bradbury9@gmail.com> - 2012-03-29 15:46 -0700
  Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-02 23:45 +0200
    Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-02 15:04 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-03 07:33 +0000
    Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-02 20:52 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-03 07:26 +0000
        Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-03 05:03 -0700
        Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-03 08:17 -0700
    Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-04 07:05 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-04 23:45 +0200
      Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-04 14:58 -0700
        Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-05 09:08 +0200
          Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-05 06:06 -0700
            Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-05 08:24 -0700
            Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-05 23:51 +0200
          Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-05 08:19 -0700

csiph-web