Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger vs NT Username
Message
From
20/02/2004 08:45:16
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Trigger vs NT Username
Miscellaneous
Thread ID:
00879151
Message ID:
00879151
Views:
72
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
Map
View

Click here to load this message in the networking platform