How to alter assembly ?

Question

i was trying to alter an assembly in sql server , but it always return an error that i dont have permissions or it doest not exist ( i verified that it exist already and verified all the persmissions needed ) is there in solution ?

i tried both ways via query and via GUI .

Answer 1

Hi,

the basic code is like:

ALTER ASSEMBLY ComplexNumber 
FROM 'C:\Program Files\Microsoft SQL Server\130\Tools\Samples\1033\Engine\Programmability\CLR\UserDefinedDataType\CS\ComplexNumber\obj\Debug\ComplexNumber.dll'

For full documentations and sample code, check this:

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-assembly-transact-sql?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699

Answer 2

Change the ALTER ASSEMBLY statement to CREATE ASSEMBLY to find out which part of the error message that is true. If CREATE completes successfully, the assembly did not exist after all. (Maybe you are in the wrong database.) And if you don't have permission, you will get a permission error.

Answer 3

Hi @Hania ABECHE

Do you use sys.assemblies to check if it exists? It returns relevant information.

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-assemblies-transact-sql?view=sql-server-ver16

Best regards,

Percy Tang