Thank this author by sharing:
By Todd Engen,
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.
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...
I've got a data warehouse which is effectively a star schema. However, one of the dimensions...
SELECT REPLACE(SUSER_NAME(), HOST_NAME() + '\','') as userId
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.