Chapter 1: System Procedures

sp_dropengine

Drops an engine from a specified engine group or, if the engine is the last one in the group, drops the engine group.

sp_dropengine engine_number, engine_group

engine_number: is the number of the engine you are dropping from the group. Values are between 0 and a maximum equal to the number of configured online engines, minus one.

engine_group: is the name of the engine group from which to drop the engine.

This statement drops engine number 2 from the group called DS_GROUP. If it is the last engine in the group, the group is also dropped:

sp_dropengine 2, DS_GROUP

sp_dropengine can be invoked only from the master database.
If engine_number is the last engine in engine_group, Adaptive Server also drops engine_group.
The engine_number you specify must exist in engine_group.

Only a System Administrator can execute sp_dropengine.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect