---
title: "KILL QUERY NOTIFICATION SUBSCRIPTION"
titleSuffix: SQL Server (Transact-SQL)
description: Remove query notification subscriptions from an instance. This statement can remove a specific subscription or all subscriptions.
author: rwestMSFT
ms.author: randolphwest
ms.reviewer: ""
ms.date: "07/27/2017"
ms.prod: sql
ms.prod_service: "sql-database"
ms.technology: t-sql
ms.topic: reference
ms.custom: "seo-lt-2019"
f1_keywords:
  - "KILL QUERY NOTIFICATION SUBSCRIPTION"
  - "KILL_QUERY_NOTIFICATION_SUBSCRIPTION_TSQL"
helpviewer_keywords:
  - "KILL QUERY NOTIFICATION SUBSCRIPTION statement"
  - "removing subscriptions"
  - "subscriptions [SQL Server query notifications], stopping"
  - "query notifications [SQL Server], subscriptions"
dev_langs:
  - "TSQL"
---
# KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)
[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]

  Removes query notification subscriptions from the instance. This statement can remove a specific subscription or all subscriptions.  
  
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```syntaxsql
KILL QUERY NOTIFICATION SUBSCRIPTION   
   { ALL | subscription_id }  
```  
  
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]

## Arguments
 ALL  
 Removes all subscriptions in the instance.  
  
 *subscription_id*  
 Removes the subscription with the subscription id *subscription_id*.  
  
## Remarks  
 The KILL QUERY NOTIFICATION SUBSCRIPTION statement removes query notification subscriptions without producing a notification message.  
  
 *subscription_id* is the id for the subscription as shown in the dynamic management view [sys.dm_qn_subscriptions (Transact-SQL)](../../relational-databases/system-dynamic-management-views/query-notifications-sys-dm-qn-subscriptions.md).  
  
 If the specified subscription id does not exist, the statement produces an error.  
  
## Permissions  
 Permission to execute this statement is restricted to members of the **sysadmin** fixed server role.  
  
## Examples  
  
### A. Removing all query notification subscriptions in the instance  
 The following example removes all query notification subscriptions in the instance.  
  
```sql  
KILL QUERY NOTIFICATION SUBSCRIPTION ALL ;  
```  
  
### B. Removing a single query notification subscription  
 The following example removes the query notification subscription with the id `73`.  
  
```sql  
KILL QUERY NOTIFICATION SUBSCRIPTION 73 ;  
```  
  
## See Also  
 [sys.dm_qn_subscriptions (Transact-SQL)](../../relational-databases/system-dynamic-management-views/query-notifications-sys-dm-qn-subscriptions.md)