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

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

?? ??? ??????

???????

?? ???? ???????? ???????????? ???????.

????????? 1

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

????????? 2

????? ?????? ??? ?? ????? ??????? ?? ????? ?????? Microsoft SQL Server. ?? ????? ????? ????? ?? ??????? ?? ???? ??????? ??????? ?????? (GAC).

??? ????? ????? CLR ?? ??????? ??????? ?? ?? ?? ??? ???????????? ?? SQL Server? ????? ????? ??? ?????? ??? ???:

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

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

System.IO.FileLoadException:
???? ??? ?????? | ????? ???????

?????

????? ????? ???? CLR ?????? ?????? CLR ?? ??? ??????? ?? GAC. ??? ??? ??? ??????? ?? GAC? ????? ?? CLR ???? ????? "?????? ????? ?????? ???????" (?????) ??? ?????????. ??? ????? ???? ?? ????? ?????????? ????? ????? ??????? ???? ??? "???????" ????????.

????? ??? ????? ????? ?????? MVID ??????? ?? ???????. ????? ??? ??? ?????? ??????.NET Framework? ???????.NET Framework ??? ????? ?????? ??? ??? ??????? ??????? ???? ?????????. ???????? ??? ???? ??? ??? ????? ??????? ????? ??? ???????? ??????? ???????. ????? ???? ??? ??????? ????? MVID.
???? ??? ?????? | ????? ???????

???? ??????

???? 1

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

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

?????? ??? ????????? 2 ???? "???????"? ??????? ????? ALTER assembly ?????? ??????? ?? ????? ????????.

??? ???? ??????? ?? ???? ?????? ??? ?????? ????? ??? ????? ??????? ?? ????? ????????? ???? ??? ??????? ????? ???? ?? ??????? ?? ????? ????????.
???? ??? ?????? | ????? ???????

?????

Microsoft ???? ???? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

??????? ????

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
922672
(http://support.microsoft.com/kb/922672/ )
????? ??? ????????.NET Framework ???? ?? ??? ???????? ?? ???? ??????? CLR ???? SQL

??? ??????? CLR

??????? CLR ????? ???????? ??????? ???? ??? ??????? ???????? ????? ???? SQL ?? NET Framework CLR:
  • ???? ????? ??????? ??????? ?? ??? ???????? ????? ???? (???? ????? ??????? UDFs)
  • ????? ???? ?????? ??????? ?? ??? ???????? (????)
  • ????????? ??????? ?? ??? ???????? (???????)
  • ?????? ??????? ?? ??? ????????
  • ????? ???????? ??????? ?? ??? ????????
  • ??????? ??????? ?? ??? ????????

??????? ?????? ??? ?????.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 Server? ????? ??????? ???? ????? ??????? ???????? ?????????.

????? ?? ?? ??? ?? ?????????:
  • ????? ????? ???? MyAssembly.dll.
  • ????? ??????? MyAssembly ????? System.DirectoryServices.dll .
  • ??? ??? ?????? ??????? ?? ??? ???????? ???? ??? ??????????.
  • ?????? ??? ???????? ??????????MyAssembly.dll ???????.
  • ????? ???? ???? ?? ??? ??????.
  • ???? ?????? ????? ??? ???????? ???????? ?????????? ???.

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

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

??????? 2: ??????? INSERT... ????? SELECT

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

?????

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

???????

???? ???????: 949080 - ????? ??? ??????: 25/???/1434 - ??????: 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 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????949080
(http://support.microsoft.com/kb/949080/en-us/ )
???? ??? ?????? | ????? ???????

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

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