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
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.
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.
System procedures sp_addengine