dbForge SQL Complete

I found a very good free tool for SQL Management studio; it will make your life typing t-sql much easer.
Download link: http://ping.fm/dswd7
Select the express edition it’s free.

Note: if you installed Visual Studio SP1 on your computer and you had MS SQL Management studio 2008 R2, Intelsense will stop working, there is a very large fix from Microsoft to fix it, but this solution is much better in my eyes

Enabling SQL CLR

to enable the CLR for any database of SQL 2005
run the following in new query

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

Reference:
http://msdn2.microsoft.com/en-us/library/ms254506(VS.80).aspx