Showing posts with label refresh. Show all posts
Showing posts with label refresh. Show all posts

Saturday, February 25, 2012

publication

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...
>