Skip to content

Latest commit

 

History

History
43 lines (35 loc) · 1.82 KB

mssql-eng014144.md

File metadata and controls

43 lines (35 loc) · 1.82 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords monikerRange
MSSQL_ENG014144
MSSQL_ENG014144
MashaMSFT
mathoma
09/25/2024
sql
replication
reference
updatefrequency5
MSSQL_ENG014144 error
=azuresqldb-mi-current||>=sql-server-2016

MSSQL_ENG014144

[!INCLUDE SQL Server SQL MI]

Message Details

Attribute Value
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.

Related content