March 12, 2009 at 2:33 pm
I'd like to modify an insert trigger so that I take the NT User Name associated with the insert statement and insert the NT User Name into another table along with the primary key of the of row being modified.
I know the NT User Name is viewable in profiler so I think it must be available inside the SQL call or Stored Proc Call
I don't have a problem writing the trigger, but I am not sure how I determine what the NT User Name is.
always get a backup before you try that.
March 12, 2009 at 2:46 pm
[font="Verdana"]Look up system_user in books online.[/font]
March 12, 2009 at 5:20 pm
As long as you are using Integrated Security (Trusted Authentication) then you can get it. If you are using SQL Authentication, like a single account from a web application, then you cannot.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply