Returns the instance id on which the specified process id (spid) is running.
spid_instance_id(spid_value)
spid_value – the spid number whose instance id is requested.
Returns the id of the instance that is running process id number 27:
select spid_instance_id(27)
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.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute spid_instance_id.
