• create your assembly in your production database using the below statement.Build your project and copy your .dll to your prod server .

    CREATE ASSEMBLY sqlcrlProcName from 'C:\CLRProcFiles\SQLProc.dll' with PERMISSION_SET = SAFE

    to enable CLR feature in your database :

    use master

    GO

    EXEC sp_configure 'show advanced options' , '1';

    reconfigure;

    EXEC sp_configure 'clr enabled' , '1' ;

    reconfigure;

    EXEC sp_configure 'show advanced options' , '0';

    reconfigure;