SQL Server System Common Language Runtime (CLR)

See if the following knowledge base article helps:

How do I enable CLR Integration for SQL Server 2005?

I have a follow-up post to this.  Is it in an official document somewhere stating that CLR is required.  We run our system on a consilidated Enterprise SQL server also and our DBAs have intentionally not installed CLR and are fighting the installation of CLR.  At this point I'm stuck where I can't upgrade.  I'm hoping maybe the document will go into why it's required and what benefits we will see from it.

The Orion NPM Administrators Guide calls out the requirement in the System Requirements section.

http://www.solarwinds.com/support/orion/orionDoc.aspx

There are a number of references out on the web regarding the benefits, but they all are written in DBA talk. For Orion, CLR allows for improved performance.

Andy

In the release notes for 9.5 it says: If SQL Server System Common Language Runtime (CLR) Types are not already installed, Orion NPM will install them.

I upgraded but did not get any error message, and here I have been running on 9.5 for several weeks not knowing that CLR is not enabled.  It was only when I tried to edit custom properties that I had a problem!  I am scheduled to enable CLR on Thursday AM and was told to run the Wizard after the SQL server reboot.  I hope that will be sufficient and I will not have to reinstall.  What else in 9.5 relies on CLR that may be broken and I just have not noticed???

Debbi

CLR is also used by the config wizard to setup a couple of database maintenance scripts for wireless, energywise, and Netflow's CBQoS.  If these scripts are not correctly generated and you use any of these features, then your database tables will grow very large very quickly.

John Taylor

Thanks.   I hope running the wizard will be sufficient, and I will not have to reinstall.

I believe that it will be