Select the product you need help with
FIX: SQL Server 2000ÀÇ Æ®¸®°Å¸¦ Æ÷ÇÔÇÏ´Â Å×À̺íÀÇ ¹®À» ½ÇÇàÇÒ ¶§ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯±â¼ú ÀÚ·á: 884855 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. ÀÌ ÆäÀÌÁö¿¡¼¹®¼ ³»¿ë¿ä¾àÀÌ ¹®¼¿¡¼´Â ´ÙÀ½À» ÀÌ ÇÖÇȽº ¸±¸®½º¿¡ ´ëÇÑ ¼³¸íÀÔ´Ï´Ù.
Çö»óMicrosoft SQL Server 2000 ¼ºñ½º ÆÑ 3 (SP3) ÇÖÇȽº ºôµå 8.00.818 ¶Ç´Â ³ªÁß¿¡ ºôµå Å×À̺íÀÇ ¾÷µ¥ÀÌÆ® ¹®, »ðÀÔ ¹®ÀÌ ¶Ç´Â »èÁ¦ ¹®¿¡ ½ÇÇàÇÏ·Á°í ÇÒ ¶§ Å×ÀÌºí¿¡ Æ®¸®°Å¸¦ ¼º°øÇÏÁö ¸øÇÕ´Ï´Ù. (yourTrigger Æ®¸®°Å ¹× xx ÁÙ ¹øÈ£¸¦ À̸§Àº À§Ä¡) ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù. ¼¹ö: Msg 311, ¼öÁØ 16, »óÅ 2, ÇÁ·Î½ÃÀú yourTrigger, ¼± xx ÅؽºÆ®, ntext ¶Ç´Â image ¿¿¡ '»ðÀÔµÈ' ¹× '»èÁ¦' Å×À̺íÀ» »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. ÇØ°á ¹æ¹ý¼ºñ½º ÆÑ Á¤º¸ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼ È®ÀÎÇϽʽÿÀ:290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ÇÖÇȽº Á¤º¸ÀüÁ¦ Á¶°ÇÀÌ ÇÖÇȽº¸¦ ¼³Ä¡Çϱâ Àü¿¡ SQL Server 2000 ¼ºñ½º ÆÑ 3À» ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.Á¤º¸¸¦ ´Ù½ÃÇÕ´Ï´ÙÀÌ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ¿¡´Â ÄÄÇ»Å͸¦ ´Ù½Ã ½ÃÀÛÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.Âü°í SQL Server ÇÖÇȽº ¼³Ä¡¸¦ SQL Server ¼ºñ½º¸¦ ÁßÁöÇÕ´Ï´Ù. ÇÖÇȽº ÆÄÀÏ Á¤º¸ÀÌ ÇÖÇȽº¿¡´Â ÀÌ ¹®¼¿¡ ³ª¿Í ÀÖ´Â ¹®Á¦¸¦ ÇØ°áÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀϸ¸ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ ÇÖÇȽº¿¡´Â Á¦Ç°À» ÃֽŠºôµå·Î ¿ÏÀüÈ÷ ¾÷µ¥ÀÌÆ®ÇÏ´Â µ¥ ÇÊ¿äÇÑ ÆÄÀÏÀÌ ¾øÀ» ¼ö ÀÖ½À´Ï´Ù.ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. Date Time Version Size File name ------------------------------------------------------------------- 18-Aug-2004 01:55 2000.80.970.0 664,128 Autoplt.dll 18-Aug-2004 01:55 2000.80.970.0 78,400 Console.exe 18-Aug-2004 01:55 2000.80.970.0 332,352 Ctasksui.dll 18-Aug-2004 01:55 2000.80.970.0 315,968 Custtask.dll 18-Aug-2004 01:55 2000.80.970.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 18-Aug-2004 01:55 2000.80.970.0 1,905,216 Dtspkg.dll 18-Aug-2004 01:55 2000.80.970.0 528,960 Dtspump.dll 18-Aug-2004 01:55 2000.80.970.0 1,557,052 Dtsui.dll 18-Aug-2004 01:55 2000.80.970.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 18-Aug-2004 01:55 2000.80.970.0 352,828 Isqlw.exe 18-Aug-2004 01:55 2000.80.970.0 82,492 Itwiz.exe 18-Aug-2004 01:55 2000.80.970.0 90,692 Msgprox.dll 19-May-2004 23:43 8.11.40209.0 209,408 Mssdi98.dll 18-Aug-2004 01:55 2000.80.970.0 62,024 Odsole70.dll 18-Aug-2004 01:56 2000.80.970.0 25,144 Opends60.dll 18-Aug-2004 01:55 2000.80.970.0 57,904 Osql.exe 18-Aug-2004 01:55 2000.80.970.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 18-Aug-2004 00:26 5,155 Qfe472197.sql 18-Aug-2004 01:55 2000.80.970.0 143,940 Qrdrsvc.exe 18-Aug-2004 02:16 1,105,167 Replmerg.sql 18-Aug-2004 01:55 2000.80.970.0 221,768 Replprov.dll 18-Aug-2004 01:55 2000.80.970.0 307,784 Replrec.dll 18-Aug-2004 00:46 2000.80.970.0 159,813 Replres.rll 18-Aug-2004 00:26 1,086,925 Replsys.sql 10-Oct-2003 18:48 986,603 Repltran.sql 18-Aug-2004 01:55 2000.80.970.0 287,304 Rinitcom.dll 18-Aug-2004 01:55 2000.80.970.0 78,416 Sdiclnt.dll 18-Aug-2004 01:55 2000.80.970.0 66,112 Semmap.dll 18-Aug-2004 01:55 2000.80.970.0 57,916 Semnt.dll 18-Aug-2004 01:55 2000.80.970.0 492,096 Semobj.dll 18-Aug-2004 01:20 2000.80.970.0 172,032 Semobj.rll 18-Aug-2004 01:55 2000.80.970.0 53,832 Snapshot.exe 13-Jul-2004 20:59 117,834 Sp3_serv_uni.sql 18-Aug-2004 01:54 2000.80.970.0 28,672 Sqlagent.dll 18-Aug-2004 01:55 2000.80.970.0 311,872 Sqlagent.exe 18-Aug-2004 01:54 2000.80.970.0 168,001 Sqlakw32.dll 18-Aug-2004 01:55 2000.80.970.0 33,344 Sqlctr80.dll 18-Aug-2004 01:55 2000.80.970.0 4,215,360 Sqldmo.dll 18-Aug-2004 01:55 25,172 Sqldumper.exe 18-Aug-2004 00:35 2000.80.970.0 28,672 Sqlevn70.rll 18-Aug-2004 01:55 2000.80.970.0 156,224 Sqlmaint.exe 18-Aug-2004 01:55 2000.80.970.0 180,792 Sqlmap70.dll 18-Aug-2004 01:55 2000.80.970.0 188,992 Sqlmmc.dll 18-Aug-2004 01:15 2000.80.970.0 479,232 Sqlmmc.rll 18-Aug-2004 01:55 2000.80.970.0 401,984 Sqlqry.dll 18-Aug-2004 01:55 2000.80.970.0 57,920 Sqlrepss.dll 18-Aug-2004 01:55 2000.80.970.0 7,581,777 Sqlservr.exe 18-Aug-2004 01:55 2000.80.970.0 590,396 Sqlsort.dll 18-Aug-2004 01:55 2000.80.970.0 45,644 Sqlvdi.dll 18-Aug-2004 01:55 2000.80.970.0 106,588 Sqsrvres.dll 18-Aug-2004 01:55 2000.80.970.0 33,340 Ssmslpcn.dll 18-Aug-2004 01:55 2000.80.970.0 82,492 Ssnetlib.dll 18-Aug-2004 01:55 2000.80.970.0 25,148 Ssnmpn70.dll 18-Aug-2004 01:55 2000.80.970.0 123,456 Stardds.dll 18-Aug-2004 01:55 2000.80.970.0 158,240 Svrnetcn.dll 18-Aug-2004 01:55 2000.80.970.0 76,416 Svrnetcn.exe 18-Aug-2004 01:55 2000.80.970.0 49,228 Ums.dll 18-Aug-2004 01:55 2000.80.970.0 98,872 Xpweb70.dll ÇöÀç »óÅÂMicrosoft´Â "º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿µÈ Á¦Ç°¿¡¼ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 4¿¡¼ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. Ãß°¡ Á¤º¸ÀÌÀü ÇÖÇȽº ¸ñ·ÏÀ» "Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 3 ¶Ç´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 3a ÇÖÇȽº¸¦" ¼½¼Ç¿¡¼ Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 290211 Microsoft SQL Server ¾÷µ¥ÀÌÆ®¸¦ ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý 822499 ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/kb/822499/
)
»õ ¸í¸í ½ºÅ°¸¶¿¡ Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ëÇÑ 824684
(http://support.microsoft.com/kb/824684/
)
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í ¼Ó¼º±â¼ú ÀÚ·á: 884855 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 2.3 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. |
À§·Î °¡±â
