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 ?
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 ?