Posted by Rico on 01/03/07 22:16

Hello,

I have a table that has a UserUpdated field which has a default value of
SUSER_SNAME(). This works great when the record is created, but I'd like to
also update this value when the record is changed. If I understand things
correctly, I'll need a trigger to do this, but I've never created a trigger
before. Is this an easy thing to accomplish?

Thanks!

Rick

• Next in forum: Re: Site Search Code Help
• Prev in forum: Re: Problem with Updatetext in SQL 2000 trying to concatenate multiple text fields
• Thread view: Newbie: Updating record with User information

[Reply to this message]