0
Answer

How SQL Server detect program name in sys.dm_exec_sessions

Anupam Singh

Anupam Singh
10y
1.3k
1
Hi,
 
Can somebody explain the how below mention query detect program_name eg: Microsoft SQL Server Management Studio,Microsoft SQL Server Management Studio - Query etc..
 
select login_name,program_name,host_name,nt_domain,nt_user_name from sys.dm_exec_sessions 
 
Next Recommended Forum