SQL @@SPID

SQL @@SPID is one of the Configuration Functions, which will return the session ID that is currently used. The syntax behind this is @@SPID SQL @@SPID Example The below code snippet will show the @@SPID and the respective login name that is currently being used. SELECT @@SPID AS ‘SP ID’, SYSTEM_USER AS ‘Login Name’, USER … Read more