Select the product you need help with
FIX: °øÀ¯ ÆäÀÌÁö Àá±ÝÀ» Æ®·£Àè¼ÇÀÇ ³¡±îÁö º¸À¯ÇØ¾ß ¼ö ÀÖÀ¸¸ç SQL Server 2000 ¼ºñ½º ÆÑ 3(SP3) ÀÖ´Â Â÷´Ü ¶Ç´Â ¼º´É ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.±â¼ú ÀÚ·á: 843266 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. # ¹ö±×: 471578 (SQL Server 8.0) ÀÌ ÆäÀÌÁö¿¡¼Çö»óMicrosoft SQL Server 2000 ¼ºñ½º ÆÑ 3(SP3) ÀÖ´Â, Æ®·£Àè¼ÇÀÌ ³¡³¯ ¶§±îÁö °øÀ¯ ÆäÀÌÁö Àá±ÝÀº º¸À¯ÇØ¾ß ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®Á¦´Â Â÷´Ü ¶Ç´Â ¼º´É ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿øÀÎREAD COMMITTED Æ®·£Àè¼Ç °Ý¸® ¼öÁØÀ» ¼³Á¤ÇÏ¸é º´·Ä À妽º ½ºÄµ ¶Ç´Â °Ë»ö ÀÛ¾÷À» ¼öÇàÇÏ´Â µ¿¾È Æ®·£Àè¼ÇÀÌ SELECT ¹®À» »ç¿ëÇÏ´Â °æ¿ì ÀÌ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù. COMMIT ¶Ç´Â ROLLBACK ÀÛ¾÷ °øÀ¯ ÆäÀÌÁö Àá±ÝÀ» º¸À¯ÇÑ ½Ã°£ ±æÀ̸¦ °áÁ¤ÇÕ´Ï´Ù. ÇØ°á ¹æ¹ý¼ºñ½º ÆÑ Á¤º¸ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼ È®ÀÎÇϽʽÿÀ:290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ÇÖÇȽº Á¤º¸ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ.Date Time Version Size File name ------------------------------------------------------------------- 08-Jun-2004 17:14 2000.80.949.0 664,128 Autoplt.dll 08-Jun-2004 17:14 2000.80.949.0 78,400 Console.exe 08-Jun-2004 17:14 2000.80.949.0 315,968 Custtask.dll 08-Jun-2004 17:14 2000.80.949.0 33,340 Dbmslpcn.dll 08-Apr-2004 21:42 786,432 Distmdl.ldf 08-Apr-2004 21:42 2,359,296 Distmdl.mdf 10-Oct-2003 18:48 180 Drop_repl_hotfix.sql 08-Jun-2004 17:14 2000.80.949.0 1,905,216 Dtspkg.dll 08-Jun-2004 17:14 2000.80.949.0 528,960 Dtspump.dll 08-Jun-2004 17:14 2000.80.949.0 1,557,052 Dtsui.dll 08-Jun-2004 17:14 2000.80.949.0 639,552 Dtswiz.dll 10-Oct-2003 18:48 747,927 Instdist.sql 10-Oct-2003 18:48 1,581 Inst_repl_hotfix.sql 08-Jun-2004 17:14 2000.80.949.0 352,828 Isqlw.exe 08-Jun-2004 17:14 2000.80.949.0 82,492 Itwiz.exe 08-Jun-2004 17:14 2000.80.949.0 90,692 Msgprox.dll 19-May-2004 23:43 8.11.40209.0 209,408 Mssdi98.dll 08-Jun-2004 17:14 2000.80.949.0 62,024 Odsole70.dll 08-Jun-2004 17:15 2000.80.949.0 25,144 Opends60.dll 08-Jun-2004 17:16 82,944 Opends60.pdb 08-Jun-2004 17:14 2000.80.949.0 57,904 Osql.exe 08-Jun-2004 17:14 2000.80.949.0 279,104 Pfutil80.dll 10-Oct-2003 18:37 550,780 Procsyst.sql 08-Apr-2004 21:42 12,305 Qfe469315.sql 08-Apr-2004 21:42 19,195 Qfe469571.sql 08-Jun-2004 15:52 1,104,848 Replmerg.sql 08-Jun-2004 17:14 2000.80.949.0 221,768 Replprov.dll 08-Jun-2004 17:14 2000.80.949.0 307,784 Replrec.dll 08-Jun-2004 16:12 2000.80.949.0 159,813 Replres.rll 10-Oct-2003 18:48 1,087,150 Replsys.sql 10-Oct-2003 18:48 986,603 Repltran.sql 08-Jun-2004 17:14 2000.80.949.0 287,304 Rinitcom.dll 08-Jun-2004 17:14 2000.80.949.0 78,416 Sdiclnt.dll 08-Jun-2004 17:14 2000.80.949.0 66,112 Semmap.dll 08-Jun-2004 17:14 2000.80.949.0 57,916 Semnt.dll 08-Jun-2004 17:14 2000.80.949.0 492,096 Semobj.dll 08-Jun-2004 16:37 2000.80.949.0 172,032 Semobj.rll 08-Jun-2004 17:14 2000.80.949.0 53,832 Snapshot.exe 12-Mar-2004 03:10 117,834 Sp3_serv_uni.sql 08-Jun-2004 17:13 2000.80.949.0 28,672 Sqlagent.dll 08-Jun-2004 17:14 2000.80.949.0 311,872 Sqlagent.exe 08-Jun-2004 17:13 2000.80.949.0 168,001 Sqlakw32.dll 08-Jun-2004 17:15 2000.80.949.0 33,344 Sqlctr80.dll 08-Jun-2004 17:15 2000.80.949.0 4,215,360 Sqldmo.dll 08-Jun-2004 17:14 25,172 Sqldumper.exe 08-Jun-2004 15:49 2000.80.949.0 28,672 Sqlevn70.rll 08-Jun-2004 17:15 2000.80.949.0 180,792 Sqlmap70.dll 08-Jun-2004 17:15 2000.80.949.0 188,992 Sqlmmc.dll 08-Jun-2004 16:41 2000.80.949.0 479,232 Sqlmmc.rll 08-Jun-2004 17:15 2000.80.949.0 401,984 Sqlqry.dll 08-Jun-2004 17:15 2000.80.949.0 57,920 Sqlrepss.dll 08-Jun-2004 17:15 2000.80.949.0 7,581,777 Sqlservr.exe 08-Jun-2004 17:15 13,050,880 Sqlservr.pdb 08-Jun-2004 17:15 2000.80.949.0 590,396 Sqlsort.dll 08-Jun-2004 17:15 2000.80.949.0 45,644 Sqlvdi.dll 08-Jun-2004 17:15 2000.80.949.0 106,588 Sqsrvres.dll 08-Jun-2004 17:15 2000.80.949.0 33,340 Ssmslpcn.dll 08-Jun-2004 17:15 2000.80.949.0 82,492 Ssnetlib.dll 08-Jun-2004 17:15 2000.80.949.0 25,148 Ssnmpn70.dll 08-Jun-2004 17:15 2000.80.949.0 123,456 Stardds.dll 08-Jun-2004 17:15 2000.80.949.0 158,240 Svrnetcn.dll 08-Jun-2004 17:14 2000.80.949.0 76,416 Svrnetcn.exe 08-Jun-2004 17:15 2000.80.949.0 49,228 Ums.dll 08-Jun-2004 17:15 132,096 Ums.pdb 08-Jun-2004 17:15 2000.80.949.0 98,872 Xpweb70.dll ÇöÀç »óÅÂMicrosoft´Â "º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿µÈ Microsoft Á¦Ç°¿¡¼ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 4¿¡¼ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. Ãß°¡ Á¤º¸MicrosoftÀº SQL Server 2000 ¼öÁ¤ ÇÁ·Î±×·¥Àº ´Ù¿î·Îµå °¡´ÉÇÑ ÆÄÀÏ·Î ¹èÆ÷ÇÕ´Ï´Ù. ¼öÁ¤ ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠ°¢ »õ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¿Í ÀÌÀü SQL Server 2000 ÇÖÇȽº ¸±¸®½º¿¡ Æ÷ÇÔµÈ ¸ðµç º¸¾È ¾÷µ¥ÀÌÆ®¸¦ Æ÷ÇÔÇÕ´Ï´Ù. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼ È®ÀÎÇϽʽÿÀ: 824684
(http://support.microsoft.com/kb/824684/
)
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í ¼Ó¼º±â¼ú ÀÚ·á: 843266 - ¸¶Áö¸· °ËÅä: 2006³â 6¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 2.2
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. |
À§·Î °¡±â
