KILL QUERY NOTIFICATION

Remove a query notification subscription from the instance.

Syntax:
       KILL QUERY NOTIFICATION SUBSCRIPTION 
          {ALL | subscription_id }

Key:
   ALL              Remove all subscriptions in the instance.
   subscription_id  Remove the given subscription.

This command is silent - does not produce a notification message.

Example

KILL QUERY NOTIFICATION SUBSCRIPTION 64 ;

"Whom the gods love dies young" - Menander 300 BC

Related commands:

sys.dm_qn_subscriptions