Write trigger to update linked server -- sql server programming

Larry Chan
9/10/2004 1:44:14 AM

I have recreate the trigger with

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
go

CREATE TRIGGER sm_inv_list_update_trg
ON inv_list
FOR UPDATE
AS

begin
UPDATE T4.eFrontData.dbo.partcost
SET CostEach =
a.std_cost+a.std_direct_dolrs+a.std_ovhd_dolrs+a.std_util_d
olrs
FROM inserted a, inv_master b, T4.eFrontData.dbo.partcost c
WHERE a.part_no = b.part_no
AND a.location = 'MAINWH'
AND b.status = 'P'
AND a.part_no = c.OrdPart_ID
end

But still got the error when I update one of the record.
Also I have set the Attribute of Connections in the Linked
Server.
[quoted text, click to view]

Narayana Vyas Kondreddi
9/10/2004 8:32:48 AM

Try recreating the trigger from SQL Server Query Analyzer, with the
specified settings ON. For example:

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
CREATE TRIGGER....
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/

[quoted text, click to view]
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?

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : Write trigger to update linked server