FIX: LIKE Á¶°ÇÀÚ ³¡ %s¿¡ÀÇ ¹®ÀÚ¸¦ »ç¿ëÇÏ´Â Äõ¸®¸¦ ½ÇÇàÇÒ ¶§ »ç¿ëÀÚ°¡ À߸øµÈ °á°ú¸¦ ¹ÞÀ»ÇÕ´Ï´Ù

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

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

Çö»ó

¿µ¹®ÀÚ¿Í ¼ýÀÚ°¡ Á¶ÇÕµÈ PIN Äڵ尡 ¼³Á¤µÈ Bluetooth ÀåÄ¡°¡ ÀÖ´Ù¸é. Microsoft SQL Server 2008 ¿¡¼­´Â Å×ÀÌºí¿¡ ´ëÇØ Á¶°ÇÀÚ¸¦ %s¿¡ÀÇ ¿ÍÀϵåÄ«µå ¹®ÀÚ ÇÔ²² LIKE ¿¬»êÀÚ¸¦ »ç¿ëÇÏ´Â Äõ¸®¸¦ ½ÇÇàÇÕ´Ï´Ù. ÀÌ °æ¿ì À߸øµÈ °á°ú°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.

¿¹¸¦ µé¾î, ´ÙÀ½°ú °°Àº Äõ¸®¸¦ ½ÇÇàÇÒ ¶§ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù: 
SELECT * FROM Table1 WHERE Column1 LIKE 's%'

À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

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

SQL Server 2008

Áß¿ä SQL Server 2008 ¸±¸®½º ¹öÀüÀ» ½ÇÇàÇÏ°í ÀÖ´Â °æ¿ì ÀÌ ¼öÁ¤ ÇÁ·Î±×·¥À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.

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

SQL Server 2008 ¼­ºñ½º ÆÑ 1

Áß¿ä SQL Server 2008 ¼­ºñ½º ÆÑ 1À» ½ÇÇàÇÏ´Â °æ¿ì ÀÌ ¼öÁ¤ ÇÁ·Î±×·¥À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.

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

ÇÖÇȽº Á¤º¸

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

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

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

Çʼö Á¶°Ç

ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇϱâ Àü¿¡ ¼³Ä¡µÈ SQL Server 2008 ¸±¸®½º ¹öÀüÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.

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

ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ¿¡´Â ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.

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

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

ÇÖÇȽº ÆÄÀÏ Á¤º¸

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

ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿­µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀÇ ³¯Â¥¿Í ½Ã°£Àº UTC(ÇùÁ¤ ¼¼°è½Ã)·Î ³ª¿­µÇ¸ç. ÆÄÀÏ Á¤º¸¿¡¼­´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ÇöÁö ½Ã°£ÀÇ Â÷À̸¦ º¸·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ Ç׸ñ¿¡¼­ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ.

32ºñÆ® ¹öÀü

SQL Server 2008 ÇÙ½É ¼­ºñ½º µ¥ÀÌÅͺ£À̽º °øÀ¯
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
commanddest.dll2007.100.1810.0164,7122009-Jun-2005: 29X86
distrib.exe2007.100.1810.075,1122009-Jun-2005: 44X86
dtexec.exe2007.100.1810.054,1202009-Jun-2005: 44X86
dts.dll2007.100.1810.01,429,3522009-Jun-2005: 44X86
dtslog.dll2007.100.1810.079,7202009-Jun-2005: 44X86
dtspipeline.dll2007.100.1810.0694,1202009-Jun-2005: 44X86
dtswizard.exe2007.100.1810.0804,7122009-Jun-2005: 45X86
exceldest.dll2007.100.1810.0173,4002009-Jun-2005: 58X86
excelsrc.dll2007.100.1810.0183,1282009-Jun-2005: 58X86
Flatfiledest.dll2007.100.1810.0276,3122009-Jun-2005: 59X86
Flatfilesrc.dll2007.100.1810.0283,9922009-Jun-2005: 59X86
iftsph.dll2007.100.1810.038,7442009-Jun-2006: 13X86
Logread.exe2007.100.1810.0423,2562009-Jun-2006: 52X86
microsoft.sqlserver.adonetsrc.dll10.0.1810.067,4162009-Jun-2006: 55X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
microsoft.sqlserver.dmf.dll10.0.1810.0292,7122009-Jun-2006: 57X86
Microsoft.sqlserver.maintenanceplantasks.dll10.0.1810.0296,8082009-Jun-2006: 59X86
microsoft.sqlserver.management.collectortasks.dll10.0.1810.083,8162009-Jun-2006: 59X86
microsoft.sqlserver.pipelinehost.dll10.0.1810.071,5122009-Jun-2007: 00X86
Microsoft.sqlserver.replication.dll2007.100.1810.01,765,7362009-Jun-2007: 00X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
oledbdest.dll2007.100.1810.0173,9282009-Jun-2007: 07X86
oledbsrc.dll2007.100.1810.0186,7122009-Jun-2007: 07X86
Rdistcom.dll2007.100.1810.0651,1122009-Jun-2007: 22X86
repldp.dll2007.100.1810.0191,3202009-Jun-2007: 23X86
Replmerg.exe2007.100.1810.0341,3522009-Jun-2007: 23X86
snapshot.exe10.0.1810.013,1602009-Jun-2008: 29X86
sql_engine_core_shared_keyfile.dll2007.100.1810.013,6722009-Jun-2006: 39X86
sqllogship.exe10.0.1810.096,1042009-Jun-2008: 30X86
sqlmergx.dll2007.100.1810.0192,8722009-Jun-2008: 30X86
sqltaskconnections.dll2007.100.1810.0113,4962009-Jun-2008: 31X86
sqlwep100.dll2007.100.1810.087,4002009-Jun-2008: 31X86
txdataconvert.dll2007.100.1810.0206,6802009-Jun-2008: 33X86
SQL Server 2008 ÇÙ½É µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀνºÅϽº
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
atxcore.dll2007.100.1810.026,4562009-Jun-2005: 26X86
databasemailengine.dll10.0.1805.075,6082009-04-2416: 37X86
databasemailprotocols.dll10.0.1805.042,8402009-04-2416: 37X86
datacollectorcontroller.dll2007.100.1810.0134,4882009-Jun-2005: 30X86
sql_engine_core_inst_keyfile.dll2007.100.1810.013,6722009-Jun-2006: 39X86
Sqlagent.exe2007.100.1810.0366,9522009-Jun-2008: 29X86
sqlctr100.dll2007.100.1810.077,1602009-Jun-2008: 29X86
sqlos.dll2007.100.1810.014,6962009-Jun-2008: 30X86
sqlscriptdowngrade.dll2007.100.1810.014,6962009-Jun-2008: 30X86
sqlscriptupgrade.dll2007.100.1810.03,374,4402009-Jun-2008: 30X86
Sqlservr.exe2007.100.1810.041,009,5122009-Jun-2008: 30X86
SQL Server 2008 µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀÏ¹Ý Çʼö ¿ä¼Ò
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
Microsoft.analysisservices.dll10.0.1810.01,316,6962009-Jun-2006: 53X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
msgprox.dll2007.100.1810.0202,0722009-Jun-2007: 02X86
replprov.dll2007.100.1810.0575,3202009-Jun-2007: 23X86
Replrec.dll2007.100.1810.0789,8482009-Jun-2007: 23X86
replsub.dll2007.100.1810.0410,9682009-Jun-2007: 23X86
sql_common_core_keyfile.dll2007.100.1810.013,6722009-Jun-2006: 39X86
svrenumapi100.dll2007.100.1810.0755,5602009-Jun-2008: 32X86
xmlsub.dll2007.100.1810.0192,3442009-Jun-2008: 34X86

x 64 ±â¹Ý ¹öÀü

SQL Server 2008 ÇÙ½É ¼­ºñ½º µ¥ÀÌÅͺ£À̽º °øÀ¯
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
commanddest.dll2007.100.1810.0247,1442009-Jun-2011: 35:X64
distrib.exe2007.100.1810.086,8882009-Jun-2011: 42:X64
dtexec.exe2007.100.1810.064,8562009-Jun-2011: 42:X64
dts.dll2007.100.1810.02,202,9842009-Jun-2011: 42:X64
dtslog.dll2007.100.1810.095,5922009-Jun-2011: 43:X64
dtspipeline.dll2007.100.1810.01,086,8242009-Jun-2011: 43:X64
dtswizard.exe2007.100.1810.0800,6162009-Jun-2011: 43:X64
exceldest.dll2007.100.1810.0260,4402009-Jun-2011: 49:X64
excelsrc.dll2007.100.1810.0279,9122009-Jun-2011: 49:X64
Flatfiledest.dll2007.100.1810.0414,5682009-Jun-2011: 49:X64
Flatfilesrc.dll2007.100.1810.0424,7922009-Jun-2011: 49:X64
iftsph.dll2007.100.1810.054,6322009-Jun-2011: 57:X64
Logread.exe2007.100.1810.0510,8082009-Jun-2012: 15:X64
microsoft.sqlserver.adonetsrc.dll10.0.1810.067,4162009-Jun-2012: 17X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
microsoft.sqlserver.dmf.dll10.0.1810.0292,7122009-Jun-2006: 57X86
microsoft.sqlserver.dmf.dll10.0.1810.0292,6962009-Jun-2012: 18X86
Microsoft.sqlserver.maintenanceplantasks.dll10.0.1810.0296,8082009-Jun-2006: 59X86
microsoft.sqlserver.management.collectortasks.dll10.0.1810.083,8002009-Jun-2012: 19X86
microsoft.sqlserver.pipelinehost.dll10.0.1810.071,5122009-Jun-2012: 20X86
Microsoft.sqlserver.replication.dll2007.100.1810.01,765,7362009-Jun-2007: 00X86
Microsoft.sqlserver.replication.dll2007.100.1810.01,939,8002009-Jun-2012: 20:X64
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
oledbdest.dll2007.100.1810.0259,9442009-Jun-2012: 26:X64
oledbsrc.dll2007.100.1810.0286,0402009-Jun-2012: 26:X64
Rdistcom.dll2007.100.1810.0789,8482009-Jun-2012: 33:X64
repldp.dll2007.100.1810.0191,3202009-Jun-2007: 23X86
repldp.dll2007.100.1810.0229,7202009-Jun-2012: 34:X64
Replmerg.exe2007.100.1810.0408,4242009-Jun-2012: 34:X64
snapshot.exe10.0.1810.013,1602009-Jun-2008: 29X86
snapshot.exe10.0.1810.013,1602009-Jun-2013: 18X86
sql_engine_core_shared_keyfile.dll2007.100.1810.014,1842009-Jun-2012: 09:X64
sqllogship.exe10.0.1810.096,1042009-Jun-2013: 18X86
sqlmergx.dll2007.100.1810.0229,2242009-Jun-2013: 19:X64
sqltaskconnections.dll2007.100.1810.0161,1122009-Jun-2013: 19:X64
sqlwep100.dll2007.100.1810.0116,5682009-Jun-2013: 19:X64
txdataconvert.dll2007.100.1810.0306,0082009-Jun-2013: 21:X64
SQL Server 2008 ÇÙ½É µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀνºÅϽº
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
atxcore.dll2007.100.1810.030,5522009-Jun-2011: 35:X64
databasemailengine.dll10.0.1805.075,6242009-04-2419: 41X86
databasemailprotocols.dll10.0.1805.042,8402009-04-2419: 41X86
datacollectorcontroller.dll2007.100.1810.0255,3202009-Jun-2011: 35:X64
sql_engine_core_inst_keyfile.dll2007.100.1810.014,1842009-Jun-2012: 09:X64
Sqlagent.exe2007.100.1810.0427,8642009-Jun-2013: 18:X64
sqlctr100.dll2007.100.1810.077,1602009-Jun-2008: 29X86
sqlctr100.dll2007.100.1810.0108,3922009-Jun-2013: 18:X64
sqlos.dll2007.100.1810.015,2082009-Jun-2013: 19:X64
sqlscriptdowngrade.dll2007.100.1810.015,7202009-Jun-2013: 19:X64
sqlscriptupgrade.dll2007.100.1810.03,373,9282009-Jun-2013: 19:X64
Sqlservr.exe2007.100.1810.057,868,6482009-Jun-2013: 19:X64
SQL Server 2008 µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀÏ¹Ý Çʼö ¿ä¼Ò
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
Microsoft.analysisservices.dll10.0.1810.01,316,6962009-Jun-2006: 53X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2012: 18X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2012: 20X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1042009-Jun-2012: 20X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2242009-Jun-2012: 20X86
msgprox.dll2007.100.1810.0202,0722009-Jun-2007: 02X86
msgprox.dll2007.100.1810.0246,1042009-Jun-2012: 21:X64
replprov.dll2007.100.1810.0575,3202009-Jun-2007: 23X86
replprov.dll2007.100.1810.0727,3842009-Jun-2012: 34:X64
Replrec.dll2007.100.1810.0789,8482009-Jun-2007: 23X86
Replrec.dll2007.100.1810.0976,7442009-Jun-2012: 34:X64
replsub.dll2007.100.1810.0410,9682009-Jun-2007: 23X86
replsub.dll2007.100.1810.0492,3762009-Jun-2012: 34:X64
sql_common_core_keyfile.dll2007.100.1810.014,1842009-Jun-2012: 09:X64
svrenumapi100.dll2007.100.1810.0755,5602009-Jun-2008: 32X86
svrenumapi100.dll2007.100.1810.01,017,1922009-Jun-2013: 20:X64
xmlsub.dll2007.100.1810.0192,3442009-Jun-2008: 34X86
xmlsub.dll2007.100.1810.0308,0722009-Jun-2013: 22:X64

Itanium ¾ÆÅ°ÅØó ¹öÀü

SQL Server 2008 ÇÙ½É ¼­ºñ½º µ¥ÀÌÅͺ£À̽º °øÀ¯
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
commanddest.dll2007.100.1810.0557,9122009-Jun-2006: 34IA64
distrib.exe2007.100.1810.0205,6722009-Jun-2006: 42IA64
dtexec.exe2007.100.1810.0154,9842009-Jun-2006: 42IA64
dts.dll2007.100.1810.04,249,9602009-Jun-2006: 42IA64
dtslog.dll2007.100.1810.0183,6562009-Jun-2006: 42IA64
dtspipeline.dll2007.100.1810.02,020,7122009-Jun-2006: 42IA64
dtswizard.exe2007.100.1810.0800,6162009-Jun-2006: 42IA64
exceldest.dll2007.100.1810.0584,0402009-Jun-2006: 48IA64
excelsrc.dll2007.100.1810.0641,8962009-Jun-2006: 48IA64
Flatfiledest.dll2007.100.1810.0951,1282009-Jun-2006: 49IA64
Flatfilesrc.dll2007.100.1810.0975,1922009-Jun-2006: 49IA64
iftsph.dll2007.100.1810.088,4242009-Jun-2056: 06IA64
Logread.exe2007.100.1810.01,124,6962009-Jun-2007: 15IA64
microsoft.sqlserver.adonetsrc.dll10.0.1810.067,4162009-Jun-2007: 16X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
microsoft.sqlserver.dmf.dll10.0.1810.0292,7122009-Jun-2006: 57X86
microsoft.sqlserver.dmf.dll10.0.1810.0292,7122009-Jun-2007: 18X86
Microsoft.sqlserver.maintenanceplantasks.dll10.0.1810.0296,8082009-Jun-2006: 59X86
microsoft.sqlserver.management.collectortasks.dll10.0.1810.083,8162009-Jun-2007: 18X86
microsoft.sqlserver.pipelinehost.dll10.0.1810.071,5122009-Jun-2007: 19X86
Microsoft.sqlserver.replication.dll2007.100.1810.01,765,7362009-Jun-2007: 00X86
Microsoft.sqlserver.replication.dll2007.100.1810.02,656,6002009-Jun-2007: 20IA64
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
oledbdest.dll2007.100.1810.0586,0722009-Jun-2007: 25IA64
oledbsrc.dll2007.100.1810.0653,6562009-Jun-2007: 26IA64
Rdistcom.dll2007.100.1810.01,835,3682009-Jun-2007: 33IA64
repldp.dll2007.100.1810.0191,3202009-Jun-2007: 23X86
repldp.dll2007.100.1810.0522,6002009-Jun-2007: 33IA64
Replmerg.exe2007.100.1810.0969,5762009-Jun-2007: 34IA64
snapshot.exe10.0.1810.013,1602009-Jun-2008: 17X86
snapshot.exe10.0.1810.013,1602009-Jun-2008: 29X86
sql_engine_core_shared_keyfile.dll2007.100.1810.019,3042009-Jun-2007: 08IA64
sqllogship.exe10.0.1810.096,0882009-Jun-2008: 18X86
sqlmergx.dll2007.100.1810.0428,3762009-Jun-2008: 18IA64
sqltaskconnections.dll2007.100.1810.0335,7042009-Jun-2019: 08IA64
sqlwep100.dll2007.100.1810.0212,3122009-Jun-2019: 08IA64
txdataconvert.dll2007.100.1810.0674,6482009-Jun-2008: 21IA64
SQL Server 2008 ÇÙ½É µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀνºÅϽº
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
atxcore.dll2007.100.1810.059,2402009-Jun-2006: 34IA64
databasemailengine.dll10.0.1805.075,6242009-04-2419:08X86
databasemailprotocols.dll10.0.1805.042,8562009-04-2419:08X86
datacollectorcontroller.dll2007.100.1810.0470,8722009-Jun-2006: 35IA64
sql_engine_core_inst_keyfile.dll2007.100.1810.019,3042009-Jun-2007: 08IA64
Sqlagent.exe2007.100.1810.01,201,4962009-Jun-2008: 17IA64
sqlctr100.dll2007.100.1810.0135,0162009-Jun-2008: 18IA64
sqlctr100.dll2007.100.1810.077,1602009-Jun-2008: 29X86
sqlos.dll2007.100.1810.022,3762009-Jun-2008: 18IA64
sqlscriptdowngrade.dll2007.100.1810.020,8242009-Jun-2008: 18IA64
sqlscriptupgrade.dll2007.100.1810.03,380,0562009-Jun-2008: 18IA64
Sqlservr.exe2007.100.1810.0110,975,8322009-Jun-2019: 08IA64
SQL Server 2008 µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ÀÏ¹Ý Çʼö ¿ä¼Ò
Ç¥ Ãà¼ÒÇ¥ È®´ë
File NameÆÄÀÏ ¹öÀüÆÄÀÏ Å©±âDATETIME<Th>Ç÷§Æû</Th></Tr>
Microsoft.analysisservices.dll10.0.1810.01,316,6962009-Jun-2006: 53X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3522009-Jun-2006: 57X86
microsoft.sqlserver.connectioninfo.dll10.0.1810.0149,3362009-Jun-2007: 18X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,9042009-Jun-2007: 00X86
Microsoft.sqlserver.smo.dll10.0.1810.02,860,8882009-Jun-2007: 20X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 00X86
microsoft.sqlserver.smoextended.dll10.0.1810.0182,1202009-Jun-2007: 20X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 00X86
Microsoft.sqlserver.sqlenum.dll10.0.1810.01,083,2402009-Jun-2007: 20X86
msgprox.dll2007.100.1810.0202,0722009-Jun-2007: 02X86
msgprox.dll2007.100.1810.0534,3602009-Jun-2007: 21IA64
replprov.dll2007.100.1810.0575,3202009-Jun-2007: 23X86
replprov.dll2007.100.1810.01,640,8082009-Jun-2007: 34IA64
Replrec.dll2007.100.1810.0789,8482009-Jun-2007: 23X86
Replrec.dll2007.100.1810.02,125,1602009-Jun-2007: 34IA64
replsub.dll2007.100.1810.0410,9682009-Jun-2007: 23X86
replsub.dll2007.100.1810.01,111,9122009-Jun-2007: 34IA64
sql_common_core_keyfile.dll2007.100.1810.019,3042009-Jun-2007: 08IA64
svrenumapi100.dll2007.100.1810.02,696,0402009-Jun-2008: 20IA64
svrenumapi100.dll2007.100.1810.0755,5602009-Jun-2008: 32X86
xmlsub.dll2007.100.1810.0558,9362009-Jun-2008: 22IA64
xmlsub.dll2007.100.1810.0192,3442009-Jun-2008: 34X86
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ:
  • SQL Server 2000°ú ȣȯµÇ´Â µ¥ÀÌÅÍ Á¤·ÄÀ» »ç¿ëÇÏ¿© Å×À̺íÀÇ µ¥ÀÌÅÍ Á¤·ÄÀ» º¯°æÇϽʽÿÀ.
  • °Ë»ö Á¶°ÇÀ» º¯°æÇÏ·Á¸é ColumnName LIKE ÇÁ·Î±×·¥ÀÇ % ' À§ÇØ N 'S ' < =ColumnName AND ColumnName < N'T '.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

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

ÂüÁ¶

SQL ServerÀÇ ÁõºÐ ¼­ºñ½º ¸ðµ¨¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ:
935897
(http://support.microsoft.com/kb/935897/ )
º¸°íµÈ ¹®Á¦¿¡ ´ëÇÑ ÇÖÇȽº¸¦ Á¦°øÇÏ´Â SQL Server ÆÀÀ¸·ÎºÎÅÍ ÁõºÐ ¼­ºñ½º ¸ðµ¨À» ±¸ÇÒ ¼ö ÀÖÀ½


SQL Server ¾÷µ¥ÀÌÆ®ÀÇ ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ:
822499
(http://support.microsoft.com/kb/822499/ )
INF: Microsoft SQL Server ÇÖÇȽº ÆÐÅ°ÁöÀÇ »õ ¸í¸í ½ºÅ°¸¶


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

¼Ó¼º

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

Çǵå¹é º¸³»±â

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