Thursday, January 4, 2007

SQL 2005 : Enabling common language runtime (clr)

During a recent install I had to do this via tsql as the Surface Area Configuration tool failed to do so!
EXEC SP_CONFIGURE 'show advanced options' , '1';
GO
RECONFIGURE; 
GO

EXEC SP_CONFIGURE 'clr enabled' , '1' 
GO
RECONFIGURE; 
GO

-- remember to turn advanced options off again!
EXEC sp_configure 'show advanced option', '0' 
RECONFIGURE
GO

No comments: