Posts CLR Assemblies in SQL Server
Post
Cancel

CLR Assemblies in SQL Server

snap555

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

snap556

list the installed assemblies

snap557

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

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

origin - http://www.pipiscrew.com/?p=3023 clr-assemblies-in-sql-server

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags