Detecting when to use ReinitializeSubscription

Discussion in 'microsoft.public.sqlserver.ce' started by Ian Williamson, Jul 4, 2003.

  1. Once I have distributed my application to the handhelds,
    I find that I may need to change some of the underlying
    table structures on the Publisher DB.

    This requires me to delete the Publication, change the
    tables, then recreate the Publication. Of course, my
    Subscriber will then need to reinitialize the
    Subscription.

    I am wondering if they is a way for the Subscriber to
    query the Publisher to see when to call
    ReinitializeSubscription. Right not I filter for the
    error message "The subscription to publication 'myDB' is
    invalid". This is very kludgy and there must be a better
    way.

    In the BOL, there is a somewhat cryptic passage under
    ReinitializeSubscription:

    "A flag is marked in the subscription system table in
    Microsoft SQL ServerT 2000 Windows CE Edition (SQL Server
    CE) to signify that during the next synchronization, the
    subscription should be reinitialized."

    OK, perfect. But how do I access this flag and when does
    it get set?


    Cheers, Ian Williamson
     
    Ian Williamson, Jul 4, 2003
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.