General information
Forum:
Microsoft SQL Server
Title:
Trigger vs NT Username
Hi,
I'm using a SQL Server login to connect my VB program.
How can I get a NT UserName inside a Trigger ?
I tried this:
select NT_USERNAME from master..sysprocesses where spid = @@spid
but the NT_UserName is blank because I used a SQL Logins.
Does exist a function, extended procedure, etc ?
Thank in advance.
Dave
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only