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
Ïà¹ØÎÊ´ð£º
Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
......
±ÈÈç ´«½øÀ´µÄ×Ö·û´®ÊÇ ¡®12/sep/2009 12£º52£º20¡¯ Ö±½ÓÓÃcast»á±¨´í¡£
¶øÇÒÖмäµÄÔ·ÝÒ²²»¹Ì¶¨ ¡£Ôõôת»»³ÉÈÕÆÚÐ͵ÄÄØ
ÓÃÒ»¸ö±í¼Ç¼1-12Ô·ݣ¡
Ö±½Óת»»ÊDz»ÐÐÁË ²ð·Ö ³öÔÂÀ´ÅжÏÁË
¡®12/sep/2009 12£º ......
ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..
ÕâÀï¾ÍÊÇ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ÎÒÒ²ÏëÕÒÕâô¸öȺ
.
SQL code:
¡£¡£¡£¡£¡£
¡£
ºÇºÇ
ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ͬÒâ
發錯° ......
sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.
Ö»¸øSELECT ,
UPDATEµÄÖ»¸øÄ³Ð©±í
¸ö²»»á
µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã
Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
×î½üÊý¾Ý¿â±»¸Ä£¬Ï뽫֮»Ö¸´µ½ÉÏÖÜǰµÄÊý¾Ý£¬¿ÉÒÔŪÂð£¿
×Ô¼ºÃ»ÓÐÈ¥±¸·Ý¡£
try:
Log Explorer
http://download.csdn.net/source/620271
ѹËõ°üÀïÓÐÒ»¸ö×¢²á»ú£¬ÓÃÀ´²úÉú×¢²áÂë¡£
´ò¿ªlo ......