SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

Error: Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

SQL SERVER - Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support CLRSupport-800x293

Fix/Workaround/Solution:

1) Enable Server for CLR Support.

2) Run the following query in Query Analyzer

sp_CONFIGURE 'clr_enabled',1
GO
RECONFIGURE
GO

If the CLR procedure is used without enabling CLR, it will show an error message as .NET Framework is not enabled. I hope you enjoyed this blog post a very small one indeed a but to the point. Please leave a comment.

If you liked this blog, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , , ,
Previous Post
SQL SERVER – Explanation SQL Command GO
Next Post
SQL SERVER – 2005 – List all the database

Related Posts

2 Comments. Leave new

Leave a Reply