x

Replication error

Hi,

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 '12 at 07:02 AM in Default

chinna gravatar image

chinna
10 2 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 '12 at 09:31 AM

Cyborg gravatar image

Cyborg
10.6k 36 39 45

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x293

asked: Apr 25 '12 at 07:02 AM

Seen: 387 times

Last Updated: Apr 25 '12 at 09:31 AM