Within a trigger I need to identify the NT User id. I have tried many of the system variables but they all return the id logged into SQL Server, not the NT box user id.

I have thought that if I could acquire the session id (ASP session id) then I can hit a special user table that tracks sessions and gives me the user id.

Any ideas, system variables, calling a dll ???