Active Directory Username Steven 28.07.2006 21:07:02 I would like to make the default value for a field the current logged in username so that on inserts it captures the creator. How would I update a "last modified by" field on edits? Using SQL 2000 w/ Windows Authentication THANKS

Re: Active Directory Username "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 30.07.2006 23:03:03 For Active Directoy, I don't know but for triggers and suser_sname(), see: http://www.aspfaq.com/show.asp?id=2448 -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Steven" <Steven[ at ]discussions.microsoft.com> wrote in message news:18A929E4-4216-4664-952E-CCF7027404B2[ at ]microsoft.com... [Quoted Text] >I would like to make the default value for a field the current logged in > username so that on inserts it captures the creator. > > How would I update a "last modified by" field on edits? > > Using SQL 2000 w/ Windows Authentication > > THANKS