Journey to SQL CLR

To turn on CLR support in SQL Server 2008 ...

No more Surface Area Configuration Tool in SQL Server 2008

Turn on CLR support for SQL Server 2005

Program and manually deploy SQL CLR Integration

Create and Deploy SQL CLR manually

Very simple and nice example on how to create and deploy SQL CLR code