sp_dropengine includes the instance_id parameter to drop an engine or engine group from a specific instance. The syntax is:
sp_dropengine engine_number, engine_group [, instance_id]
Where instance_id is the id of the instance from which you are dropping an engine or engine group. For example, this drops engine number 5 from instance id 8:
sp_dropengine 5, 8
If sp_cluster set system_view is set to cluster, you can drop an engine or engine group from any instance in the cluster. If the system_view is set to instance, you can drop and engine or engine group only from a local instance.
