I recently inherited a project where the developer was using CLR stored procedures.  You must execute the following SQL Script to be able to use those stored procedures.

sp_configure 'clr enable', 1
GO
RECONFIGURE WITH OVERRIDE
GO
Advertisements