spid_instance_id

(Cluster environments only) Returns the instance ID on which the specified process ID (spid) is running.

Syntax

spid_instance_id(spid_value)

Parameters

Examples

Usage

  • If you do not include a spid value, spid_instance_id returns NULL.

  • If you enter an invalid or nonexisting process ID value, spid_instance_id returns NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute spid_instance_id.