FIX: ????? ??????? ???? ?? SQL Server 2005 ???? ??????? ????? ??? ????? ??? ????? ????????? ??? ????? ????? ??????

?????? ????????? ?????? ?????????
???? ???????: 940128 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50001440 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

???? ??????? ????? ?? Microsoft SQL Server 2005. ????? ???? ????? ????????? ??? ????? ????? ????? ??????. ??? ????? ????????? ???? ????????? ????????? ????? ????????? Microsoft SQL Server 2000.

?????? ???? ???? ??? ????? ????? ????? ????? ?????? ??? ????? ????????? ??? ?????? ???????? IN ?? ???? ?????? EXISTS.

?????

???? ??? ??????? ???? ?????? ????????? ?????? ?????? ?? ???? ?? ??? ??????? ?? ???? SQL Server 2000. ????? ?? ?????? ????????? ????. ??? ???? ???? ????? ?????? ??????? ????? ?? ????? ??? ??? ?????? ??????? ???? ???? ???? ????? ??? ???? ????.

?????? ?? ??? ??? ?????? ????????? ???? ????? ?? StatementOptmEarlyAbortReason = "????" ??????? ?? ?????? XML ?? ??? ??????? Showplan.

????

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

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

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

  • SQL Server 2005 Service Pack 2

    ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 ????? 32-??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Chsbrkr.dll12.0.7822.01,684,84022 ????? ????09: 22x 86
Chtbrkr.dll12.0.7822.06,112,61622 ????? ????09: 22x 86
Databasemailprotocols.dll9.0.3182.046,44810 ????? ??????: ??x 86
Fteref.dll12.0.7822.0446,46422 ????? ????09: 22x 86
Infosoft.dll12.0.7822.0468,32822 ????? ????09: 22x 86
Korwbrkr.dll12.0.7822.071,01622 ????? ????09: 22x 86
Langwrbk.dll12.0.7822.0136,55222 ????? ????09: 22x 86
Microsoft.analysisservices.dll9.0.3182.01,217,90410 ????? ??????: ??x 86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3182.0296,30410 ????? ??????: ??x 86
Msfte.dll12.0.7822.02,430,31222 ????? ????09: 22x 86
Msftefd.exe12.0.7822.066,92022 ????? ????09: 22x 86
Msftepxy.dll12.0.7822.095,59222 ????? ????09: 22x 86
Msftesql.exe12.0.7822.095,59222 ????? ????09: 22x 86
Msir5jp.dll5.0.2130.03,159,91222 ????? ????09: 22x 86
Msmdlocal.dll9.0.3182.015,948,14410 ????? ??????: ??x 86
Mssqlsystemresource.ldf??? ???? ???????524,28810 ????? ????01: 45??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03210 ????? ????01: 45??? ???? ???????
Nlhtml.dll12.0.7822.0124,26422 ????? ????09: 22x 86
Nls400.dll5.0.4217.012,240,74422 ????? ????09: 22x 86
Odsole70.dll2005.90.3182.059,24810 ????? ??????: ??x 86
Query.dll12.0.7822.048,48822 ????? ????09: 22x 86
Rdistcom.dll2005.90.3182.0644,97610 ????? ??????: ??x 86
Replmerg.exe2005.90.3182.0320,88010 ????? ??????: ??x 86
Replrec.dll2005.90.3182.0784,75210 ????? ??????: ??x 86
Sqlaccess.dll2005.90.3182.0350,57610 ????? ??????: ??x 86
Sqlagent90.exe2005.90.3182.0349,55210 ????? ??????: ??x 86
Sqlservr.exe2005.90.3182.029,195,12010 ????? ??????: ??x 86
Sqlwep.dll2005.90.3182.090,99210 ????? ??????: ??x 86
Sqsrvres.dll2005.90.3182.070,51210 ????? ??????: ??x 86
Sysdbupg.sql??? ???? ???????510,62213-Jun-200701: 18??? ???? ???????
Thawbrkr.dll12.0.7822.0206,18422 ????? ????09: 22x 86
Xmlfilt.dll12.0.7822.0197,99222 ????? ????09: 22x 86
Xpstar90.dll2005.90.3182.0298,86410 ????? ??????: ??x 86
SQL Server 2005? x 64-based ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Chsbrkr.dll12.0.7822.01,694,05622 ????? ????10: 51x 64
Chtbrkr.dll12.0.7822.06,109,03222 ????? ????10: 51x 64
Databasemailprotocols.dll9.0.3182.046,44810 ????? ????07: 51x 86
Fteref.dll12.0.7822.0433,15222 ????? ????10: 51x 64
Infosoft.dll12.0.7822.0621,41622 ????? ????10: 51x 64
Korwbrkr.dll12.0.7822.0101,73622 ????? ????10: 51x 64
Langwrbk.dll12.0.7822.0236,90422 ????? ????10: 51x 64
Microsoft.analysisservices.dll9.0.3182.01,217,90410 ????? ??????: ??x 86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3182.0296,30410 ????? ??????: ??x 86
Msfte.dll12.0.7822.03,808,10422 ????? ????10: 51x 64
Msftefd.exe12.0.7822.099,17622 ????? ????10: 51x 64
Msftepxy.dll12.0.7822.0127,33622 ????? ????10: 51x 64
Msftesql.exe12.0.7822.0158,56822 ????? ????10: 51x 64
Msir5jp.dll5.0.2130.03,421,54422 ????? ????10: 51x 64
Msmdlocal.dll9.0.3182.015,948,14410 ????? ??????: ??x 86
Mssqlsystemresource.ldf??? ???? ???????524,28810 ????? ????01: 45??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03210 ????? ????01: 45??? ???? ???????
Nlhtml.dll12.0.7822.0191,84822 ????? ????10: 51x 64
Nls400.dll5.0.4217.014,101,35222 ????? ????10: 51x 64
Odsole70.dll2005.90.3182.090,48010 ????? ????07: 51x 64
Query.dll12.0.7822.068,45622 ????? ????10: 51x 64
Rdistcom.dll2005.90.3182.0828,78410 ????? ????07: 51x 64
Replmerg.exe2005.90.3182.0417,64810 ????? ????07: 51x 64
Replrec.dll2005.90.3182.01,011,56810 ????? ????07: 51x 64
Sqlaccess.dll2005.90.3182.0357,74410 ????? ????07: 51x 86
Sqlagent90.exe2005.90.3182.0429,42410 ????? ????07: 51x 64
Sqlservr.exe2005.90.3182.039,679,34410 ????? ????07: 51x 64
Sqlwep.dll2005.90.3182.0123,76010 ????? ????07: 51x 64
Sqlwep.dll2005.90.3182.090,99210 ????? ??????: ??x 86
Sqsrvres.dll2005.90.3182.083,31210 ????? ????07: 51x 64
Sysdbupg.sql??? ???? ???????510,62213-Jun-200701: 18??? ???? ???????
Thawbrkr.dll12.0.7822.0209,76822 ????? ????10: 51x 64
Xmlfilt.dll12.0.7822.0271,20822 ????? ????10: 51x 64
Xpstar90.dll2005.90.3182.0550,25610 ????? ????07: 51x 64
SQL Server 2005 ??????? ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Chsbrkr.dll12.0.7822.01,883,49622 ????? ????10: 06IA-64
Chtbrkr.dll12.0.7822.06,153,57622 ????? ????10: 06IA-64
Databasemailprotocols.dll9.0.3182.046,44810 ????? ????13: 01x 86
Fteref.dll12.0.7822.0433,15222 ????? ????10: 06IA-64
Infosoft.dll12.0.7822.01,915,24022 ????? ????10: 06IA-64
Korwbrkr.dll12.0.7822.0182,63222 ????? ????10: 06IA-64
Langwrbk.dll12.0.7822.0333,16022 ????? ????10: 06IA-64
Microsoft.analysisservices.dll9.0.3182.01,217,90410 ????? ??????: ??x 86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3182.0296,30410 ????? ??????: ??x 86
Msfte.dll12.0.7822.07,072,10422 ????? ????10: 06IA-64
Msftefd.exe12.0.7822.0173,41622 ????? ????10: 06IA-64
Msftepxy.dll12.0.7822.0135,52822 ????? ????10: 06IA-64
Msftesql.exe12.0.7822.0294,76022 ????? ????10: 06IA-64
Msir5jp.dll5.0.2130.03,824,48822 ????? ????10: 06IA-64
Msmdlocal.dll9.0.3182.049,907,05610 ????? ????13: 01IA-64
Mssqlsystemresource.ldf??? ???? ???????524,28810 ????? ????01: 45??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03210 ????? ????01: 45??? ???? ???????
Nlhtml.dll12.0.7822.0295,78422 ????? ????10: 06IA-64
Nls400.dll5.0.4217.014,750,05622 ????? ????10: 06IA-64
Odsole70.dll2005.90.3182.0179,56810 ????? ????13: 01IA-64
Query.dll12.0.7822.0123,24022 ????? ????10: 06IA-64
Rdistcom.dll2005.90.3182.01,885,55210 ????? ????13: 01IA-64
Replmerg.exe2005.90.3182.0957,29610 ????? ????13: 01IA-64
Replrec.dll2005.90.3182.02,145,13610 ????? ????13: 01IA-64
Sqlaccess.dll2005.90.3182.0352,11210 ????? ????13: 01x 86
Sqlagent90.exe2005.90.3182.01,254,25610 ????? ????13: 01IA-64
Sqlservr.exe2005.90.3182.072,819,56810 ????? ????13: 01IA-64
Sqlwep.dll2005.90.3182.0221,04010 ????? ????13: 01IA-64
Sqlwep.dll2005.90.3182.090,99210 ????? ??????: ??x 86
Sqsrvres.dll2005.90.3182.0147,31210 ????? ????13: 01IA-64
Sysdbupg.sql??? ???? ???????510,62213-Jun-200701: 18??? ???? ???????
Thawbrkr.dll12.0.7822.0253,28822 ????? ????10: 06IA-64
Xmlfilt.dll12.0.7822.0445,80022 ????? ????10: 06IA-64
Xpstar90.dll2005.90.3182.0966,00010 ????? ????13: 01IA-64

???? ??????

??????? ?????? ??? ??? ??????? ???? ??????? ?????? ???????? IN ?? ?????? ???????? EXISTS.

?????

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

??????? ????

??? ????? ??? ??????? ?????? ??? ????? ?????? ????? 4102 ? ????? ???? 4118 ???? ?????? ???? ??? ?????? ?? SQL Server 2000. ??? ????? ?? ???? ???? ???????? ??????? ??????? ?? ??? "???? ??????" ??? ????? ??? ??????? ??????.

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

????? ?? ????????? ??? ????? ????? ?????? ?????? ???? ???????? ??????? ?? SQL Server 2005 ????????:
  • TRACEON DBCC (Transact-SQL)
  • ???? ?????? (Transact-SQL)
  • TRACESTATUS DBCC (Transact-SQL)
  • ??? ????????? ??? ????? "???? ????? ??????" ?? SQL Server 2005
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server

????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 940128 - ????? ??? ??????: 11/?? ??????/1428 - ??????: 2.4
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB940128 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????940128

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

 

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