Great article!
I particularly enjoy the OUTPUT clause. One of the thing that I bi***, er, gripe about is data archiving. It is usually left out of designs until the server fills up. This will be a great boon as I can now write my archive function with only one statement per table and wrap the whole thing in a transaction. My archive database is an exact copy, structurally, of the production database.
ATBCharles Kincaid