sp_cluster connection, migrate_cancel

Description

Determines if previous connection migrations to a new instance are pending, and terminates the migrations if they are.

Syntax

sp_cluster connection, ‘migrate_cancel’ [, ‘spid_list’]

Parameters

migrate_cancel – indicates you are investigating the status of connection migrations.

spid_list – is the list of spids you are investigating. Separate multiple spids with semicolons.

Examples

Determines if there is a connection migration occurring on spid 73; if there is, the Cluster Edition cancels the migration:

sp_cluster connection, ‘migrate_cancel’, ‘73’