Sep 28 2022 06:57 PM
Hi, I have an asp.net core project with multiple users.
Is there a way to query the details of the logged-in user in the current session?
Sep 29 2022 03:40 AM
Hi @khalev0725 -- The sys.dm_exec_sessions DMV provides session details. Something like below. Take care.
select * from sys.dm_exec_sessions where session_id = @@SPID