For anyone interested, I found the articles here: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx

Thanks David.  That was my understanding as well.  We have all of the Reporting Services components installed on our database server which sits behind the firewall.  And our web servers...

Do you mean an "Instead Of" trigger?  I've read how to use these in order to be able to access the text column. 

I'm not sure how to access the text column in the...

Thanks Andy!  I've been trying to convince my coworkers for the last 2 years that we should get rid of all of our text fields because they are not accessible...

I'm curious as to how this might affect any update triggers for this table.  If the data is treated the same as binary data in that it its stored on a...