I am not even sure if this is possible or if I am will be asking this correctly but I am going to ask anyway.
If I log into a server with a SQL Authentication account, is there a way to get the Window Domain Account when calling a Stored Procedure (SP)?
So for example, because I run SSMS in a virtual environment, I have been using something like this to launch SSMS.
C:\Windows\System32\runas.exe /NetOnly /User:MyDomain\BabyAqua "C:\Program Files\Microsoft SQL Server"
Once SSMS launches, I use a SQL Authentication Account such as
So what I am trying to get is Domain\BabyAqua when I run a SP. I read something about Kerobose but I am not going to ask about that yet.
Basically, we will always log in and call SPs from a SQL Authentication account because this is a vendor database. But when we call the SP, I am trying to find a way to track the Window account of who is calling the SPs.