• opc.three (1/13/2013)


    Lynn Pettis (1/13/2013)


    Of course, using SQLCLR is also dependent on whether or not you are allowed to use it in your environment as well.

    Naturally. It, like sys.xp_cmdshell, is disabled by default and must be enabled using sys.sp_configure.

    EXEC sys.sp_configure

    @configname = 'clr enabled',

    @configvalue = 1;

    RECONFIGURE;

    I know how to enable CLR. The problem with your solution comes in when you AREN"T allowed to use CLR. That is all I was saying.