Skip to content

kill-query-notification-subscription-transact-sql.md

Latest commit

 

History

History
77 lines (58 loc) · 2.84 KB

kill-query-notification-subscription-transact-sql.md

File metadata and controls

77 lines (58 loc) · 2.84 KB
title KILL QUERY NOTIFICATION SUBSCRIPTION
description Remove query notification subscriptions from an instance. This statement can remove a specific subscription or all subscriptions.
titleSuffix SQL Server (Transact-SQL)
ms.custom seo-lt-2019
ms.date 07/27/2017
ms.prod sql
ms.prod_service sql-database
ms.reviewer
ms.technology t-sql
ms.topic language-reference
f1_keywords
KILL QUERY NOTIFICATION SUBSCRIPTION
KILL_QUERY_NOTIFICATION_SUBSCRIPTION_TSQL
dev_langs
TSQL
helpviewer_keywords
KILL QUERY NOTIFICATION SUBSCRIPTION statement
removing subscriptions
subscriptions [SQL Server query notifications], stopping
query notifications [SQL Server], subscriptions
ms.assetid 8aeadf51-286c-4748-bef2-d25858b250bf
author rothja
ms.author jroth

KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)

[!INCLUDE SQL Server]

Removes query notification subscriptions from the instance. This statement can remove a specific subscription or all subscriptions.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
KILL QUERY NOTIFICATION SUBSCRIPTION   
   { ALL | subscription_id }

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).

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.

KILL QUERY NOTIFICATION SUBSCRIPTION ALL ;

B. Removing a single query notification subscription

The following example removes the query notification subscription with the id 73.

KILL QUERY NOTIFICATION SUBSCRIPTION 73 ;

See Also

sys.dm_qn_subscriptions (Transact-SQL)