go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
alter database [Channelloc] set trustworthy on
CREATE ASSEMBLY [System.Drawing]
authorization [dbo]
from 'd:\sng\System.Drawing.dll'
WITH PERMISSION_SET = unSAFE
CREATE ASSEMBLY [System.Windows.Forms]
authorization [dbo]
from 'd:\sng\System.Windows.Forms.dll'
WITH PERMISSION_SET = unSAFE
CREATE ASSEMBLY [System.Configuration.Install]
authorization [dbo]
from 'd:\sng\System.Configuration.Install.dll'
WITH PERMISSION_SET = unSAFE
CREATE ASSEMBLY [System.Messaging]
authorization [dbo]
from 'd:\sng\System.Messaging.dll'
WITH PERMISSION_SET = unSAFE
CREATE ASSEMBLY [CNPostMsg]
authorization [dbo]
from 'd:\sng\PostMsg.dll'
WITH PERMISSION_SET = unSAFE
CREATE PROCEDURE [dbo].[ProPostMQMsg]
@id [int],
@msgCategory [nvarchar](20)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [CNPostMsg].[PostMsg.PostMsg].[ProPostMQMsg]
GO
drop PROCEDURE [dbo].[ProPostMQMsg]