FIX: ¼ö À߸ø °á°ú°¡ ³ªÅ¸³¯ ¼öµµ SQL Server 2008ÀÇ FROM Àý¿¡¼­ ¼¼ °³ ÀÌ»óÀÇ Å×À̺íÀ» ÂüÁ¶ÇÏ´Â Äõ¸®¸¦ ½ÇÇàÇÒ ¶§

±â¼ú ÀÚ·á: 958611 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â
# ¹ö±×: 50003634 SQL ÇÖÇȽº
# ¹ö±×: 50003611 SQL ÇÖÇȽº
MicrosoftÀº ´Ù¿î·Îµå °¡´ÉÇÑ ÆÄÀÏ·Î Microsoft SQL Server 2008 ¼öÁ¤ ÇÁ·Î±×·¥À» ¹èÆ÷ÇÕ´Ï´Ù. ¼öÁ¤ ÇÁ·Î±×·¥Àº °è¼Ó ´©ÀûµÇ´Â °¢ »õ ¸±¸®½º¿¡ ¸ðµç ÇÖÇȽº¸¦ Æ÷ÇÔÇÏ¸ç ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ÀÌÀü SQL Server 2008¿¡ Æ÷ÇÔµÈ ¸ðµç º¸¾È ¼öÁ¤.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

¿ä¾à

ÀÌ ¹®¼­¿¡¼­´Â ÀÌ ÇÖÇȽº ¸±¸®½º¿¡ ´ëÇÑ ´ÙÀ½À» ¼³¸íÇÕ´Ï´Ù.
  • ÇÖÇȽº ÆÐÅ°Áö¿¡¼­ ÇØ°áµÈ ¹®Á¦
  • ÇÖÇȽº ÆÐÅ°Áö ¼³Ä¡¸¦ À§ÇÑ ÀüÁ¦ Á¶°Ç
  • ÇÖÇȽº ÆÐÅ°Áö ¼³Ä¡ ÈÄ ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù ¿©ºÎ
  • ÇÖÇȽº ÆÐÅ°Áö¿¡ ÇÖÇȽº ÆÐÅ°Áö¿¡ ´ëüµÇ´ÂÁö ¿©ºÎ
  • ¸ðµç ·¹Áö½ºÆ®¸® º¯°æÀ» ÇØ¾ß ÇÕ´Ï´Ù ¿©ºÎ
  • ÇÖÇȽº ÆÐÅ°Áö¿¡ Æ÷ÇÔµÈ ÆÄÀÏ
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çö»ó

Microsoft SQL Server 2008 Å×ÀÌºí¿¡¼­ ÇÊÅ͸µµÈ À妽º¸¦ ¸¸µì´Ï´Ù. ±×·± ´ÙÀ½ FROM ÀýÀÇ ¼¼ °³ ÀÌ»óÀÇ Å×À̺íÀ» ÂüÁ¶ÇÏ´Â Äõ¸®¸¦ ½ÇÇàÇÕ´Ï´Ù. Äõ¸®¸¦ ½ÇÇàÇϸé À߸øµÈ °á°ú°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¿øÀÎ

ÇÊÅ͸µµÈ À妽º Á¤ÀÇµÈ °Ë»ö Á¶°ÇÀ» Äõ¸®°¡ ÁöÁ¤µÇÁö ¾ÊÀº °æ¿ì¿¡µµ ÃÖÀûÈ­ ÇÊÅ͸µµÈ À妽º »ç¿ëÇϱ⠶§¹®¿¡ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

´©Àû ¾÷µ¥ÀÌÆ® Á¤º¸

ÀÌ ¹®Á¦Á¡¿¡ ´ëÇÑ ÇȽº´Â ´©Àû ¾÷µ¥ÀÌÆ® 2¸¦ ¸ÕÀú ¸±¸®½ºµÇ¾ú½À´Ï´Ù. SQL Server 2008ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¸¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¹®¼­¸¦ º¸·Á¸é Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇϽʽÿÀ.
958186
(http://support.microsoft.com/kb/958186/ )
SQL Server 2008 ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 2
Âü°í ºôµå°¡ ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠ»õ·Î¿î °¢ ¼öÁ¤ ¸±¸®½ºÀÇ ¸ðµç ÇÖÇȽº¸¦ Æ÷ÇÔÇÏ¸ç ¼öÁ¤ ÇÁ·Î±×·¥ ¸±¸®½ºÀÇ ÀÌÀü SQL Server 2008¿¡ Æ÷ÇÔµÈ ¸ðµç º¸¾È ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÇÏ´Â °í·ÁÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼­ È®ÀÎÇϽʽÿÀ:
956909
(http://support.microsoft.com/kb/956909/ )
SQL Server 2008 SQL Server 2008 ¸±¸®½ºµÈ ÈÄ¿¡ ¸±¸®½ºµÈ ºôµå

ÇÖÇȽº Á¤º¸

Microsoft¿¡¼­ Á¦°øÇÏ´Â ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ÀÌ ÇÖÇȽº´Â ÀÌ ¹®¼­¿¡¼­ ¼³¸íµÈ ¹®Á¦¸¸ ÇØ°áÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®¼­¿¡¼­ ¼³¸íÇÏ´Â ¹®Á¦°¡ ¹ß»ýÇÏ´Â ½Ã½ºÅÛ¿¡¸¸ ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇϽʽÿÀ. ÃßÈÄ¿¡ ÀÌ ÇÖÇȽº¸¦ Å×½ºÆ®ÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼­ ÀÌ ¹®Á¦·Î ½É°¢ÇÏ°Ô ¿µÇâÀ» ¹ÞÀº °æ¿ì¸¦ Á¦¿ÜÇÏ°ï ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ´ÙÀ½ ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®±îÁö ±â´Ù¸®´Â °ÍÀÌ ÁÁ½À´Ï´Ù.

´Ù¿î·ÎµåÇÒ ÇÖÇȽº°¡ ÀÖ´Â °æ¿ì, ÀÌ ±â¼ú ÀÚ·á ¹®¼­ÀÇ ¸Ç À§¿¡ "»ç¿ë °¡´ÉÇÑ ÇÖÇȽº ´Ù¿î·Îµå" ¸µÅ©°¡ ÀÖ½À´Ï´Ù. ÀÌ ¸µÅ©°¡ Ç¥½ÃµÇÁö ¾Ê´Â °æ¿ì, Microsoft °í°´ Áö¿ø ¼­ºñ½º¿¡ ¹®ÀÇÇÏ¿© ÇÖÇȽº¸¦ ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.

Âü°í Ãß°¡ ¹®Á¦°¡ ¹ß»ýÇÒ °æ¿ì ¸ðµç ¹®Á¦ ÇØ°á ÇÒ °æ¿ì º°µµÀÇ ¼­ºñ½º ¿äûÀ» ¸¸µé ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇÖÇȽº¿¡ Àû¿ëµÇÁö ¾Ê´Â Ãß°¡ Áö¿ø Áú¹®°ú ¹®Á¦¿¡´Â ÀÏ¹Ý Áö¿ø ºñ¿ëÀÌ Àû¿ëµË´Ï´Ù. Microsoft °í°´ ¼­ºñ½º Áö¿ø ÀüÈ­ ¹øÈ£ Àüü ¸ñ·Ï ¶Ç´Â º°µµÀÇ ¼­ºñ½º ¿äûÀ» ¸¸µé·Á¸é ´ÙÀ½ Microsoft À¥ »çÀÌÆ®·Î À̵¿ÇϽʽÿÀ:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
Âü°í "ÇÖÇȽº ´Ù¿î·Îµå »ç¿ë °¡´ÉÇÑ" ÆûÀ» ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â ¾ð¾î°¡ Ç¥½ÃµË´Ï´Ù. »ç¿ëÀÚ ¾ð¾î°¡ Ç¥½ÃµÇÁö ÀÖÀ¸¸é ÇØ´ç ¾ð¾îÀÇ ÇÖÇȽº¸¦ »ç¿ëÇÒ ¼ö ¾øÀ¸¹Ç·Î.

ÀüÁ¦ Á¶°Ç

Çʼö ±¸¼º ¿ä¼Ò ¾øÀ½ ÇÊ¿äÇÕ´Ï´Ù.

´Ù½Ã ½ÃÀÛ Á¤º¸

ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇÏÁö ¾Ê¾Æµµ µË´Ï´Ù.

·¹Áö½ºÆ®¸® Á¤º¸

·¹Áö½ºÆ®¸®¸¦ º¯°æÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.

ÆÄÀÏ Á¤º¸

ÀÌ ÇÖÇȽº¿¡´Â ÀÌ ¹®¼­¿¡ ³ª¿Í ÀÖ´Â ¹®Á¦¸¦ ÇØ°áÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀϸ¸ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ ÇÖÇȽº¸¦ Á¦Ç°À» ÃֽŠºôµå·Î ¿ÏÀüÈ÷ ¾÷µ¥ÀÌÆ®ÇÏ´Â µ¥ ÇÊ¿äÇÑ ¸ðµç ÆÄÀÏÀÌ Æ÷ÇÔµÇÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù.

ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿­µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿­µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼­´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ãÀ¸·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ Ç׸ñ¿¡¼­ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ.
Sql_common_core.msp
Ç¥ Ãà¼ÒÇ¥ È®´ë
ÆÄÀÏ À̸§ÆÄÀÏ ¹öÀüÆÄÀÏ Å©±â³¯Â¥½Ã°£Ç÷§Æû
Msgprox.dll2007.100.1771.0202,59211-11: 52x 86
Replprov.dll2007.100.1771.0576,35211-12: 05x 86
Replrec.dll2007.100.1771.0790,88011-12: 05x 86
Sql_common_core_keyfile.dll2007.100.1771.014,68811-11: 39x 86
Xmlsub.dll2007.100.1771.0193,37611-12: 13x 86
Sql_engine_core_inst.msp
Ç¥ Ãà¼ÒÇ¥ È®´ë
ÆÄÀÏ À̸§ÆÄÀÏ ¹öÀüÆÄÀÏ Å©±â³¯Â¥½Ã°£Ç÷§Æû
Datacollectorcontroller.dll2007.100.1771.0135,52011-11: 30x 86
Mssqlsystemresource.ldfÀû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.524,28810-23:20Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
Mssqlsystemresource.mdfÀû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.63,242,24010-23:20Àû¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
Sql_engine_core_inst_keyfile.dll2007.100.1771.014,68811-11: 39x 86
Sqlagent.exe2007.100.1771.0367,45611-12: 06x 86
Sqlservr.exe2007.100.1771.040,996,19211-12: 06x 86
Sql_engine_core_shared.msp
Ç¥ Ãà¼ÒÇ¥ È®´ë
ÆÄÀÏ À̸§ÆÄÀÏ ¹öÀüÆÄÀÏ Å©±â³¯Â¥½Ã°£Ç÷§Æû
Distrib.exe2007.100.1771.076,12811-11: 31x 86
Dtspipeline.dll2007.100.1771.0695,13611-11: 31x 86
Microsoft.sqlserver.dmf.dll10.0.1771.0293,72811-11: 52x 86
Microsoft.sqlserver.management.collectortasks.dll10.0.1771.084,83211-11: 52x 86
Rdistcom.dll2007.100.1771.0650,08011-12: 05x 86
Replmerg.exe2007.100.1771.0341,85611-12: 05x 86
Sql_engine_core_shared_keyfile.dll2007.100.1771.014,68811-11: 39x 86
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Å×ÀÌºí¿¡ ÀÛ¼ºµÈ ÇÊÅ͸µµÈ À妽º¸¦ »èÁ¦ÇÒ.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

Microsoft´Â "º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿­µÈ Microsoft Á¦Ç°¿¡¼­ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Ãß°¡ Á¤º¸

SQL Server ¾÷µ¥ÀÌÆ® ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¹®¼­¸¦ º¸·Á¸é Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇϽʽÿÀ.
822499
(http://support.microsoft.com/kb/822499/ )
Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐÅ°ÁöÀÇ »õ·Î¿î ¸í¸í ½ºÅ°¸¶
¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ¿ë¾î¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¹®¼­¸¦ º¸·Á¸é Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇϽʽÿÀ.
824684
(http://support.microsoft.com/kb/824684/ )
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 958611 - ¸¶Áö¸· °ËÅä: 2008³â 10¿ù 29ÀÏ ¼ö¿äÀÏ - ¼öÁ¤: 1.2
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
Å°¿öµå:?
kbmt kbexpertiseadvanced kbfix kbautohotfix kbqfe kbhotfixserver KB958611 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â