FIX: ??? ????? ?????? ??? ?????? ?? ?????? ?????? ?? SQL Server 2005 ???????? ????? INPUTBUFFER DBCC ????? ???? 1204 ??? ????? ????? ??????? ???? ???? ??? ?? "?????? ??????"

?????? ????????? ?????? ?????????
???? ???????: 932990 - ??? ???????? ???? ????? ????? ??? ???????.
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????
???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

?????? ???? ????? ??????? ?????? ??? ?????? ?? ?????? ?????? ?? SQL Server 2005:
  • ????? ??????? INPUTBUFFER DBCC.
  • ????? ???? ??????? 1204 ???????? ???? ???? ???? ???.
  • ?????? ??? ????? Graph Deadlock ?????? ????? ???? ???? ???.
  • ?????? ???? ?????? ?????? Microsoft SQL Server ????? Studio.
??? ????? ?? ???? ???? SQL ?????? ?? ?? ??????? ???????:
  • ?????? ?? ???? ???????.
  • ??? ??????? (RPC) ??????? ????? ?? ????.
  • ???? ?????.

?????

???? ??? ??????? ?? ???? ????? ?????? Sp_cursorprepexec ??? ????? ??? ??????? ????? ?????? ??? ???????? ?? ?????? ??????.

????

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

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

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

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

??? ?? ???? ???? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ????? ????? ??? ??????? ??????.

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2224.069,488?? ?????? ????00: 34x 86
Databasemailengine.dll9.0.2224.075,120?? ?????? ????00: 34x 86
Logread.exe2005.90.2224.0400,752?? ?????? ????00: 34x 86
Microsoft.analysisservices.adomdclient.dll9.0.2224.0546,160?? ?????? ????00: 34x 86
Microsoft.analysisservices.deployengine.dll9.0.2224.0140,656?? ?????? ????00: 34x 86
Microsoft.analysisservices.dll9.0.2224.01,217,904?? ?????? ????00: 34x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2224.078,192?? ?????? ????00: 34x 86
Microsoft.sqlserver.sqlenum.dll9.0.2224.0910,704?? ?????? ????00: 34x 86
Msasxpress.dll9.0.2224.024,944?? ?????? ????00: 34x 86
Msgprox.dll2005.90.2224.0200,560?? ?????? ????00: 34x 86
Msmdlocal.dll9.0.2224.015,646,064?? ?????? ????00: 34x 86
Msmdredir.dll9.0.2224.03,993,968?? ?????? ????00: 34x 86
Qrdrsvc.exe2005.90.2224.0369,520?? ?????? ????00: 34x 86
Rdistcom.dll2005.90.2224.0643,440?? ?????? ????00: 34x 86
Repldp.dll2005.90.2224.0187,248?? ?????? ????00: 34x 86
Replmerg.exe2005.90.2224.0320,880?? ?????? ????00: 34x 86
Replprov.dll2005.90.2224.0550,256?? ?????? ????00: 34x 86
Replrec.dll2005.90.2224.0784,752?? ?????? ????00: 34x 86
Replsub.dll2005.90.2224.0407,408?? ?????? ????00: 34x 86
Spresolv.dll2005.90.2224.0177,008?? ?????? ????00: 34x 86
Sqlaccess.dll2005.90.2224.0350,576?? ?????? ????00: 34x 86
Sqlagent90.exe2005.90.2224.0321,392?? ?????? ????00: 34x 86
Sqlservr.exe2005.90.2224.028,978,088?? ?????? ????00: 35x 86
Xmlsub.dll2005.90.2224.0195,440?? ?????? ????00: 35x 86
Xpstar90.dll2005.90.2224.0295,280?? ?????? ????00: 35x 86
Xpstar90.rll2005.90.2224.0155,504?? ?????? ????00: 34??? ???? ???????
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2224.088,944?? ?????? ????00: 59x 64
Databasemailengine.dll9.0.2224.075,120?? ?????? ????00: 59x 86
Logread.exe2005.90.2224.0525,168?? ?????? ????00: 59x 64
Microsoft.analysisservices.adomdclient.dll9.0.2224.0546,160?? ?????? ????00: 59x 86
Microsoft.analysisservices.deployengine.dll9.0.2224.0140,656?? ?????? ????00: 34x 86
Microsoft.analysisservices.dll9.0.2224.01,217,904?? ?????? ????00: 34x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2224.094,064?? ?????? ????00: 59x 64
Microsoft.sqlserver.sqlenum.dll9.0.2224.0877,936?? ?????? ????00: 59x 86
Msasxpress.dll9.0.2224.030,064?? ?????? ????00: 34x 64
Msgprox.dll2005.90.2224.0262,000?? ?????? ????00: 59x 64
Msmdlocal.dll9.0.2224.015,646,064?? ?????? ????00: 34x 86
Msmdredir.dll9.0.2224.03,993,968?? ?????? ????00: 34x 86
Qrdrsvc.exe2005.90.2224.0434,032?? ?????? ????00: 59x 64
Rdistcom.dll2005.90.2224.0836,464?? ?????? ????00: 59x 64
Repldp.dll2005.90.2224.0237,936?? ?????? ????00: 34x 64
Replmerg.exe2005.90.2224.0417,648?? ?????? ????00: 59x 64
Replprov.dll2005.90.2224.0747,888?? ?????? ????00: 59x 64
Replrec.dll2005.90.2224.01,011,056?? ?????? ????00: 59x 64
Replsub.dll2005.90.2224.0528,240?? ?????? ????00: 59x 64
Spresolv.dll2005.90.2224.0225,648?? ?????? ????00: 59x 64
Sqlaccess.dll2005.90.2224.0357,744?? ?????? ????00: 59x 86
Sqlagent90.exe2005.90.2224.0392,560?? ?????? ????00: 59x 64
Sqlservr.exe2005.90.2224.039,363,440?? ?????? ????00: 59x 64
Xmlsub.dll2005.90.2224.0319,856?? ?????? ????00: 59x 64
Xpstar90.dll2005.90.2224.0543,600?? ?????? ????00: 59x 64
Xpstar90.rll2005.90.2224.0156,016?? ?????? ????00: 59??? ???? ???????
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2224.0157,552?? ?????? ????12: 29IA-64
Databasemailengine.dll9.0.2224.075,120?? ?????? ????12: 29x 86
Logread.exe2005.90.2224.01,098,096?? ?????? ????12: 29IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2224.0546,160?? ?????? ????00: 34x 86
Microsoft.analysisservices.deployengine.dll9.0.2224.0140,656?? ?????? ????00: 34x 86
Microsoft.analysisservices.dll9.0.2224.01,217,904?? ?????? ????00: 34x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2224.0165,744?? ?????? ????12: 29IA-64
Microsoft.sqlserver.sqlenum.dll9.0.2224.0877,936?? ?????? ????12: 29x 86
Msasxpress.dll9.0.2224.057,712?? ?????? ????12: 29IA-64
Msgprox.dll2005.90.2224.0545,136?? ?????? ????12: 29IA-64
Msmdlocal.dll9.0.2224.048,718,704?? ?????? ????12: 29IA-64
Msmdredir.dll9.0.2224.06,249,328?? ?????? ????12: 29??? ???? ???????
Qrdrsvc.exe2005.90.2224.0943,984?? ?????? ????12: 29IA-64
Rdistcom.dll2005.90.2224.01,884,016?? ?????? ????12: 29IA-64
Repldp.dll2005.90.2224.0511,344?? ?????? ????12: 29IA-64
Replmerg.exe2005.90.2224.0957,296?? ?????? ????12: 29IA-64
Replprov.dll2005.90.2224.01,619,824?? ?????? ????12: 29IA-64
Replrec.dll2005.90.2224.02,144,112?? ?????? ????12: 29IA-64
Replsub.dll2005.90.2224.01,159,536?? ?????? ????12: 29IA-64
Spresolv.dll2005.90.2224.0498,032?? ?????? ????12: 29IA-64
Sqlaccess.dll2005.90.2224.0352,112?? ?????? ????12: 29x 86
Sqlagent90.exe2005.90.2224.01,143,664?? ?????? ????12: 29IA-64
Sqlservr.exe2005.90.2224.072,269,168?? ?????? ????12: 29IA-64
Xmlsub.dll2005.90.2224.0593,264?? ?????? ????00: 34IA-64
X pstar90.dll2005.90.2224.0953,712?? ?????? ????00: 34IA-64
Xpstar90.rll2005.90.2224.0154,992?? ?????? ????12: 29??? ???? ???????
????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.

???? ??????

??????? ?????? ??? ??? ??????? ?????? ????????? ?????? ?????? ??? ?????? ?? ?????? ??????: session_id
SELECT session_id, text
FROM sys.dm_exec_requests AS r
     CROSS APPLY
     sys.dm_exec_sql_text(sql_handle) AS s
WHERE session_id = <session_id>
??????<session_id> ???? ????? ???? ????? ???????? ??? ???????.

?????

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

?????

?????? ??? ???? ?? ????????? ??? ???? ???????? INPUTBUFFER DBCC ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms187730.aspx
?????? ??? ???? ?? ????????? ??? ????? ??? ????? ???? sys.dm_exec_requests ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms177648.aspx
?????? ??? ???? ?? ????????? ??? ????? ??? ????? ???? sys.dm_exec_sql_text ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms181929.aspx
????? ?? ????????? ??? ???? ??????? ???????? Microsoft SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 932990 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.5
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbautohotfix kbhotfixserver kbfix kbexpertiseadvanced kbqfe kbpubtypekc KB932990 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????932990

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

 

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