First time CLR Stored Procedure - Execution

Published Tue, Mar 6 2007 17:15 | abu

If you are trying to run first time CLR Stored Procedure then you might be getting the following error

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

Firrst execute these two statement and execute the procedure as usual

sp_configure 'clr enabled', 1

RECONFIGURE

This will change the Configuration Option and allow CLR Stored Procedure Execution.

If you want see all the configuration option in the present database just execute the following statement

SELECT * FROM sys.configurations ORDER BY name ;

Filed under:

Leave a Comment

Name:  
Website: