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 *

Bear