c# - Deploying .dll on remote sql server? -


I am trying to create an assembly but my remote SQL server is my Dll can not access the file.

  Make assembly barcode from SQL 'X: \ test.dll' PERMISSION_SET = SAFE   

I do not know how to put test.dll SQL server, but I know that I can send serialized DLL instead of DLL. How can I serialize DLL? I can not find this address

I am trying to create an assembly but my Remote sql server me Dll file.

This is because it is looking for X: \ on the server where the SQL instance is running, is not running with SQL. <

You can specify a network path in CREATE ASSEMBLY:

  '\\ yourmachine \ sharetox \ Test.dll with PERMISSION_SET = are protected  by creating assembly BarcodeSql>  

Or, you could actually rank it in sequence. Use of PowerShell:

  "0x" + [System.BitConverter] :: ToString ([System.IO.File] :: ReadAllBytes ("X: \ text.dll")). Replace ("-", "")   

which will print some large hex value. You can use VARBINARY literal when creating an assembly:

  assembly barcode SQL from 0x23456789 PERMISSION_SET = SAFE   P > Where 0x123456789 is the output of PowerShell Script.   

Comments