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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Data Replications

Author  Topic 

shamike
Starting Member

2 Posts

Posted - 2007-07-17 : 06:55:28
Dear all,

I have 3 server in 3 locations, I need to add one Field to one of my table. When I try with "sp_repladdcolumn" I got this error

"Schema replication failed because database <Database name> on server <Server Name> is not the original Publisher of table <Table name>"

please help me on this.

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-17 : 06:56:55
Please post in appropriate forum like
http://www.sqlteam.com/forums/forum.asp?FORUM_ID=33
or
http://www.sqlteam.com/forums/forum.asp?FORUM_ID=13


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-17 : 07:46:58
moved from article discussion

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-17 : 13:01:09
Did you run the sp on publisher?
Go to Top of Page

shamike
Starting Member

2 Posts

Posted - 2007-07-26 : 04:24:16
Yes, run on publisher.

Rgds

quote:
Originally posted by rmiao

Did you run the sp on publisher?

Go to Top of Page
   

- Advertisement -