Total Pageviews

Search This Blog

Tuesday, January 29, 2008

Configure CLR option in SQL Server

This problem comes when you try to execute assembly method from SQL.

Error:

/**
Msg 6263, Level 16, State 1, Line 1
Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
**/

Solution:

EXEC sp_configure 'clr enabled', 1
RECONFIGURE WITH OVERRIDE
GO

No comments: