(Cluster environments only) Returns the ID of the named instance, or the instance from which it is issued if you do not provide a value for name.
instance_id([name])
select instance_id()
select instance_id(myserver1)
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute instance_id.