Enabling CLR Integration in SQL Server 2005
Posted
Monday, February 19, 2007 9:49 AM
by
Maurice
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!