Post reply

Cannot drop article ''TABLE60'' from publication ''DB_Comp'' ...

  • January 8, 2005 at 10:18 pm

    #163625

    [ Merge Replication ]

    I work with a software that the act deletion and creation of the table and deletion and creation and change of the field by the users happens so much.

    for deletion of the table using this command :

    sp_dropmergearticle @publication='DB_Doc',

    @article = 'TABLE65',

    @force_invalidate_snapshot=1

    , but after execute this command displayed below message :

    "Cannot drop article 'TABLE65' from publication 'DB_Doc' because its snapshot has been run and this publication could have active subscriptions."

    how can i drop the table in active merge replication with T-SQL(System Stored Procedure)?

    thanks.

  • January 10, 2005 at 2:12 am

    #536607

    Hi,

    You are not allowed to drop an article if there are subscriptions to it as your error message shows.

    Other than dropping the replication, you might want to try sp_changearticle. This allows you to change the properties of the article without dropping replication.

    See books online for more details.

    Take it easy

    Graeme

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

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