Thanks for the responses.

In the 3 years I have been using MSSQL I have never attempted to modify data in a table with a function and I've just learned that...

Thanks for theses articles. I can't wait to start using TVP. I will see an immediate change in my web app structure. I already have found myself...

Good article.

I use audit trails for management reporting as well as automatically generated emails of certain type of changes. I currently use procs in jobs that run...