February 14, 2005 at 6:06 am
I am a newbie to SQL Replication and have set up replication of a application using SQL 2000, and have found the remote users are having serious conflict problems because of triggers which should not have been copied to the destination.
However, I am not able to alter publication merge rules for the articles so not to copy triggers to destination (snapshot tab in Table Article Properties) without the following error :-
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type nvarchar to data type varbinary, table 'tempdb.dbo.#tab_changearticle___000100005AA2', column 'value'. Use the CONVERT function to run this query.
Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication 'App' because publication wide reinitialization is performed.
I know I will have to reinitialize but I cannot get the Article changed. What does this error mean and how can I get pass it without starting the Publication process all over again?
I am using SQL 2000 (to Service pack 3A) on a Window 2003 Server
February 14, 2005 at 4:19 pm
If you do not need the Triggers on the Subscribers, then go into each Trigger and use the option "NOT FOR REPLICATION". This requires a recompile. Look in BOL for syntax however, here is an example below;
Create Trigger trigger_name
FOR INSERT, UPDATE, DELETE
NOT FOR REPLICATION
SQL GOES HERE.
By doing this, you are telling SQL Server NOT to replicate the Trigger.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply