sql server 2005 加载程序集 CREATE ASSEMBLY

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]