>>In the trigger code you can access just updated info using new OUTPUT clause in SQL Server 2005. Research on this.
>
>Um. . . I really don't have time on this one to learn SQL Server right now. And btw-do you know if Output is supported in the Express version?

Yes, it is supported there, it's now part of T-SQL language. Check http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-2.aspx

See also http://forums.asp.net/p/1191798/2498502.aspx