all groups > sql server replication > october 2003 >
You're in the

sql server replication

group:

Replication Woes


Replication Woes Jay LIgda
10/29/2003 5:05:15 PM
sql server replication:
Hello,

I'm having problems with my replication. Now the
distributor and publisher are working fine. On the pull
subscription end I get the error message, "Could not find
the stored procedure ..." I know replication sets up all
sorts of stored procedures, but in this case it did not.

Now the thing is that I had this publication and
subscription working before and had to drop it to make a
change. I dropped the subs, made the change and
reinstated the subs. Then I got errors. I even went as
far the remove the entire distributor, publisher and
subscription and remove all the tables and stored
procedures that were created, but when I try again, I get
the error mentioned above. I'm sure something went wrong
when I deleted the stored procedures. What can I do?

TIA Jay
Replication Woes Ray D
10/30/2003 12:14:16 AM
What is the name of this stored procedure?
[quoted text, click to view]
Replication Woes Jay Ligda
10/30/2003 8:39:07 AM
The stored proceedure is: sp_MSupd_MembersInformation

[quoted text, click to view]
Replication Woes chris
10/30/2003 8:59:09 AM
I know that if you specify "the subscriber already has the
schema and the data" your procs wont be created for you
and you'll have to run a script that will do it for you.
See this:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;320499#2

[quoted text, click to view]
Replication Woes Jay Ligda
10/30/2003 11:05:36 AM
Didue, you rock! That was it.


[quoted text, click to view]
RE: Replication Woes ramakoni NO[at]SPAM online.microsoft.com
11/1/2003 5:54:32 AM
Did you setup the subscriptions using the 'No sync option' (i.e., the
subscriber already has schema a data)? If so take a look at the following
KB article
320499 HOW TO: Manually Synchronize Replication Subscriptions by Using
Backup
http://support.microsoft.com/?id=320499
You probably need to create the stored procedures manually at the
subscriber using
299903 FIX: sp_scriptpublicationcustomprocs Generates Replication Stored
http://support.microsoft.com/?id=299903

HTH,
Ramu.

This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button