Enabling CLR Integration in SQL Server 2005

Posted Monday, February 19, 2007 9:49 AM by Maurice
SQL Server CLR integration is pretty cool Smile 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 Smile
 
Enjoy!
 
Filed under: ,

Leave a Comment

(required) 
(required) 
(optional)
(required)