"CLR Enabled" is not required to use CLR built-ins

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Mon, 21 Nov 2011 19:44:00 GMT Indexed on 2011/11/22 2:03 UTC
Read the original article Hit count: 190

Filed under:

.NET Framework

|

clr

|

Common Language Runtime

|

FORMAT()

Books Online articles referencing built-in CLR functions (such as FORMAT() ) have a remark similar to the following: "FORMAT relies on the presence of .the .NET Framework Common Language Runtime (CLR)." A lot of people seem to interpret this as meaning: "You must enable the sp_configure option 'CLR enabled' in order to use FORMAT()." Some then go on and suggest you run code similar to the following before you play with these functions: EXEC sp_configure 'show advanced options' , 1 ; GO RECONFIGURE...(read more)

© SQL Blog or respective owner

Related posts about .NET Framework

.NET Reflector 6, .NET Reflector Pro, TestDriven.NET, .NET 4.0 and Mono

as seen on Simple Talk - Search for 'Simple Talk'
By now you may well have noticed that .NET Reflector 6 and .NET Reflector Pro are out in the wild. The official launch happened today, although we actually put the software out last Thursday as part of a phased release plan to ensure that everything went smoothly today which, so far, it seems to have… >>> More
Baboon Framework : A revolutionary WPF framework that will save you time and effort

as seen on Code Project - Search for 'Code Project'
This is true code, what you say >>> More
sync Framework for Compact Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone got sync framework to work on a mobile device as a sync mechanism in place of RDA or Merge replication? If yes, could you point me to any resources available. If one was to start a green field compact framework based application, what would one use as the sync mechanism (sync framework/RDA/Merge… >>> More
Binding not writing to datasource on .NET Compact Framework Form -- works on Full Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem with a bound user control writing back to it's datasource on a NetCF forms application. The application is too complex to post code, so I made a toy version to show you. I create a form, usercontrol with a combobox, a class (testBind) and another class (TestLookup). I bind a property… >>> More
Unity framework - creating & disposing Entity Framework datacontexts at the appropriate time

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, With some kindly help from StackOverflow, I've got Unity Framework to create my chained dependencies, including an Entity Framework datacontext object: using (IUnityContainer container = new UnityContainer()) { container.RegisterType<IMeterView, Meter>(); container.RegisterType<IUnitOfWork… >>> More

Related posts about clr

Loading/Executing CLR 2.0 assemblies in CLR 4.0

as seen on Stack Overflow - Search for 'Stack Overflow'
Can the CLR 4.0 execute CLR 2.0 IL without the need for source code recompilation? >>> More
Declare a Nullable int (int?) using XAML

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to bind a combo box to a property on my ViewModel. The target type is short? and I would like to have null be an option. Basically I would like the value of the first item in the combo box be {x:Null}. <ComboBox Grid.Row="9" Grid.Column="1" SelectedValue="{Binding Priority}"> … >>> More
IIS: 404 error on every file in a virtual directory.

as seen on Server Fault - Search for 'Server Fault'
I am trying to write my first WCF service for IIS 6.0. I followed the instructions on MSDN. I created the virtual directory, I can browse the directory fine but anything I click (even a sub-folder in that folder) gives me a 404 error. What am I missing that I can not access any files or folders?… >>> More
IIS: 404 error on every file in a virtual directory.

as seen on Server Fault - Search for 'Server Fault'
I am trying to write my first WCF service for IIS 6.0. I followed the instructions on MSDN. I created the virtual directory, I can browse the directory fine but anything I click (even a sub-folder in that folder) gives me a 404 error. What am I missing that I can not access any files or folders?… >>> More
A CLR-supporting browser (4 replies)

as seen on .NET 247 - Search for '.NET 247'
Microsoft, by seemingly ignoring the huge benefits of JIT compiling VMs on the browser and instead pushing Silverlight (which is pretty awesome though), is showing it STILL hasn't gotten the Web. (The fact that I can't seem to post on these newsgroups using Firefox (!!!) is yet another glaring example)… >>> More