Getting Error in creating and deleting a Merge replication.

  • Error while deleting:

    Could not delete publication 'DB0100_GDR_USERTYPEROLES_Data_Merge'.

    -----------------------------

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Unable to acquire the replication merge administrative application lock for database 'GDR'. This could be due an active snapshot running while the schema change (DDL) or the administrative proc change was attempted.

    Replication merge admin stored procedure 'sp_dropmergepublication' failed for publication 'DB0100_GDR_USERTYPEROLES_Data_Merge'. This could be due an active snapshot running while the admin proc was called.

    Could not drop the publication.

    Changed database context to 'GDR'. (Microsoft SQL Server, Error: 20712)

    How to solve ? can somebody help. ?

Viewing 0 posts

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