CLR Assemblies in SQL Server

snap555

On SQL 2008 valid TSQL calls are :

CREATE ASSEMBLY [TestAssembly] FROM 0x4D5A90..000

ALTER ASSEMBLY [TestAssembly] FROM 0x4D5A90..000

ALTER ASSEMBLY [TestAssembly] FROM 'C:\TestAssembly.dll'

DROP ASSEMBLY [TestAssembly]

--used to show the installed Assembly.ManifestModule.ModuleVersionId
SELECT ASSEMBLYPROPERTY(N'TestAssembly', 'MvID')

 
 

MvID on VStudio

snap556
 
 

list the installed assemblies

snap557

--https://msdn.microsoft.com/en-us/library/ms131107(v=sql.105).aspx
select * from sys.assembly_files

 
 

Refreshing changed .NET SQL CLR assemblies after patching/updates

http://www.trycatchfinally.net/2013/03/refreshing-changed-net-sql-clr-assemblies-after-patchingupdates/

By: |04/01/2016|categories: