NT Authentication

[olibh]

I am using NT authentication to logon to sql server and I have written an insert trigger that needs to capture the NT user name for the user that adds a new entry.

I have added a field called modifier and set the default of this field as(suser_name()).

However, this does not seem to capture the nt logon - can anyone help ?

 

[justinmarkham]

WHat about...
SELECt nt_username FROM master..sysprocesses WHERE spid = @@spid

Regards,

Justin.

 

[olibh]

Tried this but it does not seem to work

 

[rajeessh]

try a small variation

SELECt hostname FROM master..sysprocesses WHERE spid = @@spid

 

[justinmarkham]

what version of SQL are you running?

 

[cmmrfrds]

Is this a typo (suser_name()).
or did you mean

(suser_sname())