This topic has not yet been rated - Rate this topic

KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)

SQL Server 2012

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


          

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.

The following example removes all query notification subscriptions in the instance.

KILL QUERY NOTIFICATION SUBSCRIPTION ALL ;

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

KILL QUERY NOTIFICATION SUBSCRIPTION 73 ;

sys.dm_qn_subscriptions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions