FIX: ????? ??? ??? ????? ??? ???? ????? ?? ??? ???????? ?? SQL Server 2005: "????? ????? ??? ??? ???? ?????? SUBSTRING" ?? "??? ??? ??? ?? ????? ????? ??? ???? ??????? ?? ??????"

???? ???????: 924291 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
1209 bug #: (Hotfix SQL)
443526 bug #: (SQLBUDT)
??????
???? Microsoft ??????? Microsoft SQL Server 2005 ???? ??????? ????. ??? ???????? ??????? ? ????? ?? ??????? ?????? ??? ???? ????????? ???????? ???????? ???? ??????? ?????? ?? ?????? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??? ??? ??????? ??????? ??? ??? ??????? ???????:
  • ??????? ???? ??? ????? ?????? ???? ????????? ??????? ???
  • ??????? ?????? ???? ????????? ???????
  • ??????? ??? ?? ??? ??? ??? ????? ????? ????????? ??? ????? ?????? ????????? ???????
  • ??????? ??? ?? ??? ??? ???? ????????? ??????? ??? ???????? ??? ???? ????????? ??????? ????
  • information about whether you must make any changes registry
  • files the that are contained in the package hotfix
???? ??? ?????? | ????? ???????

???????

??? ????? ??? ???? ????? ?? ??? ???????? ?? SQL Server 2005, ????? ????? ???. ???? ??? ??????? ??? ??? ?????? ??????? ??????? ??? ????? ?? ?????? ???????? ?? ????? ????????: 
SET FMTONLY ON
????? ???? ????? ??? ??????, ???????? ??? ????? SQL Server 2005 ???? ??? ????????. ??? ??? ?????? SQL Server 2005 Service Pack 1 (SP1) ? ?? ?????? ????? ???? ?????.

??????? ??????? ?????? ?? SQL Server 2005

when you execute the function defined-user in the version original of SQL Server 2005, you receive message error the following.
msg 536, ????? 16, ???? 5? ??? 4
passed parameter length invalid to the function SUBSTRING.

SQL Server 2005 SP1

??? ????? ?? ?????? ???????? ?? ????? ???????? ?? SQL Server 2005 SP1 ? ??? ????? ??????? ???????:
  • ????? ????? ??????? ?????? ???????:
    msg 109, ????? 20, ???? 0? ?? 0
    ??? ??? ?? ????? ????? ????? ???? ??????? ?? ??????. (??????: ???????? " ???? ??????? " ? ?????: 0 - ????? ??????? ?? ?????.)
  • stops the service SQL Server.
  • ??? ????? ?????? ?????? ??????? ?? ????? Errorlog ???? SQL:
    SqlDumpExceptionHandler: ????? 53 ????? ??????? ???? EXCEPTION_ACCESS_VIOLATION c0000005. ?? ????? SQL Server ??? ???????.
???? ??? ?????? | ????? ???????

????

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

??? ??? ???????? ?????? ??? ???? ???? ???? ?? SQL Server 2005. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
913089
(http://support.microsoft.com/kb/913089/ )
????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

??????? Hotfix

????? ??????? ?????? ?? Microsoft. ????? ??? ??????? ??????? ?????? ??????? ???????? ?? ??? ??????? ???. ??? ????? ??? ??????? ??? ??? ??????? ???? ?????? ??? ??????? ?????. ?? ????? ??? ??????? ?????? ??????. ????? ??? ??? ?? severely ????? ??? ???????, ???? ?? ??????? ??????? ??????? ??????? ????? ??? ???????.

??? ??? ??????? ????? ???????, ???? ???? 'Hotfix ????? ?????? ?? ???? ????? ????? ????? ???. ??? ?? ???? ??? ?????? ???? ???? ??????? Microsoft ?????? ?????? ??? ???????.

?????? ?? ???? ???? ????? ?????? ?? ?? ??????? ????? ???? ????????, ??? ???? ?????? ??? ???? ??????. ???? ????? ?????? ????? ??????? ??? ??????? ??? ????? ???????? ???? ?? ????? ?? ??? ??? ??????? ?????. ?????? ???? ????? ????? ????? ??????? ?????Microsoft ?????? ?? ?????? ??? ???? ?????? ?? ?????? ???? Microsoft ??? ??? ??????:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
?????? ???? ??????? 'Hotfix ??????? ???????? ?????? ????? ???? ???????. ??? ?? ????? ????? ?????? ??, ??? ??? ??????? ??? ????? ?? ??? ??? ?????.

???????

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

????? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 Service Pack 1, ???? ??? ??? ?????? ?????? ???? ??????? ?? ????? ????? Microsoft:
913089
(http://support.microsoft.com/kb/913089/ )
????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

??????? ????? Hotfix

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

????? ????? ?????????? ?? ??? ??????? ????? ??? ???? ????? (?? ???? ????? ??????) ???????? ?? ?????? ??????. ???????? ???????? ?????? ??? ?????? ?? " ??? ??????? ??????? " (UTC). ??? ??? ??????? ?????, ???? ????? ??? ????? ??????. ????? ????? ??? UTC ?????? ?????? ?????? ????? ??????? ??????? ??????? ?? ?????? ??????? ?????? ?? " ???? ?????? ".
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Hauresourcedb.ldf?? Applicable524,28817-Aug-200610:39?? Applicable
Hauresourcedb.mdf?? Applicable39,911,42417-Aug-200610:39?? Applicable
Logread.exe2005.90.2183.0398,11217-Aug-200614:13x 86
Microsoft.analysisservices.adomdclient.dll9.0.2183.0543,52017-Aug-200614:13x 86
Microsoft.analysisservices.deployengine.dll9.0.2183.0138,01617-Aug-200614:12x 86
Microsoft.analysisservices.dll9.0.2183.01,215,26417-Aug-200614:13x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2183.075,55217-Aug-200614:11x 86
Microsoft.sqlserver.sqlenum.dll9.0.2183.0908,06417-Aug-200614:13x 86
Msgprox.dll2005.90.2183.0197,92017-Aug-200614:11x 86
Msmdlocal.dll9.0.2183.015,703,84017-Aug-200614:13x 86
Msmdredir.dll9.0.2183.03,968,80017-Aug-200614:14x 86
Replprov.dll2005.90.2183.0547,61617-Aug-200614:13x 86
Replrec.dll2005.90.2183.0782,11217-Aug-200614:12x 86
Sqlaccess.dll2005.90.2183.0347,93617-Aug-200614:13x 86
Sqlagent90.exe2005.90.2183.0319,26417-Aug-200614:12x 86
Sqlservr.exe2005.90.2183.028,959,06417-Aug-200614:13x 86
Sysdbupg.sql?? Applicable192,34619-Jul-200609:02?? Applicable
Template_hauresourcedb.ldf?? Applicable524,28817-Aug-200610:39?? Applicable
Template_hauresourcedb.mdf?? Applicable39,911,42417-Aug-200610:39?? Applicable
Xpstar90.dll2005.90.2183.0292,64017-Aug-200614:16x 86
Xpstar90.rll2005.90.2183.0152,86417-Aug-200614:12?? Applicable
???? ??? ?????? | ????? ???????

???? ??????

??? ??? ???????, ????? ??????? SET FMTONLY ??? OFF ??? ????? ?? ?????? ???????? ?? ????? ????????.
???? ??? ?????? | ????? ???????

?????

????? Microsoft ????? ?? ??? ?? ????? ?? ???????? Microsoft ???????? ?? ?????? "????? ???". ?? ????? ??? ??????? ?? SQL Server 2005 Service Pack 2 ?????.
???? ??? ?????? | ????? ???????

??????? ????

????? ?? ????????? ??? ?????? ??????? ??????? Microsoft SQL Server, ???? ??? ??? ?????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499
(http://support.microsoft.com/kb/822499/ )
???? ????? ?????? ??? ??????? ?????? Microsoft SQL Server
????? ?? ????????? ??? ????????? ????? ???????, ???? ??? ??? ?????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684
(http://support.microsoft.com/kb/824684/ )
??? ????????? ???????? ???? ?????? ???? ??????? ????? Microsoft
???? ??? ?????? | ????? ???????

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

You receive the following stack dump information in SQL Server 2005 SP1:
2006-08-16 19:30:37.61 spid54      * Short Stack Dump
2006-08-16 19:30:37.62 spid54      014718DE Module(sqlservr+004718DE)
2006-08-16 19:30:37.62 spid54      0108B032 Module(sqlservr+0008B032)
2006-08-16 19:30:37.62 spid54      0108B066 Module(sqlservr+0008B066)
2006-08-16 19:30:37.62 spid54      014680F2 Module(sqlservr+004680F2)
2006-08-16 19:30:37.62 spid54      01BDF9D2 Module(sqlservr+00BDF9D2)
2006-08-16 19:30:37.62 spid54      014688D5 Module(sqlservr+004688D5)
2006-08-16 19:30:37.62 spid54      01023E34 Module(sqlservr+00023E34)
2006-08-16 19:30:37.62 spid54      0136764A Module(sqlservr+0036764A)
2006-08-16 19:30:37.62 spid54      013674C1 Module(sqlservr+003674C1)
2006-08-16 19:30:37.62 spid54      01367356 Module(sqlservr+00367356)
2006-08-16 19:30:37.62 spid54      01BF2102 Module(sqlservr+00BF2102)
2006-08-16 19:30:37.62 spid54      01381DA5 Module(sqlservr+00381DA5)
2006-08-16 19:30:37.62 spid54      01023E34 Module(sqlservr+00023E34)
2006-08-16 19:30:37.62 spid54      01041DD5 Module(sqlservr+00041DD5)
2006-08-16 19:30:37.62 spid54      0103DFD4 Module(sqlservr+0003DFD4)
2006-08-16 19:30:37.62 spid54      01006A96 Module(sqlservr+00006A96)
2006-08-16 19:30:37.62 spid54      01006BBC Module(sqlservr+00006BBC)
2006-08-16 19:30:37.62 spid54      01006DAB Module(sqlservr+00006DAB)
2006-08-16 19:30:37.62 spid54      01447562 Module(sqlservr+00447562)
2006-08-16 19:30:37.62 spid54      0144859B Module(sqlservr+0044859B)
2006-08-16 19:30:37.62 spid54      0144789A Module(sqlservr+0044789A)
2006-08-16 19:30:37.64 spid54      01447720 Module(sqlservr+00447720)
2006-08-16 19:30:37.64 spid54      781329AA Module(MSVCR80+000029AA)
2006-08-16 19:30:37.65 spid54      78132A36 Module(MSVCR80+00002A36)

sqlservr!CMsqlXactImp::ClearAllUpdateSequenceMarkers+0x3b (CONV: thiscall)
sqlservr!CMsqlXactImp::RollbackInternal+0x3a (CONV: thiscall)
sqlservr!CMsqlXactImp::Rollback+0x31 (CONV: thiscall)
sqlservr!CAutoMsqlXact::RollbackNestedXact+0x1b (FPO: [0,0,0]) (CONV: thiscall)
sqlservr!CExecuteStatement::RollbackNestedXact+0x14 (FPO: [1,0,0]) (CONV: thiscall)
sqlservr!CExecuteStatement::FinishNormalImp+0x8c (CONV: thiscall)
sqlservr!CExecuteStatement::FinishOnExceptionImp+0x13 (CONV: thiscall)
sqlservr!CMsqlExecContext::FExecute+0x65c (CONV: thiscall)
sqlservr!CSQLSource::Execute+0x73b (CONV: thiscall)
sqlservr!process_request+0x2e3 (CONV: stdcall)
sqlservr!process_commands+0x2e0 (CONV: stdcall)
sqlservr!SOS_Task::Param::Execute+0xe2 (CONV: thiscall)
sqlservr!SOS_Scheduler::RunTask+0xb9 (CONV: thiscall)
sqlservr!SOS_Scheduler::ProcessTasks+0x141 (CONV: stdcall)
sqlservr!SchedulerManager::WorkerEntryPoint+0x1a8 (CONV: stdcall)
sqlservr!SystemThread::RunWorker+0x7f (CONV: thiscall)
sqlservr!SystemThreadDispatcher::ProcessWorker+0x225 (CONV: thiscall)
sqlservr!SchedulerManager::ThreadEntryPoint+0x143 (CONV: stdcall)
msvcr80!_callthreadstartex+0x1b (FPO: [Non-Fpo]) (CONV: cdecl)
msvcr80!_threadstartex+0x66 (FPO: [Non-Fpo]) (CONV: stdcall)
???? ??? ?????? | ????? ???????

???????

???? ???????: 924291 - ????? ??? ??????: 23/????/1428 - ??????: 1.4
????? ???
  • 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 Service Pack 1
????? ??????: 
kbmt kbautohotfix kbsql2005sp2fix kbhotfixserver kbfix kbexpertiseadvanced kbqfe kbpubtypekc KB924291 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????. ??? ?? ???? ??? ??????? ????? ?? ???????? ?? ??? ???????? ?????? ????? ????????? ??????? ???? ??? ???????
???? ??? ????? ??????? ?????? ??????????924291
(http://support.microsoft.com/kb/924291/en-us/ )
???? ??? ?????? | ????? ???????

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

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