October 29, 2009 at 6:45 am
Hi,
I have a custom trigger on my subscriber which doesnt fire while synching with publisher? Any clue.
Trigger is as follows
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [trg_insert_CL]
ON [dbo].[CL]
FOR INSERT , Delete
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
INSERT INTO MSVRNET01.Model.dbo.C_R
(c_ID,D_Time,invoice_number)
SELECT i.no,i.DDate,i.invoice_number
FROM INSERTED i
DELETE d FROM MSVRNET01.Model.dbo.C_R d
inner join Deleted del on
d.c_ID = del.no collate latin1_general_ci_as
SET XACT_ABORT OFF;
END
October 29, 2009 at 7:56 am
I have tried inserting one new record on publisher that fired my custom trigger.. Will have to investigate why for bulk update trigger is not being fired.
Ta
October 29, 2009 at 9:00 am
Hi folks,
It worked.. I just populated bulk number of rows on my publisher and checked my destination table and it worked properly.
Ta...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply