CLR程序里引用System.Web.dll

默认是没有，要在目标数据库里先附加，然后.NET这里才可以引用。

 

SQL SERVER 2005:

-------------------------------------------------------------------------------------------

 

USE [mydb]
GO

EXEC sp_changedbowner 'sa'

ALTER DATABASE [mydb] SET TRUSTWORTHY ON
GO

CREATE ASSEMBLY [System.Web]
    FROM 'C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/System.Web.dll'
    WITH PERMISSION_SET = UNSAFE