Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger vs NT Username
Message
De
23/02/2004 10:24:15
 
 
À
20/02/2004 08:45:16
Dave Sonier
Technologies Nter inc.
Gatineau, Québec, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00879151
Message ID:
00879910
Vues:
23
>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

If you didn't use NT Authentication I don't think there is any way to do this from the server.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform