Enabling CLR Integration in SQL Server 2005

SQL Server CLR integration is pretty cool [:)] allowing me to write .NET code and have it execute in SQL Server, for example as a stored procedure. Not that I would want to write every stored procedure using .NET code but for some of them it sure is a lot easier.

 

To enable it you need to reconfigure SQL Server a bit though. You need to enable CLR integration using the sp_configure sproc. Just don’t forget to execute a Reconfigure when done.

 

Just use:

sp_configure ‘clr enabled’, 1
go
reconfigure
go

And you are ready to go [:)]
 

Enjoy!

 


2 thoughts on “Enabling CLR Integration in SQL Server 2005

  1. I would like to install SpatialDB. I see warning message “you must make sure CLR intergration is enabled on the database before proceeding”. I ask Mr.Google, he tell me this post “Enabling CLR Integration in SQL Server 2005″

    Thank you very much!

    Ho Nguyen
    http://VietBDS.com

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>