Unflagging subscription reinitialize

  • Is it possible to remove the reinitialize flag for a subscription in SQL Server 2000 and, if so, how ?  I have looked thru all the system tables and can't identify anything.

    awelling@paspaley.com.au

     

  • How about this field in syssubscriptions table:

    queued_reinitbitSpecifies whether the article is marked for initialization or reinitialization. A value of 1 specifies that the subscribed article is marked for initialization or re-initialization.

     

    I haven't tried modifying it, so I don't know what would happen.  Maybe set up a little test area to try it out.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply