Transact-SQL Reference
@@SPID
Returns the server process identifier (ID) of the current user process.
Syntax
@@SPID
Return Types
smallint
Remarks
@@SPID can be used to identify the current user process in the output of sp_who.
Examples
This example returns the process ID, login name, and user name for the current user process.
SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'
Here is the result set:
ID Login Name User Name
----- ------------- -----------
11 sa dbo