Óû§saµÇ¼ʧ°Ü,¸ÃÓû§Óë¿ÉÐÅsql serverÁ¬½ÓÎÞ¹ØÁª
Õâ¸öÓпÉÄÜÊÇÄãÔÚ°²×°SQL SERVER2005µÄʱºòÑé֤ģʽûÓÐÉèÖúÃ.
1.Ñ¡ÖзþÎñÆ÷(ÓÒ¼ü)->ÊôÐÔ->°²È«ÐÔ->·þÎñÆ÷Éí·ÝÑéÖ¤ÐÞ¸ÄΪ"SQL SERVERºÍWINDOWSÉí·ÝÑé֤ģʽ"
2.Õ¹¿ª·þÎñÆ÷ÉϵÄ"°²È«ÐÔ"->µÇ½Ãû->Ñ¡ÖÐSAµÇ½ÕʺÅ(ÓÒ¼ü)->״̬->µÇ½ÐÞ¸ÄΪÆôÓÃ.
°²×°ÍêSQL Serverºó,¿ÉÒÔÓÃWindowsÉí·ÝÈÏÖ¤µÇ¼,¾ÍÊDz»ÄÜÓÃsaÕË»§µÇ¼
½â¾ö²½Öè:1)½«µÇ¼·½Ê½ÉèΪ"»ìºÏÈÏÖ¤"(ÓÒ»÷·þÎñÆ÷->Ñ¡Ôñ"°²È«ÐÔ"->µãÑ¡"Sql Server"ºÍWindowsÉí·ÝÈÏ֤ģʽ)
2)ÉèÖÃsaÕË»§(Êý¾Ý¿â->°²È«ÐÔ(ÓëÉÏÃæµÄ²»ÊÇͬһ¸ö,Õâ¸ö²»ÓÃÓÒ»÷)->µÇ¼Ãû->saÕË»§->ÉèÖÃÃÜÂë->Óû§Ó³Éä->Ó³Éäµ½ÄãµÄÊý¾Ý¿â
Èç¹ûÔÚ°²×°¹ý³ÌÖÐÑ¡Ôñ¡°Windows Éí·ÝÑé֤ģʽ¡±£¬Ôò sa µÇ¼½«±»½ûÓá£Èç¹ûÉÔºó½«Éí·ÝÑé֤ģʽ¸ü¸ÄΪ¡°SQL Server ºÍ Windows Éí·ÝÑé֤ģʽ¡±£¬Ôò sa µÇ¼ÈÔ´¦ÓÚ½ûÓÃ״̬¡£ÈôÒªÆôÓà sa µÇ¼£¬ÇëʹÓà ALTER LOGIN ÃüÁî¡£
sa µÇ¼ֻÄÜʹÓà SQL Éí·ÝÑéÖ¤Á¬½Óµ½·þÎñÆ÷¡£
ÔÚ SQL Server Management Studio ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷·þÎñÆ÷£¬ÔÙµ¥»÷¡°ÊôÐÔ¡±¡£
ÔÚ¡°°²È«ÐÔ¡±Ò³Éϵġ°·þÎñÆ÷Éí·ÝÑéÖ¤¡±Ï£¬Ñ¡ÔñеķþÎñÆ÷Éí·ÝÑé֤ģʽ£¬ÔÙµ¥»÷¡°È·¶¨¡±¡£
ÔÚ SQL Server Management Studio ¶Ô»°¿òÖУ¬µ¥»÷¡°È·¶¨¡±ÒÔÈ·ÈÏÐèÒªÖØÐÂÆô¶¯ SQL Server¡£
ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷ÄúµÄ·þÎñÆ÷£¬ÔÙµ¥»÷¡°ÖØÐÂÆô¶¯¡±¡£Èç¹ûÔËÐÐÓÐ SQL Server ´úÀí£¬ÔòÒ²±ØÐ뽫ÆäÖØÐÂÆô¶¯¡£
Ö´ÐÐÏÂÁÐÓï¾äÒÔÆôÓà sa ÃÜÂë²¢·ÖÅäÒ»¸öÃÜÂë¡£
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = ' <password>' ;
GO
Ïà¹ØÎĵµ£º
MSSQL»¹ÔÊý¾Ý¿âʧ°Ü£¬ÌáʾÈçÏ£º »¹Ô¶ÔÓë·þÎñÆ÷ ʧ°Ü¡£(Microsoft.SqlServer.Smo) ÆäËüÐÅÏ¢£º ©§ ©»¡úÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÒì³£¡££¨Microsoft.SqlServer.ConnectionsInfo£© ©§ ©»¡ú²»ÄÜÑ¡ÔñÎļþ»òÎļþ×é¡°¡¡¡±ÓÃÓڴ˲Ù×÷¡£ RESTORE DATABASE ÕýÔÚÒì³£ÖÕÖ¹¡££¨Microsoft SQL Server, ´íÎó£º3219£© ³öÏÖ´Ë ......
Ò»¡¢PowerDesignerÉú³ÉsqlÎÊÌâ
Éú³ÉsqlµÄ·½·¨ÊÇ Database -->Generate Database (Ctrl + G ) µ«ÊÇÌáʾ Could not load VBScript engine.
Check VBScript installation. Generation aborted due to errors detected during the verification of the model. ¼ì²éÁ˺þà ·¢ÏÖ½«check model È¥µô¾Í¿ÉÒÔÁË£¡ÆäÖУ¬ o ......
1. ¶¨ÒåÓα궨Òå
ÓαêÓï¾äµÄºËÐÄÊǶ¨ÒåÁËÒ»¸öÓαê±êʶÃû£¬²¢°ÑÓαê±êʶÃûºÍÒ»¸ö²éѯÓï¾ä¹ØÁªÆðÀ´¡£DECLAREÓï¾äÓÃÓÚÉùÃ÷Óα꣬Ëüͨ¹ýSELECT²éѯ¶¨ÒåÓαê´æ´¢µÄÊý¾Ý¼¯ºÏ¡£Óï¾ä¸ñʽΪ£º
DECLARE ÓαêÃû³Æ [INSENSITIVE] [SCROLL]
CURSOR FOR selectÓï¾ä
[FOR{READ ONLY|UPDATE[OF ÁÐÃû×Ö±í]}]
²ÎÊý˵Ã÷£º
INSENSITIVEÑ¡Ï ......
SQL Server 2005Éý¼¶µÄ10¸öÀíÓÉ
¡¡ºÜ¶àÈ˹ØÐĵĺ͵£ÐĵĶ¼ÊÇ SQL Server 2005 Ïà¶ÔËüµÄÇ°°æ±¾SQL Server 2000Ëù×öµÄÖØ´ó¸Ä½ø»òÐÂÔö¹¦ÄÜ¡£ÔÚÎÒÉý¼¶µ½SQL2005Ö®ºó£¬²»µÃ²»ËµµÄ£ºÄãÒ²ÖµµÃÓµÓС£(Ì×ÓÃÒ»¾ä¹ã¸æÓºÇºÇ)
¡¡¡¡ÎÒ×ܽáÁËһϸöÈËÈÏΪSQL Server 2005 ÖÐ×îÖµµÃÄãΪ֮Éý¼¶µÄ10 ¸öÀíÓÉ¡£ÎÞÂÛÄãÊÇÏëÁ˽â»òѧϰSQL Se ......
ÔÚSQL SERVERÖУ¬ÓÐʱÐèÒªºÏ¶àÁÐÖµµ½ÐеÄÐèÇ󣬳£¼ûµÄ·½·¨ÓУº1.´´½¨×Ô¶¨Ò庯Êý£¬2.ʹÓÃÓα귨½øÐÐ×Ö·û´®ºÏ²¢¡£3.ʹÓÃÁÙʱ±íʵÏÖ×Ö·û´®ºÏ²¢¡£ Êý¾Ý£º DEPTNO EMPS
------ ----------
10 CLARK
10 KING
10 MILLER
20 SMITH
20 ADAMS
20 FORD
20 SCOTT
20 JONES
30 ALLEN
30 BLAKE
30 MARTIN
30 JAMES
30 ......