FIX: SQL Server 2000¿¡¼­ ÀÚü ¾÷µ¥ÀÌÆ® Äõ¸®¸¦ ¼öÇàÇÑ ÈÄ ÀÌ Å¬·¯½ºÅ͵ÇÁö ¾ÊÀº À妽º°¡ ¼Õ»óµÇ¾ú½À´Ï´Ù.

±â¼ú ÀÚ·á: 884856 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â
# ¹ö±×: 472391 (SQL Server 8.0)
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

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

Microsoft Microsoft SQL Server 2000 ÇÖÇȽº¸¦ ´Ù¿î·Îµå °¡´É ÆÄÀÏ·Î ¹èÆ÷ÇÕ´Ï´Ù. ¼öÁ¤ ´©Àû, °¢ »õ ¸±¸®½º¿¡ Æ÷ÇÔµÈ ¸ðµç ÇÖÇȽº¿Í ¸ðµç º¸¾È ÇØ°áÇÕ´Ï´Ù ¶§¹®¿¡ ÀÌÀü SQL Server 2000 ÇÖÇȽº ¸±¸®½º¿¡ Æ÷ÇÔµÈ ¾Ê¾Ò½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¹®¼­ÀÇ ¸ñÂ÷

¿ä¾à

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

Çö»ó

Microsoft SQL Server 2000¿¡¼­ ÀÚü ¾÷µ¥ÀÌÆ® Äõ¸®¸¦ ¼öÇàÇÑ ÈÄ¿¡ Ŭ·¯½ºÅ͵ÇÁö ¾ÊÀº À妽º°¡ ¼Õ»óµÇ¾ú½À´Ï´Ù ãÀ» ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ ´ÙÀ½°ú À¯»çÇÑ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.
¼­¹ö: ¸Þ½ÃÁö 8952, ¼öÁØ 16, »óÅ 1, ÁÙ 1
Å×ÀÌºí ¿À·ù: 'badqueue' µ¥ÀÌÅͺ£À̽º, À妽º 'repro.NC' (ID 1828201563) (À妽º ID 2). Å°¿¡ ´ëÇÑ Ãß°¡ ¶Ç´Â À߸øµÈ Å°:
¼­¹ö: Msg 8956, ¼öÁØ 16, »óÅÂ 1, ÁÙ 1
°ª ÇÔ²² À妽º Çà (1:308:2) (i°¡ 369 ¹× i1 = 1 = ¹×? = 61) ()·Î ½Äº°µÇ´Â µ¥ÀÌÅÍ ÇàÀ» °¡¸®Åµ´Ï´Ù.
ÀÚü ¾÷µ¥ÀÌÆ® Äõ¸® Å×À̺íÀÌ ¾Æ´Ï¶ó Àüü Å×À̺í 000°³ ÀÌ»óÀÇ ÇàÀ» ¼±ÅÃÇÒ ¶§ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌÀü ÇÖÇȽº ¸ñ·ÏÀ» Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 3 ¶Ç´Â Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 3a ÇÖÇȽº¸¦"¼½¼Ç¿¡¼­ Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
290211
(http://support.microsoft.com/kb/290211/ )
°¡Àå ÃÖ±ÙÀÇ SQL Server 2000 ¼­ºñ½º ÆÑ ±¸ÇÏ´Â ¹æ¹ý
À§·Î °¡±â | Çǵå¹é º¸³»±â

Ãß°¡ Á¤º¸

¼­ºñ½º ÆÑ Á¤º¸

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼­ È®ÀÎÇϽʽÿÀ:
290211
(http://support.microsoft.com/kb/290211/ )
ÃֽŠSQL Server 2000 ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý

ÇÖÇȽº Á¤º¸

Áß¿äÇÑ ÀÌ ÇÖÇȽº´Â ÇÖÇȽº ºôµå 2000.80.977 ¸ðµç ÇâÈÄ SQL Server 2000 SP3 ÀÌÈÄ ÇÖÇȽº°¡ Ãʱâ ÇÖÇȽº ºôµå °ÍÀÔ´Ï´Ù. ÀÌÈÄÀÇ ¸ðµç ÇÖÇȽº¸¦ ¼³Ä¡ÇÏ·Á¸é ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇØ¾ß ÇÕ´Ï´Ù.

ÀüÁ¦ Á¶°Ç

ÀÌ ÇÖÇȽº°¡ ÇÊ¿äÇÑ Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 3 (SP3). SQL Server 2000 ¼­ºñ½º ÆÑ 3 ¶Ç´Â ÀÌÈÄ ¹öÀüÀ» ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
290211
(http://support.microsoft.com/kb/290211/ )
ÃֽŠSQL Server 2000 ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý

Á¤º¸¸¦ ´Ù½ÃÇÕ´Ï´Ù

ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ¿¡´Â ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù.

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

¾øÀ½ÀÔ´Ï´Ù.

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

ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿­µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿­µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼­´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼­ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. 
   Date         Time   Version            Size    File name
   -------------------------------------------------------------------
   14-Sep-2004  23:40  2000.80.977.0     664,128  Autoplt.dll      
   14-Sep-2004  23:40  2000.80.977.0      78,400  Console.exe      
   14-Sep-2004  23:40  2000.80.977.0     332,352  Ctasksui.dll     
   14-Sep-2004  23:40  2000.80.977.0     315,968  Custtask.dll     
   14-Sep-2004  23:40  2000.80.977.0      33,340  Dbmslpcn.dll     
   08-Apr-2004  18:42                    786,432  Distmdl.ldf
   08-Apr-2004  18:42                  2,359,296  Distmdl.mdf
   30-Sep-2003  19:55                        180  Drop_repl_hotfix.sql
   14-Sep-2004  23:40  2000.80.977.0   1,905,216  Dtspkg.dll       
   14-Sep-2004  23:40  2000.80.977.0     528,960  Dtspump.dll      
   14-Sep-2004  23:40  2000.80.977.0   1,557,052  Dtsui.dll        
   14-Sep-2004  23:40  2000.80.977.0     639,552  Dtswiz.dll       
   30-Sep-2003  19:55                    747,927  Instdist.sql
   30-Sep-2003  19:55                      1,581  Inst_repl_hotfix.sql
   14-Sep-2004  23:40  2000.80.977.0     352,828  Isqlw.exe        
   14-Sep-2004  23:40  2000.80.977.0      82,492  Itwiz.exe        
   14-Sep-2004  23:40  2000.80.977.0      90,692  Msgprox.dll      
   19-May-2004  20:43  8.11.40209.0      209,408  Mssdi98.dll      
   14-Sep-2004  23:40  2000.80.977.0      62,024  Odsole70.dll     
   14-Sep-2004  23:41  2000.80.977.0      25,144  Opends60.dll     
   14-Sep-2004  23:40  2000.80.977.0      57,904  Osql.exe         
   14-Sep-2004  23:40  2000.80.977.0     279,104  Pfutil80.dll     
   30-Sep-2003  19:48                    550,780  Procsyst.sql
   08-Apr-2004  18:42                     12,305  Qfe469315.sql
   08-Apr-2004  18:42                     19,195  Qfe469571.sql
   26-Aug-2004  21:14                      5,157  Qfe472197.sql
   14-Sep-2004  23:40  2000.80.977.0     143,940  Qrdrsvc.exe      
   13-Sep-2004  19:09                  1,105,167  Replmerg.sql
   14-Sep-2004  23:41  2000.80.977.0     221,768  Replprov.dll     
   14-Sep-2004  23:41  2000.80.977.0     307,784  Replrec.dll      
   13-Sep-2004  15:16  2000.80.977.0     159,813  Replres.rll
   26-Aug-2004  21:14                  1,086,925  Replsys.sql
   30-Sep-2003  19:55                    986,603  Repltran.sql
   14-Sep-2004  23:41  2000.80.977.0     287,304  Rinitcom.dll     
   14-Sep-2004  23:41  2000.80.977.0      78,416  Sdiclnt.dll      
   14-Sep-2004  23:41  2000.80.977.0      66,112  Semmap.dll       
   14-Sep-2004  23:41  2000.80.977.0      57,916  Semnt.dll        
   14-Sep-2004  23:41  2000.80.977.0     492,096  Semobj.dll       
   13-Sep-2004  15:47  2000.80.977.0     172,032  Semobj.rll
   14-Sep-2004  23:40  2000.80.977.0      53,832  Snapshot.exe     
   30-Sep-2003  19:48                    117,834  Sp3_serv_uni.sql
   14-Sep-2004  23:40  2000.80.977.0      28,672  Sqlagent.dll     
   14-Sep-2004  23:40  2000.80.977.0     311,872  Sqlagent.exe     
   14-Sep-2004  23:40  2000.80.977.0     168,001  Sqlakw32.dll     
   14-Sep-2004  23:41  2000.80.977.0      33,344  Sqlctr80.dll     
   14-Sep-2004  23:41  2000.80.977.0   4,215,360  Sqldmo.dll       
   14-Sep-2004  23:40                     25,172  Sqldumper.exe    
   13-Sep-2004  15:09  2000.80.977.0      28,672  Sqlevn70.rll
   14-Sep-2004  23:40  2000.80.977.0     156,224  Sqlmaint.exe     
   14-Sep-2004  23:41  2000.80.977.0     180,792  Sqlmap70.dll     
   14-Sep-2004  23:41  2000.80.977.0     188,992  Sqlmmc.dll       
   13-Sep-2004  15:51  2000.80.977.0     479,232  Sqlmmc.rll
   14-Sep-2004  23:41  2000.80.977.0     401,984  Sqlqry.dll       
   14-Sep-2004  23:41  2000.80.977.0      57,920  Sqlrepss.dll     
   14-Sep-2004  23:41  2000.80.977.0   7,708,753  Sqlservr.exe     
   14-Sep-2004  23:41  2000.80.977.0     590,396  Sqlsort.dll      
   14-Sep-2004  23:41  2000.80.977.0      45,644  Sqlvdi.dll       
   14-Sep-2004  23:41  2000.80.977.0     106,588  Sqsrvres.dll     
   14-Sep-2004  23:41  2000.80.977.0      33,340  Ssmsgnet.dll     
   14-Sep-2004  23:41  2000.80.977.0      33,340  Ssmslpcn.dll     
   14-Sep-2004  23:41  2000.80.977.0      33,340  Ssmsqlgc.dll     
   14-Sep-2004  23:41  2000.80.977.0      82,492  Ssnetlib.dll     
   14-Sep-2004  23:41  2000.80.977.0      25,148  Ssnmpn70.dll     
   14-Sep-2004  23:41  2000.80.977.0     123,456  Stardds.dll      
   14-Sep-2004  23:41  2000.80.977.0     158,240  Svrnetcn.dll     
   14-Sep-2004  23:40  2000.80.977.0      76,416  Svrnetcn.exe     
   14-Sep-2004  23:41  2000.80.977.0      49,228  Ums.dll          
   14-Sep-2004  23:41  2000.80.977.0      74,304  Xplog70.dll      
   14-Sep-2004  23:41  2000.80.977.0      98,872  Xpweb70.dll
Âü°í ÆÄÀÏ Á¾¼Ó °ü°è·Î ÀÎÇØ °¡Àå ÃÖ±ÙÀÇ ÇÖÇȽº³ª ÀÌ·¯ÇÑ ÆÄÀÏÀÌ Æ÷ÇÔµÈ ±â´ÉÀ» Ãß°¡ ÆÄÀÏÀÌ µé¾î ÀÖ½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

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

ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 4¿¡¼­ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÂüÁ¶

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

¼Ó¼º

±â¼ú ÀÚ·á: 884856 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 5.3
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
Å°¿öµå:?
kbmt kbbug kbfix kbsqlserv2000presp4fix kbhotfixserver kbqfe KB884856 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

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