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 .
asked Apr 25, 2012 at 07:02 AM in Default
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
answered Apr 25, 2012 at 09:31 AM