FIX: SQL Server 2005¿¡¼ º¹ÀâÇÑ Äõ¸®¸¦ ½ÇÇàÇÒ ¶§ Äõ¸® ¼º´ÉÀ» ¹Ý Á¶ÀÎ ¿¬»êÀÚ¸¦ Äõ¸® ½ÇÇà °èȹÀÌ Æ÷ÇÔµÈ °æ¿ì ´À·ÁÁø´Ù# ¹ö±×: 50001440 (SQL ÇÖÇȽº) ¾Ë¸²Microsoft´Â Microsoft SQL Server 2005 ¼öÁ¤ ÇÁ·Î±×·¥À» ´Ù¿î·Îµå °¡´ÉÇÑ ÆÄÀÏ·Î ¹èÆ÷ÇÕ´Ï´Ù. ¼öÁ¤ ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠÇÖÇȽº°¡ ¸ðµÎ °¢ »õ ¸±¸®½º¿¡ Æ÷ÇԵǾî ÀÖÀ¸¸ç ÀÌÀü SQL Server 2005 Æ÷ÇÔµÈ ¸ðµç º¸¾È ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ¼öÁ¤.ÀÌ ¹®¼¿¡¼´Â ´ÙÀ½À» ÀÌ ÇÖÇȽº ¸±¸®½º¿¡ ´ëÇÑ ¼³¸íÀÔ´Ï´Ù. - ÇÖÇȽº ÆÐŰÁö¿¡¼ ÇØ°áµÈ ¹®Á¦
- ÇÖÇȽº ÆÐŰÁö ¼³Ä¡¸¦ À§ÇÑ ÀüÁ¦ Á¶°Ç
- ÇÖÇȽº ÆÐŰÁö ¼³Ä¡ ÈÄ ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÏ´ÂÁö ¿©ºÎ
- ÇÖÇȽº ÆÐŰÁö°¡ ´Ù¸¥ ÇÖÇȽº ÆÐŰÁö¿¡ ´ëüµË´Ï´Ù ¿©ºÎ¸¦
- »ç¿ëÇÏ¸é ¸ðµç ·¹Áö½ºÆ®¸®¸¦ º¯°æÇØ¾ß ÇÏ´ÂÁö ¿©ºÎ
- ÇÖÇȽº ÆÐŰÁö¿¡ Æ÷ÇÔµÈ ÆÄÀÏ
Microsoft SQL Server 2005¿¡¼ º¹ÀâÇÑ Äõ¸®°¡ ÀÖ½À´Ï´Ù. ¼¼¹ÌÆ®·¹ÀÏ·¯ Á¶ÀÎ ¿¬»êÀÚ¸¦ Äõ¸® ½ÇÇà °èȹÀ» Æ÷ÇÔÇÕ´Ï´Ù. Äõ¸®¸¦ ½ÇÇàÇÒ ¶§ Äõ¸®ÀÇ Äõ¸® ¼º´ÉÀ» Microsoft SQL Server 2000 ºñÇØ ¼Óµµ°¡ ´À¸° ÆíÀÔ´Ï´Ù. Âü°í ÀϹÝÀûÀ¸·Î IN Ű¿öµå ¶Ç´Â EXISTS Ű¿öµå´Â Äõ¸®¿¡ Æ÷ÇÔµÈ °æ¿ì ¹Ý Á¶ÀÎ ¿¬»êÀÚ´Â »ý¼ºµË´Ï´Ù. Äõ¸® ÃÖÀûÈ ÇÁ·Î±×·¥Àº SQL Server 2000 °Íº¸´Ù ¸¹Àº ÀÚ¼¼ÇÑ ½ÇÇà °èȹÀ» »ý¼ºÇϱ⠶§¹®¿¡ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù. µû¶ó¼ Äõ¸® ÃÖÀûÈ ÇÁ·Î±×·¥Àº ½Ã°£ÀÌ ÃʰúµÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·± °æ¿ì Äõ¸® ÃÖÀûÈ ÇÁ·Î±×·¥Àº Äõ¸® ÃÖÀûÈ ÇÁ·Î±×·¥ÀÌ °èȹÀ» ½ÇÇàÇÏ´Â ¸ðµç °¡´ÉÇÑ ¿ÏÀüÈ÷ °Ë»öÇϱâ Àü¿¡ °èȹÀ» ½ÇÇàÇÏ´Â µ¥ °Ë»öÀ» ÁßÁöÇÕ´Ï´Ù. °Ë»ö Äõ¸® ÃÖÀûÈ ÇÁ·Î±×·¥Àº ½Ã°£ÀÌ ÃʰúµÈ ¿©ºÎ¸¦ È®ÀÎÇÏ·Á¸é ÇØ´ç StatementOptmEarlyAbortReason "½Ã°£ Ãʰú" = XML Ãâ·Â ½ÇÇà °èȹ ½ÇÇà °èȹÀ» ½Ä¿¡¼. ÇÖÇȽº Á¤º¸Microsoft¿¡¼ Á¦°øÇÏ´Â ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ÀÌ ÇÖÇȽº´Â ÀÌ ¹®¼¿¡¼ ¼³¸íµÈ ¹®Á¦¸¸ ÇØ°áÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®¼¿¡ ¼³¸íµÈ ƯÁ¤ ¹®Á¦°¡ ¹ß»ýÇÑ ½Ã½ºÅÛ¿¡¸¸ ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇϽʽÿÀ. ÃßÈÄ¿¡ ÀÌ ÇÖÇȽº¸¦ Å×½ºÆ®ÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼ ÀÌ ¹®Á¦·Î ½É°¢ÇÏ°Ô ¿µÇâÀ» ¹ÞÀº °æ¿ì¸¦ Á¦¿ÜÇϰï ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ´ÙÀ½ ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®±îÁö ±â´Ù¸®´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ´Ù¿î·ÎµåÇÒ ÇÖÇȽº°¡ ÀÖ´Â °æ¿ì, ÀÌ ±â¼ú ÀÚ·á ¹®¼ÀÇ ¸Ç À§¿¡ "»ç¿ë °¡´ÉÇÑ ÇÖÇȽº ´Ù¿î·Îµå" ¸µÅ©°¡ ÀÖ½À´Ï´Ù. ÀÌ ¸µÅ©°¡ Ç¥½ÃµÇÁö ¾Ê´Â °æ¿ì, Microsoft °í°´ Áö¿ø ¼ºñ½º¿¡ ¹®ÀÇÇÏ¿© ÇÖÇȽº¸¦ ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù. Âü°í Ãß°¡ÀûÀÎ ¹®Á¦°¡ ¹ß»ýÇÒ °æ¿ì ¶Ç´Â ¸ðµç ¹®Á¦ ÇØ°á¿¡ ÇÊ¿äÇÑ °æ¿ì º°µµÀÇ ¼ºñ½º ¿äûÀ» ¸¸µé¾î¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÇÖÇȽº¿¡ Àû¿ëµÇÁö ¾Ê´Â Ãß°¡ Áö¿ø Áú¹®°ú ¹®Á¦¿¡´Â ÀÏ¹Ý Áö¿ø ºñ¿ëÀÌ Àû¿ëµË´Ï´Ù. Microsoft °í°´ ¼ºñ½º Áö¿ø ÀüÈ ¹øÈ£ Àüü ¸ñ·Ï ¶Ç´Â º°µµÀÇ ¼ºñ½º ¿äûÀ» ¸¸µé·Á¸é ´ÙÀ½ Microsoft À¥ »çÀÌÆ®·Î À̵¿ÇϽʽÿÀ: Âü°í "ÇÖÇȽº ´Ù¿î·Îµå °¡´É" Çü½Ä¿¡´Â ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â ¾ð¾î°¡ Ç¥½ÃµË´Ï´Ù. »ç¿ëÀÚ ¾ð¾î°¡ Ç¥½ÃµÇÁö ¾ÊÀ¸¸é ÇØ´ç ¾ð¾îÀÇ ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù ¶§¹®ÀÔ´Ï´Ù. ÀüÁ¦ Á¶°Ç- SQL Server 2005 ¼ºñ½º ÆÑ 2
SQL Server 2005 ¼ºñ½º ÆÑ 2¸¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 913089
(http://support.microsoft.com/kb/913089/
)
SQL Server 2005 Ãֽмºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý
Á¤º¸¸¦ ´Ù½ÃÇÕ´Ï´ÙÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ¿¡´Â ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇÒ Çʿ䰡 ¾ø½À´Ï´Ù. ÇÖÇȽº ´ëü Á¤º¸ÀÌ ÇÖÇȽº´Â ´Ù¸¥ ÇÖÇȽº·Î ´ëüµÇÁö ¾Ê½À´Ï´Ù. ·¹Áö½ºÆ®¸® Á¤º¸·¹Áö½ºÆ®¸®¸¦ º¯°æÇÒ Çʿ䰡 ¾ø½À´Ï´Ù. ÆÄÀÏ Á¤º¸ÀÌ ÇÖÇȽº¿¡´Â ÀÌ ¹®¼¿¡ ³ª¿Í ÀÖ´Â ¹®Á¦¸¦ ÇØ°áÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀϸ¸ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ ÇÖÇȽº¿¡´Â Á¦Ç°À» ÃֽŠºôµå·Î ¿ÏÀüÈ÷ ¾÷µ¥ÀÌÆ®ÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀÏÀÌ ¾øÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ Ç׸ñ¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. SQL Server 2005, 32ºñÆ® ¹öÀüÇ¥ Ãà¼ÒÇ¥ È®´ë | ÆÄÀÏ À̸§ | ÆÄÀÏ ¹öÀü | ÆÄÀÏ Å©±â | ³¯Â¥ | ½Ã°£ | Ç÷§Æû |
|---|
| Chsbrkr.dll | 12.0.7822.0 | 1,684,840 | 2007-Jun-22 | 09: 22 | x 86 | | Chtbrkr.dll | 12.0.7822.0 | 6,112,616 | 2007-Jun-22 | 09: 22 | x 86 | | Databasemailprotocols.dll | 9.0.3182.0 | 46,448 | 2007-10-7¿ù | 04: 56 | x 86 | | Fteref.dll | 12.0.7822.0 | 446,464 | 2007-Jun-22 | 09: 22 | x 86 | | Infosoft.dll | 12.0.7822.0 | 468,328 | 2007-Jun-22 | 09: 22 | x 86 | | Korwbrkr.dll | 12.0.7822.0 | 71,016 | 2007-Jun-22 | 09: 22 | x 86 | | Langwrbk.dll | 12.0.7822.0 | 136,552 | 2007-Jun-22 | 09: 22 | x 86 | | Microsoft.analysisservices.dll | 9.0.3182.0 | 1,217,904 | 2007-10-7¿ù | 04: 56 | x 86 | | Microsoft.sqlserver.maintenanceplantasks.dll | 9.0.3182.0 | 296,304 | 2007-10-7¿ù | 04: 56 | x 86 | | Msfte.dll | 12.0.7822.0 | 2,430,312 | 2007-Jun-22 | 09: 22 | x 86 | | Msftefd.exe | 12.0.7822.0 | 66,920 | 2007-Jun-22 | 09: 22 | x 86 | | Msftepxy.dll | 12.0.7822.0 | 95,592 | 2007-Jun-22 | 09: 22 | x 86 | | Msftesql.exe | 12.0.7822.0 | 95,592 | 2007-Jun-22 | 09: 22 | x 86 | | Msir5jp.dll | 5.0.2130.0 | 3,159,912 | 2007-Jun-22 | 09: 22 | x 86 | | Msmdlocal.dll | 9.0.3182.0 | 15,948,144 | 2007-10-7¿ù | 04: 56 | x 86 | | Mssqlsystemresource.ldf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 524,288 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Mssqlsystemresource.mdf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 40,108,032 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Nlhtml.dll | 12.0.7822.0 | 124,264 | 2007-Jun-22 | 09: 22 | x 86 | | Nls400.dll | 5.0.4217.0 | 12,240,744 | 2007-Jun-22 | 09: 22 | x 86 | | Odsole70.dll | 2005.90.3182.0 | 59,248 | 2007-10-7¿ù | 04: 56 | x 86 | | Query.dll | 12.0.7822.0 | 48,488 | 2007-Jun-22 | 09: 22 | x 86 | | Rdistcom.dll | 2005.90.3182.0 | 644,976 | 2007-10-7¿ù | 04: 56 | x 86 | | Replmerg.exe | 2005.90.3182.0 | 320,880 | 2007-10-7¿ù | 04: 56 | x 86 | | Replrec.dll | 2005.90.3182.0 | 784,752 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqlaccess.dll | 2005.90.3182.0 | 350,576 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqlagent90.exe | 2005.90.3182.0 | 349,552 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqlservr.exe | 2005.90.3182.0 | 29,195,120 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqlwep.dll | 2005.90.3182.0 | 90,992 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqsrvres.dll | 2005.90.3182.0 | 70,512 | 2007-10-7¿ù | 04: 56 | x 86 | | Sysdbupg.sql | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 510,622 | 2007-Jun-13 | 01: 18 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Thawbrkr.dll | 12.0.7822.0 | 206,184 | 2007-Jun-22 | 09: 22 | x 86 | | Xmlfilt.dll | 12.0.7822.0 | 197,992 | 2007-Jun-22 | 09: 22 | x 86 | | Xpstar90.dll | 2005.90.3182.0 | 298,864 | 2007-10-7¿ù | 04: 56 | x 86 |
SQL Server 2005´Â x 64 ±â¹Ý ¹öÀüÇ¥ Ãà¼ÒÇ¥ È®´ë | ÆÄÀÏ À̸§ | ÆÄÀÏ ¹öÀü | ÆÄÀÏ Å©±â | ³¯Â¥ | ½Ã°£ | Ç÷§Æû |
|---|
| Chsbrkr.dll | 12.0.7822.0 | 1,694,056 | 2007-Jun-22 | 10: 51 | x 64 | | Chtbrkr.dll | 12.0.7822.0 | 6,109,032 | 2007-Jun-22 | 10: 51 | x 64 | | Databasemailprotocols.dll | 9.0.3182.0 | 46,448 | 2007-10-7¿ù | 07: 51 | x 86 | | Fteref.dll | 12.0.7822.0 | 433,152 | 2007-Jun-22 | 10: 51 | x 64 | | Infosoft.dll | 12.0.7822.0 | 621,416 | 2007-Jun-22 | 10: 51 | x 64 | | Korwbrkr.dll | 12.0.7822.0 | 101,736 | 2007-Jun-22 | 10: 51 | x 64 | | Langwrbk.dll | 12.0.7822.0 | 236,904 | 2007-Jun-22 | 10: 51 | x 64 | | Microsoft.analysisservices.dll | 9.0.3182.0 | 1,217,904 | 2007-10-7¿ù | 04: 56 | x 86 | | Microsoft.sqlserver.maintenanceplantasks.dll | 9.0.3182.0 | 296,304 | 2007-10-7¿ù | 04: 56 | x 86 | | Msfte.dll | 12.0.7822.0 | 3,808,104 | 2007-Jun-22 | 10: 51 | x 64 | | Msftefd.exe | 12.0.7822.0 | 99,176 | 2007-Jun-22 | 10: 51 | x 64 | | Msftepxy.dll | 12.0.7822.0 | 127,336 | 2007-Jun-22 | 10: 51 | x 64 | | Msftesql.exe | 12.0.7822.0 | 158,568 | 2007-Jun-22 | 10: 51 | x 64 | | Msir5jp.dll | 5.0.2130.0 | 3,421,544 | 2007-Jun-22 | 10: 51 | x 64 | | Msmdlocal.dll | 9.0.3182.0 | 15,948,144 | 2007-10-7¿ù | 04: 56 | x 86 | | Mssqlsystemresource.ldf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 524,288 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Mssqlsystemresource.mdf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 40,108,032 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Nlhtml.dll | 12.0.7822.0 | 191,848 | 2007-Jun-22 | 10: 51 | x 64 | | Nls400.dll | 5.0.4217.0 | 14,101,352 | 2007-Jun-22 | 10: 51 | x 64 | | Odsole70.dll | 2005.90.3182.0 | 90,480 | 2007-10-7¿ù | 07: 51 | x 64 | | Query.dll | 12.0.7822.0 | 68,456 | 2007-Jun-22 | 10: 51 | x 64 | | Rdistcom.dll | 2005.90.3182.0 | 828,784 | 2007-10-7¿ù | 07: 51 | x 64 | | Replmerg.exe | 2005.90.3182.0 | 417,648 | 2007-10-7¿ù | 07: 51 | x 64 | | Replrec.dll | 2005.90.3182.0 | 1,011,568 | 2007-10-7¿ù | 07: 51 | x 64 | | Sqlaccess.dll | 2005.90.3182.0 | 357,744 | 2007-10-7¿ù | 07: 51 | x 86 | | Sqlagent90.exe | 2005.90.3182.0 | 429,424 | 2007-10-7¿ù | 07: 51 | x 64 | | Sqlservr.exe | 2005.90.3182.0 | 39,679,344 | 2007-10-7¿ù | 07: 51 | x 64 | | Sqlwep.dll | 2005.90.3182.0 | 123,760 | 2007-10-7¿ù | 07: 51 | x 64 | | Sqlwep.dll | 2005.90.3182.0 | 90,992 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqsrvres.dll | 2005.90.3182.0 | 83,312 | 2007-10-7¿ù | 07: 51 | x 64 | | Sysdbupg.sql | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 510,622 | 2007-Jun-13 | 01: 18 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Thawbrkr.dll | 12.0.7822.0 | 209,768 | 2007-Jun-22 | 10: 51 | x 64 | | Xmlfilt.dll | 12.0.7822.0 | 271,208 | 2007-Jun-22 | 10: 51 | x 64 | | Xpstar90.dll | 2005.90.3182.0 | 550,256 | 2007-10-7¿ù | 07: 51 | x 64 |
SQL Server 2005, Itanium ¾ÆÅ°ÅØÃ³ ¹öÀüÇ¥ Ãà¼ÒÇ¥ È®´ë | ÆÄÀÏ À̸§ | ÆÄÀÏ ¹öÀü | ÆÄÀÏ Å©±â | ³¯Â¥ | ½Ã°£ | Ç÷§Æû |
|---|
| Chsbrkr.dll | 12.0.7822.0 | 1,883,496 | 2007-Jun-22 | 10: 06 | IA-64 | | Chtbrkr.dll | 12.0.7822.0 | 6,153,576 | 2007-Jun-22 | 10: 06 | IA-64 | | Databasemailprotocols.dll | 9.0.3182.0 | 46,448 | 2007-10-7¿ù | 13: 01 | x 86 | | Fteref.dll | 12.0.7822.0 | 433,152 | 2007-Jun-22 | 10: 06 | IA-64 | | Infosoft.dll | 12.0.7822.0 | 1,915,240 | 2007-Jun-22 | 10: 06 | IA-64 | | Korwbrkr.dll | 12.0.7822.0 | 182,632 | 2007-Jun-22 | 10: 06 | IA-64 | | Langwrbk.dll | 12.0.7822.0 | 333,160 | 2007-Jun-22 | 10: 06 | IA-64 | | Microsoft.analysisservices.dll | 9.0.3182.0 | 1,217,904 | 2007-10-7¿ù | 04: 56 | x 86 | | Microsoft.sqlserver.maintenanceplantasks.dll | 9.0.3182.0 | 296,304 | 2007-10-7¿ù | 04: 56 | x 86 | | Msfte.dll | 12.0.7822.0 | 7,072,104 | 2007-Jun-22 | 10: 06 | IA-64 | | Msftefd.exe | 12.0.7822.0 | 173,416 | 2007-Jun-22 | 10: 06 | IA-64 | | Msftepxy.dll | 12.0.7822.0 | 135,528 | 2007-Jun-22 | 10: 06 | IA-64 | | Msftesql.exe | 12.0.7822.0 | 294,760 | 2007-Jun-22 | 10: 06 | IA-64 | | Msir5jp.dll | 5.0.2130.0 | 3,824,488 | 2007-Jun-22 | 10: 06 | IA-64 | | Msmdlocal.dll | 9.0.3182.0 | 49,907,056 | 2007-10-7¿ù | 13: 01 | IA-64 | | Mssqlsystemresource.ldf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 524,288 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Mssqlsystemresource.mdf | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 40,108,032 | 2007-10-7¿ù | 01: 45 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Nlhtml.dll | 12.0.7822.0 | 295,784 | 2007-Jun-22 | 10: 06 | IA-64 | | Nls400.dll | 5.0.4217.0 | 14,750,056 | 2007-Jun-22 | 10: 06 | IA-64 | | Odsole70.dll | 2005.90.3182.0 | 179,568 | 2007-10-7¿ù | 13: 01 | IA-64 | | Query.dll | 12.0.7822.0 | 123,240 | 2007-Jun-22 | 10: 06 | IA-64 | | Rdistcom.dll | 2005.90.3182.0 | 1,885,552 | 2007-10-7¿ù | 13: 01 | IA-64 | | Replmerg.exe | 2005.90.3182.0 | 957,296 | 2007-10-7¿ù | 13: 01 | IA-64 | | Replrec.dll | 2005.90.3182.0 | 2,145,136 | 2007-10-7¿ù | 13: 01 | IA-64 | | Sqlaccess.dll | 2005.90.3182.0 | 352,112 | 2007-10-7¿ù | 13: 01 | x 86 | | Sqlagent90.exe | 2005.90.3182.0 | 1,254,256 | 2007-10-7¿ù | 13: 01 | IA-64 | | Sqlservr.exe | 2005.90.3182.0 | 72,819,568 | 2007-10-7¿ù | 13: 01 | IA-64 | | Sqlwep.dll | 2005.90.3182.0 | 221,040 | 2007-10-7¿ù | 13: 01 | IA-64 | | Sqlwep.dll | 2005.90.3182.0 | 90,992 | 2007-10-7¿ù | 04: 56 | x 86 | | Sqsrvres.dll | 2005.90.3182.0 | 147,312 | 2007-10-7¿ù | 13: 01 | IA-64 | | Sysdbupg.sql | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | 510,622 | 2007-Jun-13 | 01: 18 | Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. | | Thawbrkr.dll | 12.0.7822.0 | 253,288 | 2007-Jun-22 | 10: 06 | IA-64 | | Xmlfilt.dll | 12.0.7822.0 | 445,800 | 2007-Jun-22 | 10: 06 | IA-64 | | Xpstar90.dll | 2005.90.3182.0 | 966,000 | 2007-10-7¿ù | 13: 01 | IA-64 |
ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é IN Ű¿öµå ¶Ç´Â EXISTS Ű¿öµå´Â »ç¿ëÇÏÁö ¸¶½Ê½Ã¿À. Microsoft´Â "º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿µÈ Microsoft Á¦Ç°¿¡¼ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ SQL Server 2000ÀÇ µ¿ÀÛÀÇ µ¿ÀÛÀÌ µÇµ¹¸³´Ï´Ù ÀÖµµ·Ï ÃßÀû Ç÷¡±× 4102 ¹× ÃßÀû Ç÷¡±× 4118 »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇϱâ Àü¿¡ "ÇØ°á ¹æ¹ý" Àý¿¡¼ ¼³¸íÇÏ´Â ¹æ¹ýÀ» »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¼¹öÀÇ ¿¬°á ¶Ç´Â ¼¹öÀÇ ¸ðµç ¿¬°á¿¡ ´ëÇØ ÀÌ·¯ÇÑ ÃßÀû Ç÷¡±×¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. ½ÃÀÛÇÒ ¶§ ÃßÀû Ç÷¡±×¸¦ ¼³Á¤ÇÑ °æ¿ì ÃßÀû Ç÷¡±× ¼¹öÀÇ ¸ðµç ¿¬°á¿¡ ¿µÇâÀ» ÁÝ´Ï´Ù. ÃßÀû Ç÷¡±×¸¦ ¼³Á¤ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2005 ¿Â¶óÀÎ ¼³¸í¼ÀÇ ´ÙÀ½ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ. - DBCC TRACEON (- SQL Æ®·£Àè¼Ç)
- ÃßÀû Ç÷¡±× (Transact-SQL)
- DBCC TRACESTATUS (- SQL Æ®·£Àè¼Ç)
- SQL Server 2005 µ¥ÀÌÅͺ£À̽º ¿£Áø ±â´É¿¡ ÁÖ¿ä º¯°æ ³»¿ë
SQL Server ¾÷µ¥ÀÌÆ®¸¦ ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 822499
(http://support.microsoft.com/kb/822499/
)
»õ ¸í¸í ½ºÅ°¸¶¿¡ Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐŰÁö¿¡ ´ëÇÑ ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ¿ë¾î¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 824684
(http://support.microsoft.com/kb/824684/
)
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í ±â¼ú ÀÚ·á: 940128 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 21ÀÏ ¼ö¿äÀÏ - ¼öÁ¤: 2.4 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Standard 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 kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB940128 KbMtko |
±â°è ¹ø¿ªµÈ ¹®¼Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù. ÀÌ ¹®¼¸¦ ÀÌÇØÇϴµ¥ ¾î´À Á¤µµÀÇ ½Ã°£ÀÌ °É¸®¼Ì½À´Ï±î? ÀÌ Á¤º¸¸¦ °³¼±ÇØ¾ß ÇÏ´Â ÀÌÀ¯¿Í °³¼±Çϱâ À§ÇØ ¹«¾ùÀ» ÇÒ ¼ö ÀÖ´ÂÁö ¾Ë·ÁÁֽʽÿÀ. °¨»çÇÕ´Ï´Ù! º¸³»ÁֽŠÀǰßÀº Áö¿ø ÄÜÅÙÃ÷¸¦ Çâ»ó½ÃŰ´Â µ¥ »ç¿ëµÉ °ÍÀÔ´Ï´Ù. ÀÚ¼¼ÇÑ Áö¿ø ¿É¼ÇÀ» º¸·Á¸é Microsoft °í°´Áö¿ø ȨÆäÀÌÁö¸¦ ¹æ¹®ÇØ Áֽñ⠹ٶø´Ï´Ù. | |