SALES: 1-800-867-1380
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

KILL QUERY NOTIFICATION SUBSCRIPTION 
   { ALL | subscription_id }

ALL

Removes all subscriptions in the instance.

subscription_id

Removes the subscription with the subscription id subscription_id.

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.

Permission to execute this statement is restricted to members of the sysadmin fixed server role.

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 ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft