FIX: ???? ????? Service Broker ????? ????? ??????? ?? ????? ?????? ????? ???????? ???? ????? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 940286 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50001495 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

???????

?? ????? ?????? ????? ???????? ???? Microsoft SQL Server 2005 ?????? ???? ????? Service Broker ????? ??????? ?? ???? ????? ??????? ?????. ???? ??? ??????? ???? ???? ? ??????? ??????.

??? ???? ??? ???????? ??? ????? ??? ????? ?????. ???????? ??? ???? ??? ????? ????? ????? ??????? ???? ????? ?? ??? ????? SQL Server 2005:
Date Time SPID ????? ??????? ???? ??? ???????. ' TCP: / / plpossrv135:4027 '?? ????' ??? ????? ' []. ' tcp: / / slpossrv135:4027 '?? ????' ??? ????? ' [].
Date Time SPID ??? ??????? ??????? ????? ???? ??? ?????? ?????. ' TCP: / / plpossrv048:4027 '?? ????' ??????? ' []. ' tcp: / / slpossrv048:4027 '?? ????' ??? ????? ' [].
Date Time ????? ????????? ??? ?? ????? ??? ???????. ShvaWebHO ????? ????????: ????? date(time): 2006/07/17(23:01:56) LSN ?????: 50098:8649:37 LSN ??????: 50136:18614:1 ? ??? ?? ??????? ?????: 2 ? ??????? ??????: (FILE = 1? TYPE = VIRTUAL_DEVICE: {'5 VDI_0F67AA24 91 C-47 C 6 B048 7662275C1E35_0 '??' 5 VDI_0F67AA24 D D 91 47 6-B048-7662275C1E35_1'}). ??? ????? ??????? ???. ????? ?? ????? ?? ????????.
Date Time SPID ??? ?????? ????? ?????? ?????: ????? 'SERVICE_BROKER_TRANSMISSION_WORK' ? 0000000082EA40E0 ???? ???? 4 ?????? 0x0000000004ACC718: 0 waittime 300 ? ?????? 0xa ???? ?????? 0x00000000052F9978. ?????? ????????.
Date Time SPID ??????? 'dbghelp.dll' ??????? '4.0.5'
Date Time SPID ** ????? ???? ??????? - spid = 104 PSS = 0x0000000089DCEB40 EC = 0x0000000089DCEB50
Date Time SPID *** ????? ?????? ??? ??????? ??? Server\MSSQL.6\MSSQL\LOG\SQLDump0011.txt SQL R:\Microsoft
Date Time SPID * *******************************************************************************
Date Time SPID *
Date Time SPID * ????? ?????? ?????:
Date Time SPID * ?/26/07 13: 16: 51 spid 104
Date Time SPID *
Date Time SPID * ???? ?????
Date Time SPID *
Date Time SPID *
Date Time SPID * *******************************************************************************
Date Time SPID * -------------------------------------------------------------------------------
Date Time SPID * ????? ?????? ?????
Date Time SPID ??? ????? ??????? ?????? 0x0000000156139452
Date Time SPID ??? ?????? ????? ?????? ?????: ????? 'SERVICE_BROKER_TRANSMITTER' ? ???? 0000000080283900 ? ???? 4 ?????? 0x0000000003C74EF8: 0 waittime 300 ? ?????? 0x1008 ???? ?????? 0x0000000000000000. ?????? ????????.
Date Time SPID ????? ??????? ???????? ??? 0x20000001 ???????. Date

????

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

?? ????? ????? ?????? ???? ??????? ????? ???? ??????? ?? ???? ?????? ????? ?? 4 ??????? ????????.????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
941450???? ??????? ???????? 4 SQL Server 2005 ?????? ????? ?????? SP2
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ??? ???? ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????.????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
??? ????? ????????? ??????? SQL Server 2005 ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

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

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

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

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

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

  • Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1

    ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2236.069,48813 ????? ????12: 18x 86
Databasemailengine.dll9.0.2236.075,12013 ????? ????12: 18x 86
Logread.exe2005.90.2236.0400,75213 ????? ????00: 19x 86
Microsoft.analysisservices.adomdclient.dll9.0.2236.0546,16013 ????? ????00: 19x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2236.0140,65613 ????? ????00: 19x 86
Microsoft.analysisservices.dll9.0.2236.01,217,90413 ????? ????00: 19x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2236.078,19213 ????? ????00: 19x 86
Microsoft.sqlserver.sqlenum.dll9.0.2236.0910,70413 ????? ????00: 19x 86
Msasxpress.dll9.0.2236.024,94413 ????? ????00: 19x 86
Msgprox.dll2005.90.2236.0200,56013 ????? ????00: 19x 86
Msmdlocal.dll9.0.2236.015,647,08813 ????? ????00: 19x 86
Msmdredir.dll9.0.2236.03,993,96813 ????? ????00: 19x 86
Mssqlsystemresource.ldf??? ???? ???????524,28812 ????? 200708: 05??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03212 ????? 200708: 05??? ???? ???????
Odsole70.dll2005.90.2236.059,76013 ????? ????00: 19x 86
Qrdrsvc.exe2005.90.2236.0369,52013 ????? ????00: 19x 86
Rdistcom.dll2005.90.2236.0643,44013 ????? ????00: 19x 86
Repldp.dll2005.90.2236.0187,24813 ????? ????00: 19x 86
Replmerg.exe2005.90.2236.0320,88013 ????? ????00: 19x 86
Replprov.dll2005.90.2236.0550,25613 ????? ????00: 19x 86
Replrec.dll2005.90.2236.0784,75213 ????? ????00: 19x 86
Replsub.dll2005.90.2236.0407,40813 ????? ????00: 19x 86
Spresolv.dll2005.90.2236.0177,00813 ????? ????00: 19x 86
Sqlaccess.dll2005.90.2236.0350,57613 ????? ??????: ??x 86
Sqlagent90.exe2005.90.2236.0321,39213 ????? ??????: ??x 86
Sqlservr.exe2005.90.2236.028,980,64813 ????? ??????: ??x 86
Sqsrvres.dll2005.90.2236.066,41613 ????? ??????: ??x 86
Sysdbupg.sql??? ???? ???????218,486?? ????? ????15: 39??? ???? ???????
Xmlsub.dll2005.90.2236.0195,44013 ????? ??????: ??x 86
Xpstar90.dll2005.90.2236.0295,28013 ????? ??????: ??x 86
Xpstar90.rll2005.90.2236.0155,50413 ????? ????00: 19x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2236.088,94413 ????? ????00: 01x 64
Databasemailengine.dll9.0.2236.075,12013 ????? ????00: 01x 86
Logread.exe2005.90.2236.0525,16813 ????? ????00: 01x 64
Microsoft.analysisservices.adomdclient.dll9.0.2236.0546,16013 ????? ????00: 19x 86
Microsoft.analysisservices.adomdclient.dll9.0.2236.0546,16013 ????? ????00: 01x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2236.0140,65613 ????? ????00: 19x 86
Microsoft.analysisservices.dll9.0.2236.01,217,90413 ????? ????00: 19x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2236.078,19213 ????? ????00: 19x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2236.094,06413 ????? ????00: 02x 64
Microsoft.sqlserver.sqlenum.dll9.0.2236.0877,93613 ????? ????00: 02x 86
Msasxpress.dll9.0.2236.024,94413 ????? ????00: 19x 86
Msasxpress.dll9.0.2236.030,06413 ????? ????00: 02x 64
Msgprox.dll2005.90.2236.0262,00013 ????? ????00: 02x 64
Msmdlocal.dll9.0.2236.015,647,08813 ????? ????00: 19x 86
Msmdredir.dll9.0.2236.03,993,96813 ????? ????00: 19x 86
Mssqlsystemresource.ldf??? ???? ???????524,28812 ????? 200708: 05??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03212 ????? 200708: 05??? ???? ???????
Odsole70.dll2005.90.2236.090,99213 ????? ????00: 02x 64
Qrdrsvc.exe2005.90.2236.0434,03213 ????? ????00: 02x 64
Rdistcom.dll2005.90.2236.0836,46413 ????? ????00: 02x 64
Repldp.dll2005.90.2236.0187,24813 ????? ????00: 19x 86
Repldp.dll2005.90.2236.0237,93613 ????? ????00: 02x 64
Replmerg.exe2005.90.2236.0417,64813 ????? ????00: 02x 64
Replprov.dll2005.90.2236.0747,88813 ????? ????00: 02x 64
Replrec.dll2005.90.2236.01,010,54413 ????? ????00: 02x 64
Replsub.dll2005.90.2236.0528,24013 ????? ????00: 02x 64
Spresolv.dll2005.90.2236.0225,64813 ????? ????00: 02x 64
Sqlaccess.dll2005.90.2236.0357,74413 ????? ????00: 02x 86
Sqlagent90.exe2005.90.2236.0392,56013 ????? ????00: 02x 64
Sqlservr.exe2005.90.2236.039,389,55213 ????? ????00: 02x 64
Sqsrvres.dll2005.90.2236.078,19213 ????? ????00: 02x 64
Sysdbupg.sql??? ???? ???????218,486?? ????? ????15: 39??? ???? ???????
Xmlsub.dll2005.90.2236.0319,85613 ????? ????00: 02x 64
Xpstar90.dll2005.90.2236.0543,60013 ????? ????00: 02x 64
Xpstar90.rll2005.90.2236.0156,01613 ????? ????00: 02x 64
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2236.0157,55213 ????? ????04: 16IA-64
Databasemailengine.dll9.0.2236.075,12013 ????? ????04: 16x 86
Logread.exe2005.90.2236.01,098,09613 ????? ????04: 16IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2236.0546,16013 ????? ????00: 19x 86
Microsoft.analysisservices.adomdclient.dll9.0.2236.0546,16013 ????? ????04: 16x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2236.0140,65613 ????? ????00: 19x 86
Microsoft.analysisservices.dll9.0.2236.01,217,90413 ????? ????00: 19x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2236.078,19213 ????? ????00: 19x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2236.0165,74413 ????? ????04: 16IA-64
Microsoft.sqlserver.sqlenum.dll9.0.2236.0877,93613 ????? ????04: 16x 86
Msasxpress.dll9.0.2236.024,94413 ????? ????00: 19x 86
Msasxpress.dll9.0.2236.057,71213 ????? ????04: 16IA-64
Msgprox.dll2005.90.2236.0545,13613 ????? ????04: 16IA-64
Msmdlocal.dll9.0.2236.048,724,84813 ????? ????04: 16IA-64
Msmdredir.dll9.0.2236.06,249,32813 ????? ????04: 16IA-64
Mssqlsystemresource.ldf??? ???? ???????524,28812 ????? 200708: 05??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,03212 ????? 200708: 05??? ???? ???????
Odsole70.dll2005.90.2236.0180,08013 ????? ????04: 16IA-64
Qrdrsvc.exe2005.90.2236.0943,98413 ????? ????04: 16IA-64
Rdistcom.dll2005.90.2236.01,884,01613 ????? ????04: 16IA-64
Repldp.dll2005.90.2236.0187,24813 ????? ????00: 19x 86
Repldp.dll2005.90.2236.0511,34413 ????? ????04: 16IA-64
Replmerg.exe2005.90.2236.0957,29613 ????? ????04: 16IA-64
Replprov.dll2005.90.2236.01,619,82413 ????? ????04: 16IA-64
Replrec.dll2005.90.2236.02,143,60013 ????? ????04: 16IA-64
Replsub.dll2005.90.2236.01,159,53613 ????? ????04: 16IA-64
Spresolv.dll2005.90.2236.0498,03213 ????? ????04: 16IA-64
Sqlaccess.dll2005.90.2236.0352,11213 ????? ????04: 16x 86
Sqlagent90.exe2005.90.2236.01,143,66413 ????? ????04: 16IA-64
Sqlservr.exe2005.90.2236.072,526,70413 ????? ????04: 17IA-64
Sqsrvres.dll2005.90.2236.0137,07213 ????? ????04: 17IA-64
Sysdbupg.sql??? ???? ???????218,486?? ????? ????15: 39??? ???? ???????
Xmlsub.dll2005.90.2236.0593,26413 ????? ????04: 17IA-64
Xpstar90.dll2005.90.2236.0953,71213 ????? ????04: 17IA-64
Xpstar90.rll2005.90.2236.0154,99213 ????? ????04: 16IA-64

?????

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

??????? ????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ???? ?????? Service Pack 2 ?????? ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005
????? ?? ????????? ??? ??????? ??????? ?????????? ?? SQL Server 2005 ?????? ????? ?????? SP2 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://go.microsoft.com/fwlink/?LinkId=71711
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 940286 - ????? ??? ??????: 10/?? ??????/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 KB940286 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????940286

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

 

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