Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Ensure the database object is not replicated before attempting to drop it. For example:
If the error occurs in the publication database, drop the article from the publication before dropping the object. For more information, see Add Articles to and Drop Articles from Existing Publications.
If the error occurs in the subscription database, drop the subscription before dropping the object. For more information, see Subscribe to Publications. For subscriptions to transactional publications, it is possible to drop the subscription to an individual article rather than the entire publication. For more information, see sp_dropsubscription (Transact-SQL).
If this error occurs in a database that is not replicated, execute sp_removedbreplication (Transact-SQL) to ensure objects in the database are not marked as replicated.