dbTalk Databases Forums  

[ms sql] How to add new table to merge replication ?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss [ms sql] How to add new table to merge replication ? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
szaki
 
Posts: n/a

Default [ms sql] How to add new table to merge replication ? - 07-12-2007 , 03:49 AM






Hi,
How to add new table to merge replication ?

When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.

What is wrong ?

Thank for any help

Luk


Reply With Quote
  #2  
Old   
Damien
 
Posts: n/a

Default Re: How to add new table to merge replication ? - 07-13-2007 , 02:16 AM






On Jul 12, 9:49 am, szaki <ljag... (AT) gmail (DOT) com> wrote:
Quote:
Hi,
How to add new table to merge replication ?

When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.

What is wrong ?

Thank for any help

Luk
The handy thing with that procedure is that you can open it up and
look down to the line number, and read the comments, and maybe get an
idea of what the problem is, even if the error message is missing.

Strangely, I can't find it raising 20085 at that line number - on SQL
2000 SP 4. But at that line, there is a check that all articles
contain a column marked with the rowguidcol property (and raising
error 20086). So, is that what's wrong with your table?

Damien



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.