current session information in sql server

SQL Server @@SPID

SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.

SYNTAX
@@SPID