On SQL 2008 valid TSQL calls are :
1
2
3
4
5
6
7
8
9
10
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
list the installed assemblies
1
2
--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
origin - http://www.pipiscrew.com/?p=3023 clr-assemblies-in-sql-server