I wish to add an Insert/Update trigger which will place in a Last Updated By column the current user. My security is set up such that there are SQL Server log ins which are then assigned to dba created SQL Server roles which are given permissions to a database and its tables. How do I go about doing this... I hope this makes sense.
ex. NT LAN id --> SQL Server login using NT authority --> login is assigned to a role --> role is given permissions on a database and specific permissions on a tables within the database.