How can I query the WorkstationID value assigned in a connection string using T-SQL?
I am assigning the ApplicationName and WorkstaionID properties on a SqlConnectionStringBuilder.
I can query the ApplicationName from sys.dm_exec_sessions. I would like be able to query the WorkstationID value using T-SQL, also.
My goal is to be able to see which workstations are running which applications from the application suite we are developing.