August 11, 2004 at 10:01 am
I'm trying to set up replication using T-SQL. (Has to be script, long story). It sets up the publisher fine but when it tries to setup the subscription I get the error:
Server: Msg 21028, Level 16, State 1, Procedure sp_MS_replication_installed, Line 36
Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication.
But replication components are all installed and other replications were set up and run fine. Does anybody know which table says Replication is setup on that server so I can see if maybe when I am uninstalling it, it is taking some setting with it? Thanks Ned.
August 12, 2004 at 6:00 am
in your publication database issue the below query
sp_scriptpublicationcustomprocs ‘PublicationName’
Then copy what appears in your results pane into query analyzer connected to your subscription database and execute it. Restart your Distribution Agent.
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply