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


© Copyright SS64.com 1999-2014
Some rights reserved