Deplying CLR Stored procedure

  • HI,

    How can i deploy the CLR Stored procedure to production i.e., different server.

    thanks,

    🙂

  • 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;

  • additinally, since you've deployed it on one server already, you can actually script them out as a binary blob and install them via a script...the script may load slow as hell when you open it in SSMS, because teh binary string is thousands of characters long, but it works:

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply