Select the product you need help with
FIX: Å×ÀÌºí¿¡ SET IDENTITY_INSERT ON ¹®À» ½ÇÇàÇÏ°í SQL Server 2000 Å×ÀÌºí¿¡ ÇàÀ» »ðÀÔÇÒ ½ÃµµÇÒ ¶§ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.±â¼ú ÀÚ·á: 878501 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. # ¹ö±×: 471945 (SQL Server 8.0) ÀÌ ÆäÀÌÁö¿¡¼¹®¼ ³»¿ë¿ä¾àÀÌ ¹®¼¿¡¼´Â ´ÙÀ½À» ÀÌ ÇÖÇȽº ¸±¸®½º¿¡ ´ëÇÑ ¼³¸íÀÔ´Ï´Ù.
Çö»óMicrosoft SQL Server 2000¿¡¼ Å×ÀÌºí¿¡ ´ëÇØ SET IDENTITY_INSERT ON ¹®À» ½ÇÇàÇÑ ´ÙÀ½ ÇàÀ» ID ¿À» Æ÷ÇÔÇÏ´Â Å×ÀÌºí¿¡ »ðÀÔÇÏ·Á°í Äõ¸®¸¦ ½ÇÇàÇÒ ¶§ Å×À̺íÀÇ À̸§ÀÌ TableName °÷¿¡ ´ÙÀ½°ú À¯»çÇÑ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù. IDENTITY_INSERT OFF·Î ¼³Á¤Çϸé ' TableName ' Å×À̺íÀÇ ID ¿¿¡ ´ëÇØ ¸í½ÃÀû °ªÀ» »ðÀÔÇÒ ¼ö ¾ø½À´Ï´Ù. 290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ¿øÀÎÀÌ ¹®Á¦¸¦ Ŭ¶óÀ̾ðÆ® ij½ÃµÈ Ä¿¼°¡ Äõ¸® ¾Ê´Â ¹«È¿ÈµË´Ï´Ù ÀÖ´Â ÇàÀ» »ðÀÔÇÏ·Á°í ÇÒ ¶§ Äõ¸®°¡ OFF INDENTITY_INSERT SET ÀÌÀü ¼³Á¤À» »ç¿ëÇÏ´Â °æ¿ì¿¡ ¹ß»ýÇÕ´Ï´Ù. ÇØ°á ¹æ¹ý¼ºñ½º ÆÑ Á¤º¸ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é 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¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. Microsoft SQL Server 2000, 32ºñÆ® ¹öÀüDate Time Version Size File name ------------------------------------------------------------------ 04-Aug-2004 08:10 2000.80.967.0 664,128 Autoplt.dll 04-Aug-2004 08:10 2000.80.967.0 78,400 Console.exe 04-Aug-2004 08:10 2000.80.967.0 315,968 Custtask.dll 04-Aug-2004 08:10 2000.80.967.0 33,340 Dbmslpcn.dll 08-Apr-2004 13:42 786,432 Distmdl.ldf 08-Apr-2004 13:42 2,359,296 Distmdl.mdf 10-Oct-2003 10:48 180 Drop_repl_hotfix.sql 04-Aug-2004 08:10 2000.80.967.0 1,905,216 Dtspkg.dll 04-Aug-2004 08:10 2000.80.967.0 528,960 Dtspump.dll 04-Aug-2004 08:10 2000.80.967.0 1,557,052 Dtsui.dll 04-Aug-2004 08:10 2000.80.967.0 639,552 Dtswiz.dll 10-Oct-2003 10:48 747,927 Instdist.sql 10-Oct-2003 10:48 1,581 Inst_repl_hotfix.sql 04-Aug-2004 08:10 2000.80.967.0 352,828 Isqlw.exe 04-Aug-2004 08:10 2000.80.967.0 82,492 Itwiz.exe 04-Aug-2004 08:10 2000.80.967.0 90,692 Msgprox.dll 19-May-2004 15:43 8.11.40209.0 209,408 Mssdi98.dll 04-Aug-2004 08:10 2000.80.967.0 62,024 Odsole70.dll 04-Aug-2004 08:11 2000.80.967.0 25,144 Opends60.dll 04-Aug-2004 08:10 2000.80.967.0 57,904 Osql.exe 04-Aug-2004 08:10 2000.80.967.0 279,104 Pfutil80.dll 10-Oct-2003 10:37 550,780 Procsyst.sql 08-Apr-2004 13:42 12,305 Qfe469315.sql 08-Apr-2004 13:42 19,195 Qfe469571.sql 03-Aug-2004 16:13 1,105,167 Replmerg.sql 04-Aug-2004 08:10 2000.80.967.0 221,768 Replprov.dll 04-Aug-2004 08:10 2000.80.967.0 307,784 Replrec.dll 03-Aug-2004 16:21 2000.80.967.0 159,813 Replres.rll 10-Oct-2003 10:48 1,087,150 Replsys.sql 10-Oct-2003 10:48 986,603 Repltran.sql 04-Aug-2004 08:10 2000.80.967.0 287,304 Rinitcom.dll 04-Aug-2004 08:10 2000.80.967.0 78,416 Sdiclnt.dll 04-Aug-2004 08:10 2000.80.967.0 66,112 Semmap.dll 04-Aug-2004 08:10 2000.80.967.0 57,916 Semnt.dll 04-Aug-2004 08:10 2000.80.967.0 492,096 Semobj.dll 03-Aug-2004 16:48 2000.80.967.0 172,032 Semobj.rll 04-Aug-2004 08:10 2000.80.967.0 53,832 Snapshot.exe 13-Jul-2004 12:59 117,834 Sp3_serv_uni.sql 04-Aug-2004 08:09 2000.80.967.0 28,672 Sqlagent.dll 04-Aug-2004 08:10 2000.80.967.0 311,872 Sqlagent.exe 04-Aug-2004 08:09 2000.80.967.0 168,001 Sqlakw32.dll 04-Aug-2004 08:10 2000.80.967.0 33,344 Sqlctr80.dll 04-Aug-2004 08:10 2000.80.967.0 4,215,360 Sqldmo.dll 04-Aug-2004 08:10 25,172 Sqldumper.exe 03-Aug-2004 16:11 2000.80.967.0 28,672 Sqlevn70.rll 04-Aug-2004 08:10 2000.80.967.0 156,224 Sqlmaint.exe 04-Aug-2004 08:10 2000.80.967.0 180,792 Sqlmap70.dll 04-Aug-2004 08:10 2000.80.967.0 188,992 Sqlmmc.dll 03-Aug-2004 16:53 2000.80.967.0 479,232 Sqlmmc.rll 04-Aug-2004 08:10 2000.80.967.0 401,984 Sqlqry.dll 04-Aug-2004 08:10 2000.80.967.0 57,920 Sqlrepss.dll 04-Aug-2004 08:10 2000.80.967.0 7,581,777 Sqlservr.exe 04-Aug-2004 08:10 2000.80.967.0 590,396 Sqlsort.dll 04-Aug-2004 08:10 2000.80.967.0 45,644 Sqlvdi.dll 04-Aug-2004 08:10 2000.80.967.0 106,588 Sqsrvres.dll 04-Aug-2004 08:10 2000.80.967.0 33,340 Ssmslpcn.dll 04-Aug-2004 08:10 2000.80.967.0 82,492 Ssnetlib.dll 04-Aug-2004 08:10 2000.80.967.0 25,148 Ssnmpn70.dll 04-Aug-2004 08:10 2000.80.967.0 123,456 Stardds.dll 04-Aug-2004 08:10 2000.80.967.0 158,240 Svrnetcn.dll 04-Aug-2004 08:10 2000.80.967.0 76,416 Svrnetcn.exe 04-Aug-2004 08:10 2000.80.967.0 49,228 Ums.dll 04-Aug-2004 08:10 2000.80.967.0 98,872 Xpweb70.dll Microsoft SQL Server 2000 64ºñÆ® ¹öÀüDate Time Version Size File name Platform ----------------------------------------------------------------------------- 04-Aug-2004 15:23 2000.80.967.0 56,832 Dbmslpcn.dll IA-64 08-Apr-2004 13:42 786,432 Distmdl.ldf 08-Apr-2004 13:42 2,359,296 Distmdl.mdf 10-Oct-2003 10:48 180 Drop_repl_hotfix.sql 04-Aug-2004 15:22 2000.80.967.0 528,960 Dtspump.dll x86 10-Oct-2003 10:48 747,927 Instdist.sql 10-Oct-2003 10:48 1,581 Inst_repl_hotfix.sql 04-Aug-2004 15:23 2000.80.967.0 185,856 Msgprox.dll IA-64 19-May-2004 15:43 8.11.40517.0 722,944 Mssdi98.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 150,528 Odsole70.dll IA-64 04-Aug-2004 15:24 2000.80.967.0 27,136 Opends60.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 148,992 Osql.exe IA-64 10-Oct-2003 10:37 550,780 Procsyst.sql 08-Apr-2004 13:42 12,305 Qfe469315.sql 08-Apr-2004 13:42 19,195 Qfe469571.sql 03-Aug-2004 16:13 1,105,167 Replmerg.sql 04-Aug-2004 15:23 2000.80.967.0 534,016 Replprov.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 769,536 Replrec.dll IA-64 04-Aug-2004 08:33 2000.80.967.0 146,432 Replres.rll 10-Oct-2003 10:48 1,087,150 Replsys.sql 10-Oct-2003 10:48 986,603 Repltran.sql 04-Aug-2004 15:23 2000.80.967.0 650,240 Rinitcom.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 160,768 Semmap.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 132,608 Semnt.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 89,088 Snapshot.exe IA-64 13-Jul-2004 12:59 117,834 Sp3_serv_uni.sql 04-Aug-2004 15:22 2000.80.967.0 10,240 Sqlagent.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 1,055,232 Sqlagent.exe IA-64 04-Aug-2004 15:23 2000.80.967.0 32,256 Sqlctr80.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 13,845,504 Sqldmo.dll IA-64 04-Aug-2004 15:23 39,936 Sqldumper.exe IA-64 04-Aug-2004 08:16 2000.80.967.0 19,968 Sqlevn70.rll 04-Aug-2004 15:23 2000.80.967.0 493,568 Sqlmaint.exe IA-64 04-Aug-2004 15:23 2000.80.967.0 23,040 Sqlmap70.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 152,064 Sqlrepss.dll IA-64 04-Aug-2004 15:24 2000.80.967.0 24,981,504 Sqlservr.exe IA-64 04-Aug-2004 15:23 2000.80.967.0 616,960 Sqlsort.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 120,320 Sqlvdi.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 227,328 Sqsrvres.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 53,760 Ssmslpcn.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 254,976 Ssnetlib.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 20,992 Ssnmpn70.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 430,080 Svrnetcn.dll IA-64 04-Aug-2004 15:23 2000.80.967.0 185,856 Svrnetcn.exe IA-64 04-Aug-2004 15:23 2000.80.967.0 187,392 Xpweb70.dll IA-64 ÇöÀç »óÅÂMicrosoft´Â "º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿µÈ Á¦Ç°¿¡¼ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 4¿¡¼ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. ÂüÁ¶Microsoft SQL Server ¾÷µ¥ÀÌÆ®¸¦ ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 822499 Ãâ½Ã ÀÌÈÄ¿¡ ¼ÒÇÁÆ®¿þ¾î¸¦ ¼öÁ¤ÇÒ ¶§ Microsoft¿¡¼ »ç¿ëÇÏ´Â ¿ë¾î¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/kb/822499/
)
»õ ¸í¸í ½ºÅ°¸¶¿¡ Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ëÇÑ 824684
(http://support.microsoft.com/kb/824684/
)
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í¼Ó¼º±â¼ú ÀÚ·á: 878501 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 2.3 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. |
À§·Î °¡±â
