Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

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¸öÊý¾Ý¿â
......

sqlserver 2005»Ö¸´Êý¾ÝµÄÎÊÌâ

×î½üÊý¾Ý¿â±»¸Ä£¬Ï뽫֮»Ö¸´µ½ÉÏÖÜǰµÄÊý¾Ý£¬¿ÉÒÔŪÂð£¿
×Ô¼ºÃ»ÓÐÈ¥±¸·Ý¡£
try:
Log Explorer

http://download.csdn.net/source/620271

ѹËõ°üÀïÓÐÒ»¸ö×¢²á»ú£¬ÓÃÀ´²úÉú×¢²áÂë¡£

´ò¿ªlo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ