sp_listener...resume instructs suspended listeners to resume listening and to accept new connections. For example, the following reactivates the listener on engine three of Adaptive Server ASE1251, above:
sp_listener “resume”, ASE1251, 3
To reactivate listeners on port 4556 of Adaptive Server ASE1251:
sp_listener “resume”, “tli:ASE1251:4556”
To reactivate all listeners on engines three through six that are in a state that will allow the change:
sp_listener “resume”, “ASE1251”, “remaining
