RE: Triggers on a Subscriber table
From: RRN (RRN_at_discussions.microsoft.com)
Date: 09/24/04
- Next message: Ron L: "Stored Procedure failed with 'Invalid Cursor State' problem"
- Previous message: CM Rahman: "Re: The process could not bulk copy out of table '[dbo].[syncobj_"
- In reply to: Sylvain: "Triggers on a Subscriber table"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 12:27:01 -0700
HI Sylvain,
We have a pbulisher and a Distributer in the same server and a subscriber in
diffrent server but it is in LAN. I am using the transactional replication
between the publisher and subscriber. I have a alter script, to add timestamp
column to the subscriber and written the triggers to populate the time stamp
column whenever the record is getting inserted or updated to the subscriber
thru the replication.
I am getting the distibutuin agen time out experied error.
Can u pls help me.
Thanks in advance.
Regards,
Raghuram P.
"Sylvain" wrote:
> We have a Publisher and a Distributer in a remote location and a Subcriber
> in our office. After initial snapshot, we added triggers to some
> Subscriber's tables, but everytime there is Reinitialization on the
> Subscriber, we have to recreate triggers.
>
> Is there a way to reinitialize and not loose our triggers on the
> Subscriber's tables?
>
> Thanks,
>
>
>
>
>
>
- Next message: Ron L: "Stored Procedure failed with 'Invalid Cursor State' problem"
- Previous message: CM Rahman: "Re: The process could not bulk copy out of table '[dbo].[syncobj_"
- In reply to: Sylvain: "Triggers on a Subscriber table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
