在SQL Server 2005存储过程中使用.NET Framework 3.5(Using .NET Framework 3.5 in a SQL Server 2005 Stored Proce

在SQL Server 2005存储过程中使用.NET Framework 3.5(Using .NET Framework 3.5 in a SQL Server 2005 Stored Procedure)

我有一个SQL Server 2005服务器，我想运行一个.Net CLR存储过程。 但是，我想使用.NET Framework 3.5。

如果我现在尝试这个，我得到这个错误：

Error: Assembly 'system.core, version=3.5.0.0, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.

我被告知这在SQL Server 2008中是可行的，因为SQL Server 2008带有.NET Framework 3.5。 但是，我想知道是否有办法将.NET Framework 3.5添加到我的SQL Server 2005安装中，以便我可以在其上运行.NET 3.5存储过程。

I have an SQL Server 2005 server, and I'd like to run a .Net CLR stored procedure on it. However, I'd like to use .NET Framework 3.5.

If I try this right now, I get this error:

Error: Assembly 'system.core, version=3.5.0.0, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.

I'm told this is possible in SQL Server 2008, because SQL Server 2008 ships with .NET Framework 3.5. However, I'm wondering if there's a way to add .NET Framework 3.5 to my SQL Server 2005 installation, so that I can run .NET 3.5 stored procedures on it.

最满意答案

这可能是一个愚蠢的问题，但是......如果找不到system.core，你是否在数据库服务器上安装了框架3.5？

This might be a stupid question but... If system.core can't be found, do you have the framework 3.5 installed on the database server?