This document on the Microsoft Download Center has a detailed discussion on SQL Server 2005 common language runtime (CLR) support to increase developer productivity and create a flexible pricing application solution at Microsoft.
Files in this download: DevProdSQL2005TCS.doc and DevProdSQL2005TCSPpt.ppt