Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlserver sp1 °²×°Ê±Ê§°ÜÎÊÌ⣬sp2Ò²ÊÇÒ»Ñù

°²×°Ê±Í¨¹ýWindows Éí·ÝÑé֤ʱ ÌáʾÎÞЧµÄµÇ¼ÐÅÏ¢£¬Ò»¸ö»ò¶à¸öʵÀýδͨ¹ýÑéÖ¤¡£
µ«ÊÇÎÒͨ¹ýSQL Server Management StudioÈ´¿ÉÒÔͨ¹ýWindows Éí·ÝÑéÖ¤³É¹¦µÇ½¡£¡£¡£

°²×°sp2ʱҲÊÇÒ»ÑùµÄ¡£¡£
Çó¸ßÊÖ°ïæ£¡£¡¶¼»¨ÁËÒ»Ììʱ¼äÁË£¡
²»¶®Ñ§Ï°

զûÓÐÈËÖªµÀÄØ£¿Î¢ÈíµÄÎÊÌâÓ¦¸ÃºÜ¶àµÄ£¬Ò²ÓкܶàÈËÖªµÀµÄ°¡£¿·Ö²»¹»Ã´£¿ÎÒÔÙ¼Ó£¡£¡£¡

×Ô¼º¶¥Ò»Ï£¡



ÕâÖÖÎÊÌâÓпÉÄÜÊÇosµÄÎÊÌâ,½¨Òé֨װos

http://blog.csdn.net/fredrickhu/archive/2009/09/23/4585998.aspx

¿´¿´SQL 2005°²×°ÎÊÌâ»ã×Ü

ѧϰһÏÂ


ÁíÍ⣬Äã¿ÉÒÔ³¢ÊÔÒ»ÏÂʹÓà SQL Éí·ÝÑéÖ¤£¬Ê¹Óà SA µÇ½ÕË»§Á¬½Óµ½Òª¸üеÄʵÀý¡£

´íÎóÐÅÏ¢Ó¦¸Ã´æ´¢ÔÚ %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HOTFIX.LOG ÎļþÖС£

10/15/2009 18:15:29.328 Authenticating user using Windows Authentication
10/15/2009 18:15:29.375 SQL Service MSSQLServer was previously running, ready for authentication
10/15/2009 18:15:29.437 SQL Agent Service SQLSERVERAGENT was not previously running
10/15/2009 18:15:29.609 Authenticating user using Windows Authentication
10/15/2009 18:15:29.640 Validating database connections using Windows Authentication
10/15/2009 18:15:29.812 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:15:29.984 Received sysadmin status for instance: MSSQLSERVER
10/15/2009 18:15:30.015 Validating database connections using Windows Authentication
1


Ïà¹ØÎÊ´ð£º

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

sqlserver 2005 ¹ØÓÚÈÕÆÚ¸ñʽ

±ÈÈç ´«½øÀ´µÄ×Ö·û´®ÊÇ ¡®12/sep/2009 12£º52£º20¡¯ Ö±½ÓÓÃcast»á±¨´í¡£
¶øÇÒÖмäµÄÔ·ÝÒ²²»¹Ì¶¨ ¡£Ôõôת»»³ÉÈÕÆÚÐ͵ÄÄØ
ÓÃÒ»¸ö±í¼Ç¼1-12Ô·ݣ¡

Ö±½Óת»»ÊDz»ÐÐÁË ²ð·Ö ³öÔÂÀ´ÅжÏÁË

¡®12/sep/2009 12£º ......

ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ

ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..

ÕâÀï¾ÍÊÇ

ÕâÀï±ÈQQȺÀïÈÈÄÖ

ÎÒÒ²ÏëÕÒÕâô¸öȺ

.

SQL code:
¡£¡£¡£¡£¡£

¡£

ºÇºÇ

ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ


ͬÒâ

發錯° ......

sqlserver¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.

Ö»¸øSELECT ,

UPDATEµÄÖ»¸øÄ³Ð©±í

¸ö²»»á

µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã

Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ