Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger - I need to acquire NT User ID
Message
De
18/01/2001 18:10:52
 
 
À
18/01/2001 16:39:49
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00425502
Message ID:
00465483
Vues:
10
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform