sql server replication: Hi,
I'm trying to use Alternate Sync Partner.
I have found this how-to http://support.microsoft.com/kb/321176
but when I execute procedure ( step 9, my names are different :) )

sp_addmergealternatepublisher @publisher = 'PublisherA'
, @publisher_db = 'TestA'
, @publication = 'DemoPublication'
, @alternate_publisher = 'PublisherB'
, @alternate_publisher_db = 'TestB'
, @alternate_publication = 'DemoPublication'
, @alternate_distributor = 'PublisherB'

I get this error
"Server: Msg 208, Level 16, State 1, Procedure
sp_addmergealternatepublisher, Line 38
Invalid object name 'sysmergepublications'."

What can be wrong? It is running on Sql Server 2000 SP 3a , replication
between PublisherA and PublisherB is OK.

Best Regards
Wojciech Znaniecki

U¿ytkownik "Wojtek Z" <wojtas_z@poczta.fm> napisa³ w wiadomo¶ci
news:csoa5s$bqe$1@nemesis.news.tpi.pl...
[quoted text, click to view]

Sorry
My mistake,
Before sp_addmergealterpublisher i should have exec

use [db_name]
GO

Now it is ok.

Wojciech Znaniecki