Replication error


when i am trying to remove the replication from one database it is throwing the following error

The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped.

how can i resolve this .

more ▼

asked Apr 25, 2012 at 07:02 AM in Default

avatar image

10 5 5 5

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

To remove replication, you should first drop the subscription associated with the publication, this depends on the type of subscription you are using(Push and Pull). Once the subscriptions are removed, then you are good to drop the Publication. Then you have the option to remove db replication and finally to drop the distributor, the last two points are optional.

The following links will helps you

How to manually remove replication : KB Article

Remove Replication : MSDN

more ▼

answered Apr 25, 2012 at 09:31 AM

avatar image

10.8k 37 58 51

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 25, 2012 at 07:02 AM

Seen: 611 times

Last Updated: Apr 25, 2012 at 09:31 AM

Copyright 2018 Redgate Software. Privacy Policy