????????? ??? CLR ???????? ?? SQL ????? ??? ?? ??????? ?? ????? ???? ??? ?????? ?????: "??????? ??? ????? ?????? ?? ??????? ?? ???? ???? ????????? GAC ???? (HRESULT ?? ?????: 0x80131050) "

???? ?????? ???? ??????
???? ID: 949080 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?????????? ???????? ?? ????? ?????

???????? 1

?? ?? ???????? ???? ?? ?? ?? ??????? ???? ?????? (CLR) ????? ??? ?? Microsoft .NET Framework ???????? .NET Framework ??????? ??? ????? ???? ?? ????? ??? ???? 922672? ???, ??? ?? .NET Framework 3.5 ?? .NET Framework 2.0-?????? ???????? ??????? ?????

???????? 2

?? ???? ??????? ?????, ?? ???? ??? ?? ??????? ?? ???? Microsoft SQL Server ??????? ??? ???????? ???? ???, ?? ??????? ??????? ??? (GAC ???) ??????? ?? ???? ??????? ??????? ?????

??? ?? ????????? CLR ???????? ?? SQL ????? ??? ??????? ??? ?? ?? ?? ?? ?????????? ?? ????? ???? ???, ?? ???? ????? ?? ???? ?? ?????? ????? ??????? ???? ??:

?????: ????? 6522, ???? 16, ????? 2, 1 ????
.NET ?????????? ????? ???????? ???????? ?? ??????? ?? ???????? ?? ????? ?????? ??????? ??? 'getsid':

System.IO.FileLoadException: ????? ?? ??????? ??? ???? ?? ??? ' System.DirectoryServices, ??????? 2.0.0.0, ????? = = ????????, PublicKeyToken = b03f5f7f11d50a3a' ?? ?? ???? ??????????? ??????? ??? ????? ??????? ?? ???? ???? ????????? GAC ??? ?????? ???? ??? (HRESULT ?? ?????: 0x80131050)

System.IO.FileLoadException:

????

??? ??????? CLR ??? ???? ???, ?? ?? ?? ?? ??????? ??? GAC CLR ????????? ?? ??????? ??? GAC ??, CLR ?????? ???? ?? ?? ?? ??????? ??????? ??????? IDs (MVIDs) ?? ??? ????? ??? ????? ?? MVIDs ??????? ?? ???? ??? ????, ???? ?? ?????? ??????? ???? ?? ?? ????? "?????" ?????? mentions.

?? ??? ??????? recompiled ??, MVID ?? ??????? ????????? ???? ??? ?????, ??? ?? .NET Framework, .NET Framework ??????? ?? ?????? ????? MVIDs ?? ??????? ?? ??????? recompiled ???? ??? ??, ??? ??? ?? ???? ??????? ?? ??????, ??????? ?? recompiled. ?????, ??????? ?? ?? ??? ?? MVID.

????? ?????????

1 ???????? ??

???????? 1 "?????" ??? ??? ???????? ?? ?? ???, ?? ???????? ??? ?? .NET Framework ??????? SQL ????? ??? ?????? ???? ????? ??? ???? ?? ???, ???? ?? ??? ???????? ??????? ??? ?? ????? ????? ?? ??? .NET Framework ??????? ?? ??????? ????? ???????:
%Windir%\Microsoft.NET\Framework\???????
?????????? ?? ???????????? ???? ?? .NET Framework ??????? ???? ?? ??????? ?? ????????

?????? 2

???????? ?? ??-??? ??? ???? ?? ??? 2 ??? "?????" ??????, ??? ??????? ?? ?????? ???? ?? ??? ???????? ??????? ??? ?? ????? ???? ????????

??? ?????? ??? ?? ????? ?? ??? ?? ??? ???? ?? ???, ??????? ??, ??????? ????? ???? ??????? ???? ??? ??????? ??????? ??????? ????

??????

Microsoft ' % ws ' ??? ???????? Microsoft ???????? ??? ??? ?????? ?? ?? ?? ?? ?????? ?? ?? "?? ?? ????" ??? ????

???? ???????

?? ?? ????? ??? ???? 922672 ??? ????? ???? ??? ?? .NET Framework ??????? ?? ????? ????? ???? ??? ????? ??? ???? 922672 ??????? SQL ????? CLR-????? ???? ??? ??????? ??? ??????? ?? ??? ??? ?? ???????? ???? ???

???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
922672 Untested .NET Framework ??????? SQL ????? CLR-????? ???? ??? ??????? ??? ?? ??? ?????? ????

CLR routines ?? ?????

CLR routines ????? ???? ????? ?????????? ?? ????? ?? ???? ???? ??? ?? SQL Server .NET Framework CLR ?? ??? ??????:
  • Scalar-??? ???? ?????-???????? ???????? (scalar UDFs)
  • ????-??? ???? ?????-???????? ??????? (TVFs)
  • ?????-???????? ????????? (UDPs)
  • ?????-???????? ??????
  • ?????-???????? ???? ??????
  • ?????-???????? aggregates

?? ?? .NET Framework 3.5 ?? ??????? ???? ?? ??? ?????? ???? ?? ??? ???????

?? ?? .NET Framework 3.5 ?? ??????? ???? ?? ???, ?? ALTER ?? ????? ???? ????? ??????? ??? ????? ??????? ?? ?????? ???? ?? ???:
  • Accessibility.dll
  • AspNetMMCExt.dll
  • Cscompmgd.dll
  • IEExecRemote.dll
  • IEHost.dll
  • IIEHost.dll
  • Microsoft.Build.Conversion.dll
  • Microsoft.Build.Engine.dll
  • Microsoft.Build.Framework.dll
  • Microsoft.Build.Tasks.dll
  • Microsoft.Build.Utilities.dll
  • Microsoft.CompactFramework.Build.Tasks.dll
  • Microsoft.JScript.dll
  • Microsoft.VisualBasic.Vsa.dll
  • Microsoft.Vsa.dll
  • Microsoft.Vsa.Vb.CodeDOMProcessor.dll
  • Microsoft_VsaVb.dll
  • Sysglobl.dll
  • System.Configuration.Install.dll
  • System.Design.dll
  • System.DirectoryServices.dll
  • System.DirectoryServices.Protocols.dll
  • System.Drawing.dll
  • System.Drawing.Design.dll
  • System.EnterpriseServices.dll
  • System.Management.dll
  • System.Messaging.dll
  • System.Runtime.Serialization.Formatters.Soap.dll
  • System.ServiceProcess.dll
  • System.Web.dll
  • System.Web.Mobile.dll
  • System.Web.RegularExpressions.dll
?? ??????? ?? ????? ??????? ??? ???:
%Windir%\Microsoft.NET\Framework\v2.0.50727

?? ???? ??????? ???? ???? ?? ??? ?? ?????-???????? ???? ?????? ???? ?????? ???? ?? ??? ????

?? ???? ?????-???????? ???? ?????? SQL ????? ?? ????? ???? ?? ?? ???? ??????? ????, ?? ?? ????? ??????? ??? ?? ?? ???? ?????? ???? ?? ??? ????? ?? ???? ????

?? ???????? ?? ??, ??? ???:
  • ????? ??? ?? ?? ??????? ????? MyAssembly.dll.
  • MyAssembly ??????? ?????? System.DirectoryServices.dll ????????
  • ?? ???? ?????-???????? ???? ?????? ?? ????? ??? ?? MyDateTime.
  • MyAssembly.dllMyDateTime ???? ?????? ?? ????? ???? ?? ????????
  • ????? ??? ?? MyTable ?????? ??????
  • MyTable ?????? ???? MyDateTime ???? ?? ???? ?????

???? 1: ?? bcp.exe ?????? ?? ????? ????

  1. ????????? ????? ?? ??? ?n ????? ?? ??? Bcp.exe ?????? ?? ????? ???? MyTable ?????? ??? ???? ????? ?? ????? ?????? ?? ???, ????? ?? ????? ????????? ?? ????? ???????:
    bcp MyDatabase.dbo.MyTable out C:\MyFile.bcp -n ?SSQLServerName  -T
  2. ??? SQL ????? ??????? Studio, ?? ????? ?? ???? ????:
    1. MyTable ?????? ??????
    2. MyDateTime ???? ?????? ??????
    3. System.DirectoryServices.dll ?????? ????????
    4. MyAssembly ??????? ??? ???? ????
  3. ??? SQL ????? ??????? Studio, ?? ????? ?? ???? ????:
    1. System.DirectoryServices.dll ??????? ????????
    2. MyAssembly ??????? ??????? ?????
    3. MyDateTime ???? ?????? ??????
    4. ?? ?? ?????? ?????? ?? ??? ??? ???? ?? ???? ????? MyTable ???????
  4. Bcp.exe ?????? ?? ??? ???? ?? ??? ?n ????? ?? ????? ???? MyTable ?????? ??? ???? ?? ????? ?? ????? ?????? ?? ???, ????? ?? ????? ????????? ?? ????? ???????:
    bcp MyDatabase.dbo.MyTable in C:\MyFile.bcp -n ?SSQLServerName  -T

???? 2: ???????? ???? ?? ????? ????... ?? ??? ???? ???

MyDateTime ???? ?????? 9 ?????? ??? ??????? ????? ?? ???? ?????
  1. ??? SQL Server ??????? Studio, ?? ?? ???? ????? ????? ????? VARBINARY(9) ???? ?????? ?? ????? ??? ???:
    CREATE TABLE TempTable (c1 VARBINARY(9))
  2. ????? ????? ???????? ????... ?? ??? ???? ??? ?? ????????? ???? ?? ??? TempTable ??????:
    INSERT INTO TempTable SELECT CAST(c1 as VARBINARY(9)) FROM MyTable
  3. ??? SQL ????? ??????? Studio, ?? ????? ?? ???? ????:
    1. MyTable ?????? ??????
    2. MyDateTime ???? ?????? ??????
    3. System.DirectoryServices.dll ?????? ????????
    4. MyAssembly ??????? ??? ???? ????
  4. ??? SQL ????? ??????? Studio, ?? ????? ?? ???? ????:
    1. System.DirectoryServices.dll ??????? ????????
    2. MyAssembly ??????? ??????? ?????
    3. MyDateTime ???? ?????? ??????
    4. ?? ?? ?????? ?????? ?? ??? ??? ???? ?? ???? ????? MyTable ???????
  5. ????? ????? ???????? ????... ?? ??? ???? ??? ?? ????????? ???? ?? ??? MyTable ??????:
    INSERT INTO MyTable SELECT c1 FROM TempTable

??????

??????? ??????? ?? ???? ??? ???? ??????? ?? ???, ?? ???? ????? Microsoft ?????? ??????? (MSDN) ??? ????:
http://msdn2.microsoft.com/en-us/library/51ket42z (VS.80). aspx
?? ??? ??? ??????? ?? ?????? ???? ?? ????? ?? ???? ??? ???? ??????? ????? MSDN ??? ?? ???? ????:
http://msdn2.microsoft.com/en-us/library/ms186711.aspx
?? ??? ???? ?? ??????? ?????? ?? ???? ??? ???? ??????? ????? MSDN ??? ?? ???? ????:
http://msdn2.microsoft.com/en-us/library/ms177514.aspx
?? ??? ???? SQL Server 2005 ??????? ??? ?? ??????? ?? ??????? ???? ???? ?? ???? ??? ???? ???????, ?? ????? MSDN ??? ???? ?? ????:
http://msdn2.microsoft.com/en-us/library/ms189524.aspx
?? ??? Bcp.exe ?????? ?? ???? ??? ???? ??????? ????? MSDN ??? ???? ?? ????:
http://msdn2.microsoft.com/en-us/library/ms162802.aspx

???

???? ID: 949080 - ????? ???????: 07 ????? 2013 - ??????: 1.0
???? ???? ???? ??:
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
??????: 
kbexpertiseadvanced kbtshoot kbprb kbmt KB949080 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:949080

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com