In Process Provider Changes for SQL CLR & ADO
If you have been to any of the SQL CLR-related sessions I've been running around the country or it's of interest to you, run don't walk over to look at Pablo Castro's great new (detailed) MSDN article on the changes related to the in-proc provider. Details at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/mandataaccess.asp