Finding Session Id in MS SQL User's Current Process

221 Reads Ms Sql

In MS SQL, the following query is run to find the Session Id of the logged in user in the current process.

SELECT @@SPID AS 'SessionId'
Ms Sql

You May Interest

What is the Bookmark Lookup and RID Lookup in SQL Server ?

Disadvantages of Using Stored Procedures in MS SQL

What is FILLFACTOR in SQL Server ?

Getting List of All Stored Procedures in Database in MS SQL

What is TABLESAMPLE in SQL Server ?