HomeSQL ServerMigrating to SQL Server 2012, a tale of trial and error, part 1 – CLR assemblies Log in

Comments

Migrating to SQL Server 2012, a tale of trial and error, part 1 – CLR assemblies — 2 Comments

  1. That’s a great idea — thanks!

    The whole system is running in production now with *almost* no glitches, including the custom CLR functions. SP1 seems to have helped quite a bit, as usual. The only remaining issue is that a few queries run much (MUCH) more slowly under SQL Server 2012, and I have had to re-write some of them to work around the problems. It is certainly not the first time I have seen that in a new version, though.

  2. /*First disable*/
    sp_configure ‘clr enabled’, 0
    GO
    RECONFIGURE
    GO

    /*Then enable*/
    sp_configure ‘clr enabled’, 1
    GO
    RECONFIGURE
    GO
    /*Run query and it works*/

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Bear