Initializing a Database When Installing Replication

When I installed SQL Server 7.0 replication, I chose not to initialize the database. Now I'm getting an error message saying that SQL Server can't find the stored procedure needed for replication. How can I fix this problem?

If you choose the option to initialize the database during replication installation, snapshot replication processing automatically creates the custom stored procedures and triggers that replication needs. But when you initialize the subscriber manually, you need to create the replication stored procedures and triggers manually as well.

To fix the problem, you can generate scripts that will recreate the stored procedures and triggers every time you set up replication. First, choose the immediate update option for the subscriber. Next, run the following stored procedures at the publisher: sp_scriptinsproc, sp_ scriptdelproc, sp_scriptupdproc, and sp_script_synctran _commands. Then, apply the scripts that these stored procedures generate to the subscribing database.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.