DROP SERVICE

Remove a service from the database.

Syntax
      DROP SERVICE service [;]
    
Key
   service     The service to drop. 

Dropping a service will delete any messages currently queued for that service, the remote side of any open conversations using the service will receive an error from the Service Broker.

Examples

DROP SERVICE [//ss64.com/TestService] ;

"We cheat the other guy and pass the savings on to you” ~ sign outside US car dealership

Related commands

CREATE SERVICE
ALTER SERVICE


 
Copyright © 1999-2024 SS64.com
Some rights reserved