The stop command terminates the specified listeners. If you specify non-existent listeners in the syntax, sp_listener fails without affecting the other listeners. sp_listener...stop also fails if you are trying to stop the last active listener on the server.
sp_listener does not run
if you are attempt to stop all active listeners with the stop parameter.
The following command stops the listener corresponding to the specified tli address for all engines on which it is active:
sp_listener “stop”, “tli:ASE1251:4556”
This command stops all listeners registered in the interfaces file for server ASE1251 for the specified range of engines:
sp_listener “stop”, “ASE1251”, “3-6”
(Windows NT only) To stop all listeners on engines three through six that are in a state that will allow the change:
sp_listener “stop”, “ASE1251”, “remaining”
