sp_dropengine

Considerations for process mode

sp_dropengine does not run in threaded mode.

sp_dropengine engine_number [,engine_group] [,instance_id]

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.
instance_id – (Cluster environments only) Is the ID of the instance from which you are dropping an engine or engine group.

Example 1 – 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
```
Example 2 – (Cluster environments only) Drops engine number 5 from instance id 8:
```
sp_dropengine 5, 8
```

There are additional considerations when using sp_dropengine:

You can invoke sp_dropengine only from the master database.
If engine_number is the last engine in engine_group, SAP ASE also drops engine_group.
(Cluster Edition only) If you set sp_cluster set system_view to:
- cluster – you can drop an engine or engine group from any instance in the cluster.
- instance – you can drop an engine or engine group only from a local instance.
sp_dropengine can run in sessions using chained transactions after you use sp_procxmode to change the transaction mode to anymode.
The engine_number you specify must exist in engine_group.

The permission checks for sp_dropengine differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any execution class` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role

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

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	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