@@SPID (Transact-SQL)
SQL Server 2005
Returns the session ID of the current user process.
 Note: |
|---|
| This is called the server process ID in earlier versions of SQL Server. |
Transact-SQL Syntax Conventions
This example returns the session 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 ------ ------------------------------ ------------------------------ 54 SEATTLE\jerryduffy dbo
Reference
Configuration Functionssp_lock (Transact-SQL)
sp_who
