SQL SERVERµÄÈÕÖ¾²éѯ¼°Undo
Çó½Ì¸÷λDBA´ó´ó£¬ÄãÃÇÈÕ³£¹¤×÷ÖÐÈçºÎ²é¿´ÊÂÎñÈÕÖ¾£¬ÔÚÓÐÈ˸ÉÁË»µÊºóÈçºÎ×·×Ùµ½ÔðÈÎÈË£¬ÈçºÎ»Ø¹öÕâЩÊÂÎñ£¿ ÎÒÔÚLumigent¹ÙÍøÉÏÒѾÕÒ²»µ½ÈκÎLog ExploreµÄÐÅÏ¢£¬´úÀíÉ̵ÄÍøÕ¾ÉÏÒ²Ö»ÓÐÕë¶Ôsql server 7.0 ºÍsql server 2000 sp2µÄ°æ±¾¡£ ÎÒÆ½Ê±ÓÃLog Explore for sql server 2005µÄÆÀ¹À°æ£¬²»ÊÇÄÇôºÃÓ㬶øÇÒËæ×ÅÊý¾Ý¿âµÄ°æ±¾²»¶ÏÉý¼¶£¬Ò²ÎÞ·¨ÔÙ¼ÌÐøÊ¹ÓÃÁË¡£ redgate ÓÐÒ»¿îSQL Log Rescue,²»ÖªµÀÄÄλ´ó´óÓùý£¬×îºÃÊÇÕýʽ°æ£¬Ì¸Ò»Ï¿ÉÓÃÐÔ£¬¶àл¡£ Çë¸÷λÓÐÐËȤµÄ¸½Ò»ÏÂÄúÏÖÔÚÊý¾Ý¿â°æ±¾¼°×·×Ù¹¤¾ß£¬´ó¼Ò½»Á÷ѧϰһÏ£¬Ð»Ð»¡«
ѧϰ,Õâ¶«Î÷²»¶® SQL 2005 RML·ÖÎö¹¤¾ß Êý¾Ý¿âÒýÇæÓÅ»¯¹ËÎÊ SQL SERVER PROFILER ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾ÒýÓà ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾ Õâ¸ö£¬ÄãÔõô¼Ç¼°¡£¬sql profileÒ»Ö±¿ª×Ű¡£¿ profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ¿ØÖƺÃȨÏÞÒýÓà profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ȨÏÞÊǿ϶¨Òª¿ØÖƵ쬵«ÊÇ×ܲ»ÄܱÜÃâÓÐÈËż¶ûԽȨ²Ù×÷£¬³öÁËÎÊÌâ¾ÍҪ׷¾¿ÔðÈÎÈ˰¡¡£ ÎÒÏÖÔÚÒѾ½¨Á¢ÁËÒ»Ì×Êý¾Ý¿âµÇ¼µÄ¼à¿Ø£¬·¢ÏÖÓÐÈËԽȨµÇ¼ÂíÉÏ×Ô¶¯·¢Óʼþ¾¯¸æËû¡£ µ«ÊdzöÁËÎÊÌâÒÔºóҪ׷²éÖ»ÄÜ·ÈÕÖ¾ÁË¡£ÒýÓà profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ÕâЩÊDZØÒªµÄ£¬µ«ÊDz»Äܽâ¾ö×·¾¿ÔðÈεÄÎÊÌ⣬Óû§µ
Ïà¹ØÎÊ´ð£º
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
--drop table #T1 --drop table #T2 create Table #T1(ID int, QueryID nvarchar(20), ResultID1 nvarchar(20), ResultID2 nvarchar(20)) create Table #T2(SortNo int, QueryID nvarchar(20), ResultID1 nv ......
±í id bh 1 10 2 11 3 12 4 15 5 16 6 22 7 25 8 26 9 27 10 28 ½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º 10~12£¬15~16£¬22£¬25~28 SQL code: declare @t tabl ......