spid_instance_id

Description

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

Syntax

spid_instance_id(spid_value)

Parameters

spid_value: the spid number whose instance id is requested

Examples

Example 1

Returns the ID of the instance that is running process id number 27:

select spid_instance_id(27)

Usage

If you do not include a spid value, spid_instance_id returns NULL.
If you enter an invalid or non-existing process id value, spid_instance_id returns NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute spid_instance_id.