x

How to enable the CLR for execution of user code

My web app requires the ability to execute user code in one of my stored procedures. How do I enable this?

more ▼

asked Oct 28, 2009 at 07:02 AM in Default

Ben Adderson gravatar image

Ben Adderson ♦♦
361 5 7 8

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I found what I needed in Surface Area Configuration Manager. Clicking on the "Features" link at the bottom, CLR integration is one of the options listed under Database Engine in the tree pane. Then it was just a case of checking the check box and applying the change.

more ▼

answered Oct 28, 2009 at 07:05 AM

Ben Adderson gravatar image

Ben Adderson ♦♦
361 5 7 8

(comments are locked)
10|1200 characters needed characters left

Just for completeness, this is the MSDN page that describes it.

The T-SQL way (from that page) is:

sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'clr enabled', 1; GO RECONFIGURE; GO 
more ▼

answered Oct 28, 2009 at 07:51 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

Definately the better approach.
Oct 29, 2009 at 08:37 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x27

asked: Oct 28, 2009 at 07:02 AM

Seen: 1622 times

Last Updated: Oct 28, 2009 at 07:31 AM