error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option

when you creates sql server clr project in visual studio and then when you wants to run stored procedure created using that clr project in sql server then you will get below error because by default sql server's CLR is not enabled:

error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option.

By default .NET Framwork is disabled in SQL2005.

How to fix:

1. Explore "SQL Server 2005/Configuration Tools/Surface Area Configuration" in your Start menu.
2. Select "Surface Area Configuration for Features"
3. You will find "CLR Integration" option, activate it and save

Solution By:Rajesh Rolen