Determines if previous connection migrations to a new instance are pending, and terminates the migrations if they are.
sp_cluster connection, ‘migrate_cancel’ [, ‘spid_list’]
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.
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’