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. |