Write trigger to update linked server

From: larrychan (anonymous_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Thu, 9 Sep 2004 21:34:47 -0700

I write a trigger on a table and update another table in a
linked server. There is an error message .

SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver][SQL Server]
Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This
ensures consistent query semantics. Enable these options
and then reissue your quer...

Anyone can help on this?

Relevant Pages

  • Re: NEED TO CALL AS400 S.P
    ... That is to use a trigger on a table and perform an INSERT/UPDATE which will execute the trigger. ... What an error message! ... > what your OLE DB provider is feed the AS400 with? ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.data.oledb)
  • Re: using a trigger to enforce referential integrity
    ... The first thing to do is COMPLETELY and EXACTLY specify the error message ... Lets avoid "something like..." ... you can then move on to rewriting your trigger to ... FROM tblItemRelationship AS IR ...
    (microsoft.public.sqlserver.programming)
  • Re: Help:Error 7405 - Problem accessing linked server in trigger
    ... > I have written an insert trigger In SQL server 2K that is supposed to ... > accessing linked server. ... Are these two SET statements the only suspect that caused my access ... Is sessionproperty the correct way to check the settings in my ...
    (microsoft.public.sqlserver.programming)
  • Re: Write conflict error after adding trigger to table
    ... This error message is usually the result of a missing primary key or a ... VIEW_METADATA and create an appropriate InsteadOf trigger to have this view ... > view in that database. ... > of using the stored proc as a datasource. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Killed by Triggers
    ... When I removed the trigger the error disappeared. ... The second situation is when a detail record was attempted, after the header ... If you don't get an error message, ... UPDATE TABLE01 SET CREATEDBY = CURRENT_USER, ...
    (microsoft.public.sqlserver.security)