InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 02:20:13 GMT20http://www.sqlservercentral.com/Forums/Topic1005023-145-1.aspxadditinally, 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:[img]http://www.stormrage.com/SQLStuff/Script_CLR_Assemblies.png[/img]Mon, 15 Oct 2012 06:09:42 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1005023-145-1.aspxcreate 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 = SAFEto enable CLR feature in your database :use masterGOEXEC sp_configure 'show advanced options' , '1';reconfigure; EXEC sp_configure 'clr enabled' , '1' ;reconfigure; EXEC sp_configure 'show advanced options' , '0';reconfigure;Mon, 15 Oct 2012 05:46:21 GMTg.silampathyhttp://www.sqlservercentral.com/Forums/Topic1005023-145-1.aspxHI,How can i deploy the CLR Stored procedure to production i.e., different server.thanks,Fri, 15 Oct 2010 04:23:29 GMTSQL*