"Shane Lim" <gslim@blizzardice.com> wrote in message
news:g3dtv0pahfodjbg853qkfqibtksujtjrfm@4ax.com...
> I am trying to run the sp_replicationdboption stored procedure to
> start setting up replication. My query looks like this :
>
> exec sp_replicationdboption @dbname = N'Manual', @optname = N'merge
> publish', @value = N'true'
>
>
> However I get an error of:
>
> Server: Msg 20028, Level 16, State 1, Procedure sp_MSmergepublishdb,
> Line 53
> The Distributor has not been installed correctly. Could not enable
> database for publishing.
> The replication option 'merge publish' of database 'Manual' has been
> set to false.
>
>
>
>
> When I run the sp_helpserver my ID is 0 and when I run @@servername I
> get the correct instance.
>
>
> Is there another stored procedure I am supposed to run first?
>
> Shane Lim
>

<hilary.cotter@gmail.com> wrote:

>what happens when you go to tools, replication, enable replication?

"Shane Lim" wrote:

> On Mon, 31 Jan 2005 23:51:17 -0500, "Hilary Cotter"
> <hilary.cotter@gmail.com> wrote:
>
> >what happens when you go to tools, replication, enable replication?
>
>
> That enables that replication and I have to setp the distribution
> Database. How can I do this using stored procedures? This has to be
> something that the user doesn't see or even know about if possible.
>
> Shane Lim
>