Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger - I need to acquire NT User ID
Message
From
18/01/2001 18:10:52
 
 
To
18/01/2001 16:39:49
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00425502
Message ID:
00465483
Views:
11
>Mike - saw this from awhile back - what if you're NOT using NT authorization? Can you still get NT account? How/
>
>TIA!
>
>>If you're using NT Auth, the function SUSER_SNAME() will return the NT account that was used to attach to the server.
>>
>>-Mike

No, cause if you are not using NT auth, you don't have to be logged into the SQL Server.. so, SUSER_NAME() will return the SQL SErver login id name. Of course, they want you to use SUSER_SNAME() now.

BOb
Previous
Reply
Map
View

Click here to load this message in the networking platform