sp_dropengine

Description

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

Syntax

sp_dropengine engine_number [,engine_group] [,instance_id]

Parameters

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

in cluster environments – is the ID of the instance from which you are dropping an engine or engine group.

Examples

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

In cluster environments – drops engine number 5 from instance id 8:

sp_dropengine 5, 8

Usage

Permissions

Only a System Administrator can execute sp_dropengine.

Auditing

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

See also

System procedures sp_addengine