Get NTlogin from Generic User

[Matthew Mark]

Using VB as front end.
Using Generic User (DBuser)who has all appropriate rights to all procedures
in database.

Problem is when using suser_sname(), either as default or in an update proc,
it supplies the login user into SQL Server, not the NT login name. I need
to trap the NT Login name. Does anyone know how to do this?

[Colin]

Heres how to do it in VB

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA"
(ByVal lpBuffer As String, nSize As Long) As Long


Public Function GetName() As String

Dim lSize As Long
Dim sBuffer As String
sBuffer = Space(255)
lSize = Len(sBuffer)
Call GetUserName(sBuffer, lSize)
If lSize > 0 Then
GetName = Left$(sBuffer, lSize)
Else
GetName = ""
End If
End Function


You could then pass this value as an argument to your stored procedure. I
am unsure if you can get the NTLogin for a generic user name.