all groups > sql server replication > august 2005 >
You're in the

sql server replication

group:

merge replication error - could not find stored procedure ''.



merge replication error - could not find stored procedure ''. Bruce Baker
8/30/2005 12:00:00 AM
sql server replication: Hi

I have a client which has a merge subscription - anonymous ftp

When synchronising we see the following error message at the publisher:

Error Message:

The merge process could not retrieve column information for table
'dbo.Transfer'.
(Source: Merge Replication Provider (Agent); Error number: -2147201016)
---------------------------------------------------------------------------------------------------------------
Could not find stored procedure ''.
(Source: LOUISEPC (Data source); Error number: 2812)
---------------------------------------------------------------------------------------------------------------



What does this mean ?

Thanks
Bruce


Re: merge replication error - could not find stored procedure ''. Hilary Cotter
8/31/2005 9:41:16 PM
does this help?

http://support.microsoft.com/default.aspx?scid=kb;en-us;308743

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Re: merge replication error - could not find stored procedure ''. Bruce Baker
9/1/2005 12:00:00 AM
Not really - it was working - for some reason the procs for the table are
missing from the sysmergearticles table.

Any bright ideas on repopulating that table ? Wonder what else is bung.....

Thanks
Bruce


[quoted text, click to view]

Re: merge replication error - could not find stored procedure ''. Hilary Cotter
9/5/2005 8:19:53 AM
You can manually populate these tables with the correct procs. It will be
somewhat difficult to figure out what these procs names should be. You will
have to open these procs to find out which underlying tables they populate
and go from there.

You are best in the long run to drop the subscribers, and then re deploy
them.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button