Active Directory Username

[Steven]

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

 

[Sylvain Lafontaine]

For Active Directoy, I don't know but for triggers and suser_sname(), see:

http://www.aspfaq.com/show.asp?id=2448