Thank this author by sharing:
By Todd Engen, 2012/04/17
Functions such as SUSER_SID() return the binary represenation of the SID. fn_SIDToString converts the binary representation to the string format S-1-5-21-xxxx-yyyy-zzzz-aaaa.
Usage:
SELECT SUSER_NAME(), SUSER_SID(), dbo.fn_SIDToString(SUSER_SID())
Any reason to use one of the following over the other to return the user currently modifying data? ...
Our admin folk just applied SQL 2000 SP4 on a W2K3 machine, and I noticed system function suser_sna...
Hi, I've got a data warehouse which is effectively a star schema. However, one of the dimensions...
[code] SELECT REPLACE(SUSER_NAME(), HOST_NAME() + '\','') as userId [/code] I need to pull...
Which is the preferred way of writing a logon trigger for basic user authentication? Using the E...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com