Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Get windows username in trigger

Author  Topic 

imranswork
Starting Member

1 Post

Posted - 2014-04-16 : 03:53:22
Dear All,

User is login to the application using SQL Server Autentication method. I want to get his windows OS username to log in one of my security trigger.

All of the following:
SUSER_NAME(), SYSTEM_USER AS OSUser, SUSER_SNAME() AS SuserSName, ORIGINAL_LOGIN() As OriginalLogin, USER_NAME() as UserName
Are returning database user name, while i need OS username.

Kindly help

imran

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-10 : 03:29:12
i think you can also get the ip of the system

Javeed Ahmed
Go to Top of Page
   

- Advertisement -