xact_owner_instance

(Cluster environments only) Returns the instance ID on which the distributed transaction is running.

Syntax

xact_owner_instance(“txn_name”)

Parameters

Examples

Usage

xact_owner_instance returns:
  • The instance ID of the instance running the transaction, or

  • Null, if the transaction is not running

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute xact_owner_instance.

Related reference
xact_connmigrate_check