Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-15 : 07:07:32
|
| Senrabi writes "I am a newbie to SQL Replication and have set up replication of an 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 (via snapshot tab in Table Article Properties) without the following error occurring :-Server: Msg 260, Level 16, State 1, Line 1Disallowed 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.From this 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 from scratch again?Platform SQL 2000 (Service pack 3A) on a Window 2003 Server" |
|
|
|
|
|
Replication - Triggers