"Grzegorz Zaworski" <gzaworski@gazeta.pl> wrote in message
news:bhbk9b$5r2$1@nemesis.news.tpi.pl...
> We have two MS SQL 2000 servers DB1 and DB2.
>
> DB1 is a subscriber
>
> DB2 is a publisher and a distributor
>
> replication type: merge
>
>
>
> Both of our servers run on Win2000 sp4.
>
> Yesterday we installed a sp3a for MS SQL server.
>
> The installation was made simultaneously for both servers.
>
> The installation on DB1 (subscriber) ended successfully, but on DB2 (publ.
> and distr.)
>
> we received and error saying:
>
>
>
> Error Running Script sp_vpupgrade_replication (1)
>
>
>
> so we turned the replicated database to "offline" and rerun the setup of
> sp3a.
>
> The installation ended without any errors.
>
> After applying sp3a to DB2 we tried run a script:
>
>
>
> USE master
>
> GO
>
> EXEC sp_vpupgrade_replication
>
> GO
>
>
>
> but what we received is the following message:
>
>
>
> Server: Msg 2812, Level 16, State 62, Line 1
>
> Could not find stored procedure 'sp_vpupgrade_replication'.
>
>
>
>
>
> After all that replication stopped working and the merge agent gives us
the
> following message:
>
>
>
> error details:
>
>
>
> The merge process could not retrieve article information for publication
> 'table-dane'.
>
> (Source: Merge Replication Provider (Agent); Error number: -2147201017)
>
>
>
> Invalid column name 'published_in_tran_pub'.
>
> (Source: DB2 (Data source); Error number: 207)
>
>
>
> Thanks in advance,
>
> Greg
>
>

> it's sp_vupgrade_replication,

> not sp_vpupgrade_replication