Why is it that when using NT authentication and I execute the user_name system function I donot get the correct name i.e. domain\user_name and is there a function or way to do this.
If I use sp_who I can see all the current activity.