Monthly Archive: January 2013

0

Manually create assembly to MS database

ALTER DATABASE DBNAME SET TRUSTWORTHY ON GO EXEC sp_changedbowner ‘sa’ GO CREATE ASSEMBLY [ASSEMBLYNAME] AUTHORIZATION dbo FROM ‘E:\ASSEMBLYNAME\bin\Debug\ASSEMBLYNAME.dll’ WITH PERMISSION_SET = UNSAFE GO CREATE PROCEDURE [dbo].[spASSEMBLYPROCEDURE] AS EXTERNAL NAME [ASSEMBLYNAME].[StoredProcedures].[spASSEMBLYPROCEDURE] GO