May 24, 2006 at 5:39 pm
I have configured a SQL 2000 Database for Transaactional Replication. I didn't do an automatic snapshot as the Database is 1GB. I backed it up, restored it to the Subscriber and then I configured the Replication from the Publisher not to do the SNAPSHOT as the Subscriber already has the data.
The problem I have is, the system stored procedures do not exist as I have done a manual snapshot. How do you generate the system stored procedures without doing an initial snapshot?
May 24, 2006 at 7:30 pm
The required replication system stored procedure is: sp_scriptpublicationcustomprocs
You might also like to read this article in http://www.replicationanswers.com:
May 24, 2006 at 7:31 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply