Skip to content

mssql-eng014144.md

Latest commit

 

History

History
43 lines (34 loc) · 1.69 KB

mssql-eng014144.md

File metadata and controls

43 lines (34 loc) · 1.69 KB
title MSSQL_ENG014144 | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology replication
ms.topic conceptual
helpviewer_keywords
MSSQL_ENG014144 error
ms.assetid fdc744d5-530e-48c4-9420-cca032fd482b
author MashaMSFT
ms.author mathoma
manager craigg

MSSQL_ENG014144

Message Details
Product Name SQL Server
Event ID 14144
Event Source MSSQLSERVER
Component [!INCLUDEssDEnoversion]
Symbolic Name
Message Text Cannot drop Subscriber '%s'. There are subscriptions for it in the publication database '%s'.

Explanation

A [!INCLUDEssNoVersion] instance that is configured as a Subscriber cannot be removed from the role of Subscriber while there are active subscriptions configured for the instance.

User Action

Drop all associated subscriptions before attempting to change the Subscriber status of the [!INCLUDEssNoVersion] instance:

  1. Execute sp_helpsubscription (Transact-SQL) in the publication database at the Publisher to find subscriptions.

  2. Execute sp_dropsubscription (Transact-SQL) in the publication database to drop subscriptions.

See Also

Errors and Events Reference (Replication)
Subscribe to Publications