﻿-- test
exec sp_configure

exec sp_configure 'clr enabled',1
reconfigure with override


exec sp_configure 'show advanced options',1
reconfigure with override


exec sp_configure 'clr strict security',0;
reconfigure with override


USE master;   
GO    

CREATE ASSEMBLY MarkupDataParse 
FROM 'D:\Markus_V3\dbFunctions\MarkupDataParse.dll'
WITH PERMISSION_SET = SAFE;  


select * from sys.assemblies

USE markus_SEC;   
GO    

CREATE FUNCTION MarkupDataCompress(@inputString NVARCHAR(MAX))
RETURNS NVARCHAR(MAX)
AS EXTERNAL NAME MarkupDataParse.[MarkupDataParse.MarkupDataFunctions].CompressString;
