• I want to thank everyone for the comments. One of the ways we can learn about different technical solutions to various problems is to submit articles like this in order to have commenters identify technical issues with the proposed solution and offer alternatives. In this way we all learn.

    Solomon suggested that error handling was needed; I agree. This solution was designed as a proof of concept rather than a production application. I would never incorporate code without significant error handling.

    Another commenter to my part one of this series questioned posting the dll to a Sql Server folder. I do this so if the server crashes and has to be rebuilt DBAs always know where to find the dll for a CLR.

    As a final comment, I sensed a level of harshness in the banter between some commenters. Harsh comments even between friends has been known to drive individuals away from a site like this. I have found that graciousness even in differing opinions draws people in.