instance_name

Description

(Cluster environments only) Returns the name for the Adaptive Server whose id you provide, or the name of the Adaptive Server from which it is issued if you do not provide a value for id.

Syntax

instance_name([id])

Parameters

id: is the ID of the Adaptive Server whose name you are researching.

Examples

Example 1

Returns the name of the instance with an ID of 12:

select instance_name(12)

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute instance_name.