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.

Examples

KILL QUERY NOTIFICATION SUBSCRIPTION 64 ;

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

Related commands

sys.dm_qn_subscriptions


 
Copyright © 1999-2024 SS64.com
Some rights reserved