Home Forums SQL Server 2008 SQL Server 2008 - General Get User Name from suser_name() and host_name() RE: Get User Name from suser_name() and host_name()
sqlbi.rahul
SSC Enthusiast
Points: 140
More actions
May 20, 2010 at 1:58 pm
#1170432
try this
SELECT REPLACE(SUSER_NAME(), HOST_NAME() , '\','') as userId
i hope it works..
i have mine setup as
SELECT REPLACE(SUSER_NAME(), 'Dom-cs\','') as userId