Use refresh in EM on the publications folder and the
replication monitor, publishers subfolders. This should
synchronize them. Alternatively use sp_helppublication to
see the list.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul:
I refresh all , but it's same
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:17e901c50f73$932c8030$a601280a@.phx.gbl...
> Use refresh in EM on the publications folder and the
> replication monitor, publishers subfolders. This should
> synchronize them. Alternatively use sp_helppublication to
> see the list.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Nick,
does sp_helppublication return one or five publications?
Rgds,
Paul Ibison (SQL Server MVP)
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:e8ImhjgEFHA.2700@.TK2MSFTNGP14.phx.gbl...
> Hi Paul:
> I refresh all , but it's same
> Cheers
> nick
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:17e901c50f73$932c8030$a601280a@.phx.gbl...
>
|||HI Paul:
only say The command(s) completed successfully when i execute this stored
procedure. doesn't return any number of publication?
Could you tell me how to use this sp?
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:Oe0ILMhEFHA.548@.TK2MSFTNGP14.phx.gbl...
> Nick,
> does sp_helppublication return one or five publications?
> Rgds,
> Paul Ibison (SQL Server MVP)
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:e8ImhjgEFHA.2700@.TK2MSFTNGP14.phx.gbl...
>
|||Nick,
just run it with no arguments in the publishing database - it should return
one row or five, and will tell us which data is correct.
Rgds,
Paul
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:uagXd35EFHA.2832@.TK2MSFTNGP14.phx.gbl...
> HI Paul:
> only say The command(s) completed successfully when i execute this
> stored
> procedure. doesn't return any number of publication?
> Could you tell me how to use this sp?
> Cheers
> nick
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:Oe0ILMhEFHA.548@.TK2MSFTNGP14.phx.gbl...
>
Saturday, February 25, 2012
publication
Labels:
alternatively,
database,
folder,
microsoft,
monitor,
mysql,
oracle,
publication,
publications,
publishers,
refresh,
server,
shouldsynchronize,
sql,
subfolders,
thereplication
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment