Server-initiated Events

SQL Server database servers and other Open Data Services server applications can initiate these events:

Server request Event activated Description of event
Any remote stored procedure call SRV_RPC Remote stored procedure request.
sp_sqlexec SRV_LANGUAGE Uses a remote procedure call to pass a string containing a language request to the language event handler, which then interprets the string as a language request.

Some events can be generated by Open Data Services itself. Open Data Services can generate the events described in the following table. You can provide your own event handlers for these events.

ODS action Event activated Description of event
Issues srv_event function with SRV_DISCONNECT argument. SRV_DISCONNECT Requests a disconnect for the current client thread.
Issues srv_event or srv_setevent function with SRV_EXIT argument. SRV_EXIT Requests an immediate shutdown.
Issues srv_setevent function with SRV_SLEEP. SRV_SLEEP Requests pausing a started server.
Issues srv_setevent function with SRV_RESTART. SRV_RESTART Requests continuing a paused server.
Issues srv_event or srv_setevent function with SRV_STOP argument. SRV_STOP Requests a graceful shutdown, first waiting for client threads to terminate and then shutting down.