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

?????? ????????? ?????? ?????????
???? ???????: 928539 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50000452 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

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

???????

??? ????? ??????? ???? ?????? ?? ????? ??? ?? SQL Server 2005? ?? ???? ????????? ???? ?????. ???????? ??? ???? ??? ????? ???? ?????? ???? ?????? ??? ??? ?? ??? Errorlog ???? SQL:
23 ????? ???? 13:34:10.48 spid438 *** "????? ??????" ??? ??????? ??? H:\MSSQL\LOG\SQLDump0016.txt
23 ????? ???? 13:34:10.48 SqlDumpExceptionHandler spid438: 438 ????? ????? ??????? ???? EXCEPTION_ACCESS_VIOLATION c0000005. ??? ???? ????? SQL Server ??? ???????.
2006-08-23 13:34:10.48 spid438 * *******************************************************************************
23 ????? ???? 13:34:10.48 spid438 *
23 ????? ???? 13:34:10.48 spid438 * BEGIN ????? ??????:
23 ????? ???? 13:34:10.48 spid438 * 23 ????? ????? 13:34:10 spid 438
23 ????? ???? 13:34:10.48 spid438 *
23 ????? ???? 13:34:10.48 spid438 *
23 ????? ???? 13:34:10.48 spid438 * ????? ????????? = Module(sqlservr+00000000024CE1D0) 00000000034CE1D0
23 ????? ???? 13:34:10.48 spid438 * ??? ????????? = EXCEPTION_ACCESS_VIOLATION c0000005
23 ????? ???? 13:34:10.48 spid438 * ??? "?????? ????" ??????? ????? 0000000000000010
???? ??? ??????? ??? ????? ???????? ?????????:
  • ?????? "?????????" ?? ????? ???.
  • ???? ????????? ??? ????????.
  • ????? ?????? ??? ????? ?????? FOR ?????????.
  • ??? recompiled ????????? ??? ????? ?????????.

????

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

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

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

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

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

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2206.0398,112?? ?????? ????11: 16x 86
Microsoft.analysisservices.adomdclient.dll9.0.2206.0543,520?? ?????? ????11: 16x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2206.0138,016?? ?????? ????11: 16x 86
Microsoft.analysisservices.dll9.0.2206.01,215,264?? ?????? ????11: 16x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2206.075,552?? ?????? ????11: 16x 86
Microsoft.sqlserver.sqlenum.dll9.0.2206.0908,064?? ?????? ????11: 16x 86
Msasxpress.dll9.0.2206.022,304?? ?????? ????11: 16x 86
Msgprox.dll2005.90.2206.0197,920?? ?????? ????11: 16x 86
Msmdlocal.dll9.0.2206.015,614,752?? ?????? ????11: 16x 86
Msmdredir.dll9.0.2206.03,990,304?? ?????? ????11: 16x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????13: 58??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????13: 58??? ???? ???????
Replprov.dll2005.90.2206.0547,616?? ?????? ????11: 16x 86
Replrec.dll2005.90.2206.0782,112?? ?????? ????11: 16x 86
Sqlaccess.dll2005.90.2206.0347,936?? ?????? ????11: 16x 86
Sqlagent90.exe2005.90.2206.0318,752?? ?????? ????11: 16x 86
Sqlservr.exe2005.90.2206.028,964,696?? ?????? ????11: 16x 86
Sysdbupg.sql??? ???? ???????192,346?? ????? ????14: 01??? ???? ???????
Xmlsub.dll2005.90.2206.0192,800?? ?????? ????11: 10x 86
Xpstar90.dll2005.90.2206.0292,640?? ?????? ????11: 10x 86
Xpstar90.rll2005.90.2206.0152,864?? ?????? ????11: 16x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2206.0522,528?? ?????? ????02: 02x 64
Microsoft.analysisservices.adomdclient.dll9.0.2206.0543,520?? ?????? ????11: 16x 86
Microsoft.analysisservices.adomdclient.dll9.0.2206.0543,520?? ?????? ????02: 02x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2206.0138,016?? ?????? ????11: 16x 86
Microsoft.analysisservices.dll9.0.2206.01,215,264?? ?????? ????11: 16x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2206.075,552?? ?????? ????11: 16x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2206.091,424?? ?????? ????02: 02x 64
Microsoft.sqlserver.sqlenum.dll9.0.2206.0875,296?? ?????? ????02: 02x 86
Msasxpress.dll9.0.2206.022,304?? ?????? ????11: 16x 86
Msasxpress.dll9.0.2206.027,424?? ?????? ????02: 02x 64
Msgprox.dll2005.90.2206.0259,360?? ?????? ????02: 02x 64
Msmdlocal.dll9.0.2206.015,614,752?? ?????? ????11: 16x 86
Msmdredir.dll9.0.2206.03,990,304?? ?????? ????11: 16x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????13: 58??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????13: 58??? ???? ???????
Replprov.dll2005.90.2206.0745,248?? ?????? ????02: 02x 64
Replrec.dll2005.90.2206.01,008,416?? ?????? ????02: 02x 64
Sqlaccess.dll2005.90.2206.0355,104?? ?????? ????02: 02x 86
Sqlagent90.exe2005.90.2206.0389,920?? ?????? ????02: 02x 64
Sqlservr.exe2005.90.2206.039,371,040?? ?????? ????02: 02x 64
Sysdbupg.sql??? ???? ???????192,346?? ????? ????14: 01??? ???? ???????
Xmlsub.dll2005.90.2206.0317,216?? ?????? ????02: 02x 64
Xpstar90.dll2005.90.2206.0540,960?? ?????? ????02: 02x 64
Xpstar90.rll2005.90.2206.0153,376?? ?????? ????02: 02x 64
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2206.01,095,456?? ?????? ????20: 14IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2206.0543,520?? ?????? ????20: 14x 86
Microsoft.analysisservices.adomdclient.dll9.0.2206.0543,520?? ?????? ????11: 16x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2206.0138,016?? ?????? ????11: 16x 86
Microsoft.analysisservices.dll9.0.2206.01,215,264?? ?????? ????11: 16x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2206.0163,104?? ?????? ????20: 14IA-64
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2206.075,552?? ?????? ????11: 16x 86
Microsoft.sqlserver.sqlenum.dll9.0.2206.0875,296?? ?????? ????20: 14x 86
Msasxpress.dll9.0.2206.055,072?? ?????? ????20: 14IA-64
Msasxpress.dll9.0.2206.022,304?? ?????? ????11: 16x 86
Msgprox.dll2005.90.2206.0542,496?? ?????? ????20: 14IA-64
Msmdlocal.dll9.0.2206.048,610,080?? ?????? ????20: 14IA-64
Msmdredir.dll9.0.2206.06,244,128?? ?????? ????20: 14IA-64
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????13: 58??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????13: 58??? ???? ???????
Replprov.dll2005.90.2206.01,617,184?? ?????? ????20: 14IA-64
Replrec.dll2005.90.2206.02,141,472?? ?????? ????20: 14IA-64
Sqlaccess.dll2005.90.2206.0349,472?? ?????? ????20: 14x 86
Sqlagent90.exe2005.90.2206.01,141,024?? ?????? ????20: 14IA-64
Sqlservr.exe2005.90.2206.072,259,872?? ?????? ????20: 14IA-64
Sysdbupg.sql??? ???? ???????192,346?? ????? ????14: 01??? ???? ???????
Xmlsub.dll2005.90.2206.0590,624?? ?????? ????20: 14IA-64
Xpstar90.dll2005.90.2206.0951,072?? ?????? ????20: 14IA-64
Xpstar90.rll2005.90.2206.0152,352?? ?????? ????20: 14IA-64

???? ??????

??????? ?????? ??? ??? ??????? ???? ???? recompilation ?????????. ?????? ??? recompilation ?????? ??????? ??????? ?? ????? "????? ??????? ?? Microsoft" 308737. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
308737????? ?????? ??? ????? recompilation ?? ??? SP:Recompile

?????

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

??????? ????

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

  1. ???? Studio ????? ???? SQL.
  2. ??????? ????? SQL Server 2005.
  3. Create a new query, and then run the following statements.
    use tempdb
    go
    
    create table mytab1 (col1 nvarchar(50), col2 nvarchar(100), col3 int)
    go
    
    create table mytab2 (a int)
    go
    
    insert into mytab1 values ('col1 value', 'col2 value', 1)
    go
    
    insert into mytab2 values (1)
    go
    
    set quoted_identifier off;
    go
    
    sp_create_plan_guide 
    N'myplanguide',
    N'select * from mytab1 join mytab2 on col3 = a where col1 = @p1', 
    N'SQL',
    NULL,
    N'@p1 nvarchar(30)',
    N'OPTION (FAST 40, OPTIMIZE FOR (@p1 = N''col2''))'
    go
    
    select * from sys.plan_guides
    go
    
    sp_executesql N'select * from mytab1 join mytab2 on col3 = a where col1 = @p1', N'@p1 nvarchar(30)', N'col2'
    go
    
    drop table mytab1
    go
    
    create table mytab1 (col1 nvarchar(50), col2 nvarchar(100), col3 int)
    go
    
    sp_executesql N'select * from mytab1 join mytab2 on col3 = a where col1 = @p1', N'@p1 nvarchar(30)', N'col2'
    go
    
    sp_control_plan_guide N'drop all'
    go
    

?????

????? ?? ????????? ??? ????? ?????? FOR ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms181714.aspx
????? ?? ????????? ??? ???? ??????? ???????? Microsoft SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 928539 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.4
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise 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 kbexpertiseadvanced kbtshoot kbfix kbsql2005engine kbhotfixserver kbqfe kbpubtypekc KB928539 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????928539

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

 

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