From the SQL Programmability & API Development Team Blog, check out UPDATE with OUTPUT clause Triggers and SQLMoreResults