Select the product you need help with
SP:Recompile À̺¥Æ® ÀçÄÄÆÄÀÏ ¿øÀÎÀ» È®ÀÎÇÏ´Â ¹æ¹ý±â¼ú ÀÚ·á: 308737 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. ÀÌ ÆäÀÌÁö¿¡¼¿ä¾àÀÌ ¹®¼¿¡¼´Â SP:Recompile À̺¥Æ® ÀçÄÄÆÄÀÏ ¿øÀÎÀ» ½Äº°ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. SP:Recompile À̺¥Æ® ÀçÄÄÆÄÀÏ ¿øÀÎÀ»SQL Server ÀúÀåµÈ ÇÁ·Î½ÃÀú ¶Ç´Â Æ®¸®°Å¸¦ ´Ù½Ã ÄÄÆÄÀÏÇÒ ¶§ SQL ÇÁ·ÎÇÊ·¯¿¡ SP:Recompile À̺¥Æ®¸¦ ³ªÅ¸³À´Ï´Ù. SQL Server 2000 ¼ºñ½º ÆÑ 2 (SP2) ¶Ç´Â SQL Server 2005 SP:Recompile À̺¥Æ® ÀçÄÄÆÄÀÏ, ÀçÄÄÆÄÀÏ ¹®Á¦¸¦ ÇØ°áÇÒ ¶§ À¯¿ëÇÑ ¼ÓÇØ ¹ß»ýÇÏ´Â ÀÌÀ¯¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù.SQL Server ÀúÀåµÈ ÇÁ·Î½ÃÀú ¶Ç´Â Æ®¸®°Å°¡ ½ÇÇàµÉ ¶§ SQL Server ÀúÀåµÈ ÇÁ·Î½ÃÀú ¶Ç´Â Æ®¸®°Å°¡ ¿©·¯ °¡Áö ÀÌÀ¯·Î ´Ù½Ã ÄÄÆÄÀÏÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù. SQL ÇÁ·ÎÇÊ·¯ SP:Recompile À̺¥Æ® ¶§ ÀúÀå ÇÁ·Î½ÃÀú³ª Æ®¸®°Å°¡ ÀçÄÄÆÄÀϵȴٴ °ÍÀ» º¸¿© ÁÝ´Ï´Ù. SQL Server 2000 SP2 ¶Ç´Â SQL Server 2005 SP:Recompile À̺¥Æ® EventSubClass ¿ÀÇ Á¤¼ö ÄÚµå·Î ÀçÄÄÆÄÀÏ ¿øÀÎÀ» ½Äº°ÇÕ´Ï´Ù. ÀÌÀ¯´Â ÀçÄÄÆÄÀÏ Á¤¼ö ÄÚµå ¸ñ·ÏÀº ´ÙÀ½°ú °°½À´Ï´Ù. SQL Server 2000 SP2
Integer code Reason for recompilation
-----------------------------------------------------------------------
1 Schema, bindings, or permissions changed between compile
or execute.
2 Statistics changed.
3 Object not found at compile time, deferred check to
run time.
4 Set option changed in batch.
5 Temp table schema, binding, or permission changed.
6 Remote rowset schema, binding, or permission
changed.
Integer code Reason for recompilation
-----------------------------------------------------------------------
1 Schema changed.
2 Statistics changed.
3 Recompile DNR.
4 Set option changed.
5 Temp table changed.
6 Remote rowset changed.
7 For browse perms changed.
8 Query notification environment changed.
9 MPI view changed.
10 Cursor options changed.
11 With recompile option.ÂüÁ¶Microsoft SQL Server 2000ÀÇ ÃֽŠ¼ºñ½º ÆÑ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ¼Ó¼º±â¼ú ÀÚ·á: 308737 - ¸¶Áö¸· °ËÅä: 2005³â 12¿ù 23ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 4.4 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. | ±â¼ú ÀÚ·á ¹ø¿ª
 |
À§·Î °¡±â
