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

Re: Trigger help

Path	csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Trigger help
Date	Thu, 05 Apr 2012 23:51:42 +0200
Organization	Erland Sommarskog
Lines	29
Message-ID	<XnsA02CF2BC25AA4Yazorman@127.0.0.1> (permalink)
References	<11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> <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>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="4295"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+4TMF1B004DUuyeUql0uUQ"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:42pr4hSL5fuTS9DAEtvsYjTP4zI=
Xref	csiph.com comp.databases.ms-sqlserver:961

Show key headers only | View raw

Johnnyb (john.lutheran@gmail.com) writes:
> 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

That may be difficult to overcome. I'm not always successful myself.

Are these two servers in the same domain? Are they in a domain at all?

Since you already have replication in place, maybe it would be better
to set up the database as a subscriber, and then have a replication
filter, so that only the relevant rows are inserted?

As I said, linked servers in triggers can be a headache, and I would
certainly like to try alternative solutions.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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