Select the product you need help with
FIX: ¼ö ÀÖ´Â 17883 ¶§ ¿À·ù ¸Þ½ÃÁö°¡ SQL Server 2000 ¼ºñ½º ÆÑ 3 ¶Ç´Â SQL Server 2000 ¼ºñ½º ÆÑ 3a ÀÛ¾÷ÀÚ ½º·¹µå°¡ ·¹Áö½ºÆ®¸® È£Ãâ¿¡¼ À߸øµÈ µË´Ï´Ù.±â¼ú ÀÚ·á: 888444 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. # ¹ö±×: 472962 (SQL Server 8.0) # ¹ö±×: 472963 (SQL Server 8.0) ÀÌ ÆäÀÌÁö¿¡¼¹®¼ ³»¿ë¿ä¾àÀÌ ¹®¼¿¡¼´Â ÀÌ ÇÖÇȽº ¸±¸®½º¿¡ ´ëÇÑ ´ÙÀ½À» ¼³¸íÇÕ´Ï´Ù.
Çö»óMicrosoft SQL Server 2000 ¼ºñ½º ÆÑ 3 (SP3) ¶Ç´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 17883 ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö 3a (SP3a) ¶§ ÀÛ¾÷ÀÚ ½º·¹µå°¡ ·¹Áö½ºÆ®¸® È£Ãâ¿¡¼ À߸øµÈ µË´Ï´Ù. ¿À·ù°¡ ¹ß»ýÇϸé SQL Server ¿¬°áµÈ ´ýÇÁ°¡ »ý¼ºÇÕ´Ï´Ù. ´ÙÀ½ ´ýÇÁ°¡ °ËÅäÇÒ ¶§ ´ÙÀ½°ú ºñ½ÁÇÑ ½ºÅÃÀÌ Ç¥½ÃµË´Ï´Ù. NTDLL!NtOpenKey+0xb ADVAPI32!LocalBaseRegOpenKey ADVAPI32!RegOpenKeyExW sqlservr!CServerHeartbeat::UpdateUptimeRegKey sqlservr!CServerHeartbeat::OnHeartbeat ÀÌÀü ÇÖÇȽº ¸ñ·Ï¿¡ ´ÙÀ½ Microsoft ±â¼ú ÀÚ·á ¹®¼ "Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 3 ¶Ç´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 3a ÇÖÇȽº¸¦" ¼½¼ÇÀ» ÂüÁ¶ÇϽʽÿÀ. 290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ¿øÀÎÀÌ ¹®Á¦´Â Àüü ½Ã½ºÅÛÀÇ ½ÇÁ¦ I/O ºÎ´ãÀ» »ý¼ºÇÒ ±â°£ ó¸®ÇÏ´Â µ¿¾È Å« ¼³Ä¡¿¡¼ ÀÚÁÖ ¹ß»ýÇÕ´Ï´Ù. SQL Server 2000 SP3À» Å° ÀÛ¾÷ÀÚ ½º·¹µå Áß Çϳª´Â ÇÏÆ®ºñÆ® ÀÛ¾÷ÀÔ´Ï´Ù. SQL Server 2000 SP3À» ÇÏÆ®ºñÆ® ÀÛ¾÷ÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù. ÇÏÆ®ºñÆ® ÀÛ¾÷ 60Ãʸ¶´Ù ·¹Áö½ºÆ®¸®¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù. ÇÏÆ®ºñÆ® ÀÛ¾÷ ·¹Áö½ºÆ®¸® È£Ãâ¿¡¼ wedged µÉ ¼ö ÀÖ½À´Ï´Ù. ÀÖ´Â °æ¿ì ÇØ´ç ÀÛ¾÷ÀÌ ÇÒ´çµÈ UMS ½ºÄÉÁÙ·¯´Â ¶ÇÇÑ µË´Ï´Ù wedged. UMS ½ºÄÉÁÙ·¯¸¦ wedged ¶§ ´õ ÀÌ»ó Äõ¸® ¶Ç´Â ¿¬°áÀ» ó¸®ÇÒ ¼ö ½ºÄÉÁÙ·¯´Â µû¶ó SQL Server·Î Á¦¾î¸¦ ¹ÝȯÇÕ´Ï´Ù ÀÛ¾÷ÀÚ ·¹Áö½ºÆ®¸® È£ÃâÀÌ ¿Ï·áµÉ ¶§±îÁö. ÇØ°á ¹æ¹ý¼ºñ½º ÆÑ Á¤º¸ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼ È®ÀÎÇϽʽÿÀ:290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ÇÖÇȽº Á¤º¸ÀüÁ¦ Á¶°Ç
ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 ÇÖÇȽº 2000.80.977 ºôµå, Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¹®¼¸¦ º¸·Á¸é ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿©: 888007
(http://support.microsoft.com/kb/888007/
)
SQL Server 2000 ¼ºñ½º ÆÑ 3 ÀÌÈÄ ÇÖÇȽº¸¦ ¼³Ä¡ÇÏ·Á´Â "ÀÌ Á¦Ç°ÀÌ ¾ø´Â Çʼö ¾÷µ¥ÀÌÆ®°¡ ¼³Ä¡µÈ" ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³´Ù 842960
(http://support.microsoft.com/kb/842960/
)
32 ºñÆ® SQL Server 7.0 ¹× SQL Server 2000 ÇÖÇȽº ¼³Ä¡ ¼³¸í 884856
(http://support.microsoft.com/kb/884856/
)
FIX: SQL Server 2000¿¡¼ ÀÚµ¿ ¾÷µ¥ÀÌÆ®¸¦ Äõ¸®¸¦ ¼öÇàÇÑ °æ¿ì Ŭ·¯½ºÅ͵ÇÁö ¾ÊÀº À妽º°¡ ¼Õ»óµÇ¾ú½À´Ï´Ù. ´Ù½Ã ½ÃÀÛ Á¤º¸ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ¿¡´Â ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.ÇÖÇȽº ÆÄÀÏ Á¤º¸ÀÌ ÇÖÇȽº¿¡´Â ÀÌ ¹®¼¿¡ ³ª¿Í ÀÖ´Â ¹®Á¦¸¦ ÇØ°áÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀϸ¸ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ ÇÖÇȽº¸¦ Á¦Ç°À» ÃֽŠºôµå·Î ¿ÏÀüÈ÷ ¾÷µ¥ÀÌÆ®ÇÏ´Â µ¥ ÇÊ¿äÇÑ ¸ðµç ÆÄÀÏÀÌ Æ÷ÇÔµÇÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù.ÀÌ ÇÖÇȽºÀÇ Çѱ¹¾î ¹öÀüÀº ÆÄÀÏ Æ¯¼ºÀ» °¡Áý´Ï´Ù (ÀÌ»ó) ´ÙÀ½ Ç¥¿¡ ³ª¿Í ÀÖ´Â. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ãÀ¸·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. SQL Server 2000 SP3 ¶Ç´Â SQL Server 2000 SP3a¸¦ 32ºñÆ® ¹öÀüDate Time Version Size File name Platform ------------------------------------------------------------------------------ 01-Dec-2004 16:57 2000.80.993.0 664,128 Autoplt.dll x86 01-Dec-2004 16:57 2000.80.993.0 78,400 Console.exe x86 01-Dec-2004 16:57 2000.80.993.0 332,352 Ctasksui.dll x86 01-Dec-2004 16:57 2000.80.993.0 315,968 Custtask.dll x86 01-Dec-2004 16:57 2000.80.993.0 33,340 Dbmslpcn.dll x86 08-Apr-2004 18:42 786,432 Distmdl.ldf x86 08-Apr-2004 18:42 2,359,296 Distmdl.mdf x86 30-Sep-2003 19:55 180 Drop_repl_hotfix.sql x86 01-Dec-2004 16:57 2000.80.993.0 1,905,216 Dtspkg.dll x86 01-Dec-2004 16:57 2000.80.993.0 528,960 Dtspump.dll x86 01-Dec-2004 16:57 2000.80.993.0 1,557,052 Dtsui.dll x86 01-Dec-2004 16:57 2000.80.993.0 639,552 Dtswiz.dll x86 30-Sep-2003 19:55 747,927 Instdist.sql x86 30-Sep-2003 19:55 1,581 Inst_repl_hotfix.sql x86 01-Dec-2004 16:57 2000.80.993.0 352,828 Isqlw.exe x86 01-Dec-2004 16:57 2000.80.993.0 82,492 Itwiz.exe x86 01-Dec-2004 16:57 2000.80.993.0 90,692 Msgprox.dll x86 29-Oct-2004 05:16 8.11.41022.0 226,304 Mssdi98.dll x86 01-Dec-2004 16:57 2000.80.993.0 62,024 Odsole70.dll x86 01-Dec-2004 16:58 2000.80.993.0 25,144 Opends60.dll x86 01-Dec-2004 16:57 2000.80.993.0 57,904 Osql.exe x86 01-Dec-2004 16:57 2000.80.993.0 279,104 Pfutil80.dll x86 30-Sep-2003 19:48 550,780 Procsyst.sql x86 08-Apr-2004 18:42 12,305 Qfe469315.sql x86 08-Apr-2004 18:42 19,195 Qfe469571.sql x86 26-Aug-2004 21:14 5,157 Qfe472197.sql x86 01-Dec-2004 16:57 2000.80.993.0 143,940 Qrdrsvc.exe x86 01-Dec-2004 15:49 1,106,776 Replmerg.sql x86 01-Dec-2004 16:57 2000.80.993.0 221,768 Replprov.dll x86 01-Dec-2004 16:57 2000.80.993.0 307,784 Replrec.dll x86 01-Dec-2004 15:56 2000.80.993.0 159,813 Replres.rll x86 26-Aug-2004 21:14 1,086,925 Replsys.sql x86 30-Sep-2003 19:55 986,603 Repltran.sql x86 24-Nov-2004 21:04 55 Repl_uninstall.sql x86 01-Dec-2004 16:57 2000.80.993.0 287,304 Rinitcom.dll x86 01-Dec-2004 16:57 2000.80.993.0 78,416 Sdiclnt.dll x86 01-Dec-2004 16:57 2000.80.993.0 66,112 Semmap.dll x86 01-Dec-2004 16:57 2000.80.993.0 57,916 Semnt.dll x86 01-Dec-2004 16:57 2000.80.993.0 492,096 Semobj.dll x86 01-Dec-2004 16:20 2000.80.993.0 172,032 Semobj.rll x86 01-Dec-2004 16:57 2000.80.993.0 53,832 Snapshot.exe x86 30-Sep-2003 19:48 117,834 Sp3_serv_uni.sql x86 01-Dec-2004 16:57 2000.80.993.0 28,672 Sqlagent.dll x86 01-Dec-2004 16:57 2000.80.993.0 311,872 Sqlagent.exe x86 01-Dec-2004 16:57 2000.80.993.0 168,001 Sqlakw32.dll x86 01-Dec-2004 16:57 2000.80.993.0 33,344 Sqlctr80.dll x86 01-Dec-2004 16:58 2000.80.993.0 4,215,360 Sqldmo.dll x86 01-Dec-2004 16:57 25,172 Sqldumper.exe x86 01-Dec-2004 15:48 2000.80.993.0 28,672 Sqlevn70.rll x86 01-Dec-2004 16:57 2000.80.993.0 156,224 Sqlmaint.exe x86 01-Dec-2004 16:58 2000.80.993.0 180,792 Sqlmap70.dll x86 01-Dec-2004 16:58 2000.80.993.0 188,992 Sqlmmc.dll x86 01-Dec-2004 16:12 2000.80.993.0 479,232 Sqlmmc.rll x86 01-Dec-2004 16:58 2000.80.993.0 401,984 Sqlqry.dll x86 01-Dec-2004 16:58 2000.80.993.0 57,920 Sqlrepss.dll x86 01-Dec-2004 16:58 2000.80.993.0 7,716,945 Sqlservr.exe x86 01-Dec-2004 16:58 2000.80.993.0 590,396 Sqlsort.dll x86 01-Dec-2004 16:58 2000.80.993.0 45,644 Sqlvdi.dll x86 01-Dec-2004 16:58 2000.80.993.0 106,588 Sqsrvres.dll x86 01-Dec-2004 16:58 2000.80.993.0 33,340 Ssmsgnet.dll x86 01-Dec-2004 16:58 2000.80.993.0 33,340 Ssmslpcn.dll x86 01-Dec-2004 16:58 2000.80.993.0 33,340 Ssmsqlgc.dll x86 01-Dec-2004 16:58 2000.80.993.0 82,492 Ssnetlib.dll x86 01-Dec-2004 16:58 2000.80.993.0 25,148 Ssnmpn70.dll x86 01-Dec-2004 16:58 2000.80.993.0 123,456 Stardds.dll x86 01-Dec-2004 16:58 2000.80.993.0 158,240 Svrnetcn.dll x86 01-Dec-2004 16:57 2000.80.993.0 76,416 Svrnetcn.exe x86 01-Dec-2004 16:58 2000.80.993.0 49,228 Ums.dll x86 01-Dec-2004 16:58 2000.80.993.0 74,304 Xplog70.dll x86 01-Dec-2004 16:58 2000.80.993.0 98,872 Xpweb70.dll x86 SQL Server 2000 SP3 ¶Ç´Â SQL Server 2000 SP3a¸¦ 64 ºñÆ® ¹öÀüDate Time Size File name Platform ------------------------------------------------------------------- 30-Sep-2003 19:55 180 Drop_repl_hotfix.sql I-64 30-Sep-2003 19:55 1,581 Inst_repl_hotfix.sql I-64 08-Apr-2004 18:42 12,305 Qfe469315.sql I-64 08-Apr-2004 18:42 19,195 Qfe469571.sql I-64 26-Aug-2004 21:14 5,157 Qfe472197.sql I-64 01-Dec-2004 17:18 1,106,776 Replmerg.sql I-64 26-Aug-2004 21:14 1,086,925 Replsys.sql I-64 30-Sep-2003 19:55 986,603 Repltran.sql I-64 24-Nov-2004 21:04 55 Repl_uninstall.sql I-64 30-Sep-2003 19:48 117,834 Sp3_serv_uni.sql I-64 02-Dec-2004 01:03 22,827,520 Sqlrun.msp I-64 Âü°í ÆÄÀÏ Á¾¼Ó¼ºÀ¸·Î ÀÎÇØ ÀÌ·¯ÇÑ ÆÄÀÏÀÌ ÃֽŠÇÖÇȽº¿¡ Ãß°¡ ÆÄÀÏÀÌ Æ÷Ç﵃ ¼öµµ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 4¿¡¼ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. ÇöÀç »óÅÂMicrosoft´Â "º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿µÈ Á¦Ç°¿¡¼ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. Ãß°¡ Á¤º¸Microsoft SQL Server ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ¾÷µ¥ÀÌÆ®, Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¹®¼¸¦ º¸·Á¸é ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÕ´Ï´Ù. 822499 Ãâ½Ã ÀÌÈÄ¿¡ ¼ÒÇÁÆ®¿þ¾î¸¦ ¼öÁ¤ÇÒ ¶§ Microsoft¿¡¼ »ç¿ëÇÏ´Â ¿ë¾î¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¹®¼¸¦ º¸·Á¸é Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ ´©¸¨´Ï´Ù.
(http://support.microsoft.com/kb/822499/
)
Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐÅ°ÁöÀÇ »õ·Î¿î ¸í¸í ½ºÅ°¸¶ 824684
(http://support.microsoft.com/kb/824684/
)
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í¼Ó¼º±â¼ú ÀÚ·á: 888444 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 3.4 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. |
À§·Î °¡±â
