Reinitialize pull subscription

i am using merge replication for data sync. in the client i have utility
written in vb that use
merge object. Clients get the dynamic snapshots. My question is:
when i run the job and create a new snapshot for a user,
how can i force the client to use this new sanpshot instead of getting
incremental changes?
thanks so much
by the way i use anonymous pull subscription..
"prefect" <uykusuz@.uykusuz.com> wrote in message
news:efuOUegNGHA.3576@.TK2MSFTNGP15.phx.gbl...
> i am using merge replication for data sync. in the client i have utility
> written in vb that use
> merge object. Clients get the dynamic snapshots. My question is:
> when i run the job and create a new snapshot for a user,
> how can i force the client to use this new sanpshot instead of getting
> incremental changes?
> thanks so much
>
|||If you are referring to an existing client, you would have to reinitialize
the subscription. However I don't see why you would want to do this. Please
can you provide a bit more background info.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||for some clients , that do not synchronized for a long time, retention
period expired
therefore some data is lost. so i create a new snapshot with fresh data for
them and i want them to use this new snapshot.
as i said before , they are using a vb utility to synchronize (anonymous
pull subscription).
you know , this utility works like merge agent. i want to do something in
the publisher to make it get the new snapshot.
if the clients remove the utility which deletes the database and install
again , it is working fine. but i dont want them to do that.
thanks so much
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ekMsamhNGHA.3284@.TK2MSFTNGP14.phx.gbl...
> If you are referring to an existing client, you would have to reinitialize
> the subscription. However I don't see why you would want to do this.
> Please can you provide a bit more background info.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||OK - please take a look at "sp_reinitmergepullsubscription".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Registry Permissions for on demand pull subscription

To configure an on-demand pull subscription, the domain user account used by
the SQL Server Agent service must have full control permissions on the
registry key: HKLM\Software\Microsoft\Microsoft SQL
Server\80\Replication\Subscriptions. When I attempt to use the registry
editor to configure the permissions, the subscriptions portion of the key is
not present. I am running Win 2000 Server and SQL Server 2000. I am logged on
as an administrator, and I have sucessfully created a merge publication and a
push subcription. Any thoughts on what may be my problem? What SQL process
creates the subscriptions entry in the registery?
Tom McAvoy, MCP
The subscriptions portion of the key can be filled in by using reg files,
but the preferred way of doing it is having Windows Synchronization Manager,
or the ActiveX Controls make these changes.
When you create your push (only through the procs), or you pull (procs or
wizards), ensure you select on demand pull. This will register your
subscription and make the necessary registry entries.
If you did not do this, you will have to configure your pull subcription
withing WSM.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> To configure an on-demand pull subscription, the domain user account used
by
> the SQL Server Agent service must have full control permissions on the
> registry key: HKLM\Software\Microsoft\Microsoft SQL
> Server\80\Replication\Subscriptions. When I attempt to use the registry
> editor to configure the permissions, the subscriptions portion of the key
is
> not present. I am running Win 2000 Server and SQL Server 2000. I am logged
on
> as an administrator, and I have sucessfully created a merge publication
and a
> push subcription. Any thoughts on what may be my problem? What SQL process
> creates the subscriptions entry in the registery?
> --
> Tom McAvoy, MCP
|||Hillary, thank you for the response. I am unable to create the 'on-demand
pull' subscription due to the lack of permissions on the registry key. I
receive an 'access denied error'. I don't have the exact error info
avaialble right now. I'll review the problem on Monday and post more complete
error info.
"Hilary Cotter" wrote:

> The subscriptions portion of the key can be filled in by using reg files,
> but the preferred way of doing it is having Windows Synchronization Manager,
> or the ActiveX Controls make these changes.
> When you create your push (only through the procs), or you pull (procs or
> wizards), ensure you select on demand pull. This will register your
> subscription and make the necessary registry entries.
> If you did not do this, you will have to configure your pull subcription
> withing WSM.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
> news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> by
> is
> on
> and a
>
>
|||It seems that you need to be a power user or admin on the machine you are
trying to pull the subscription to.
Also the account which is doing the pulling should be in the PAL.
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:8518A10B-BFB3-4C4D-A6E4-8A605F129C22@.microsoft.com...
> Hillary, thank you for the response. I am unable to create the 'on-demand
> pull' subscription due to the lack of permissions on the registry key. I
> receive an 'access denied error'. I don't have the exact error info
> avaialble right now. I'll review the problem on Monday and post more
complete[vbcol=seagreen]
> error info.
> "Hilary Cotter" wrote:
files,[vbcol=seagreen]
Manager,[vbcol=seagreen]
or[vbcol=seagreen]
used[vbcol=seagreen]
registry[vbcol=seagreen]
key[vbcol=seagreen]
logged[vbcol=seagreen]
publication[vbcol=seagreen]
process[vbcol=seagreen]