Óû§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
Ïà¹ØÎĵµ£º
Questions
I have a simple app that
uses an SQL Express 2005 database. When the user closes the app, I want
to give the option to back up the database by making a copy in another
directory. However, when I try to do it, I get "The process cannot
access the file '...\Pricing.MDF' because i ......
²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâ ......
´Ósql server 2000Éý¼¶µ½2005ÓÐ5ÖÖ·½·¨:
lÖ±½ÓÉý¼¶
lÀûÓÃdetach/attach¹¦ÄÜÒƶ¯sql server 2000µÄÊý¾Ý¿âµ½2005
lͨ¹ýbackup/restore¹¦ÄÜÀ´Ç¨ÒÆdb
lͨ¹ýsql server 2005µÄdatabase copy wizardÀ´¿½±´Êý¾Ý¿â
lͨ¹ýdtsµÄexport/import¹¤¾ßÀ´Ç¨ÒÆÊý¾Ýµ½sql server 2005
1.µÚÒ»ÖÖ·½·¨(Ö±½ÓÉý¼¶):
ÊʺÏ: Êý¾Ý ......
ÔÚ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 ......
value·½·¨
µ±Äã²»Ïë½âÊÍÕû¸ö²éѯµÄ½á¹û¶øÖ»ÏëµÃµ½Ò»¸ö±êÁ¿ÖµÊ±£¬Õâ¸övalue·½·¨ÊǺÜÓаïÖúµÄ¡£Õâ¸övalue·½·¨ÓÃÓÚ²éѯXML²¢ÇÒ·µ»ØÒ»¸öÔ×ÓÖµ¡£
Õâ¸övalue·½·¨µÄÓï·¨ÈçÏ£º
value(XQuery£¬datatype)
½èÖúÓÚvalue·½·¨£¬Äã¿ÉÒÔ´ÓXMLÖеõ½µ¥¸ö±êÁ¿Öµ¡£Îª´Ë£¬Äã±ØÐëÖ¸¶¨XQueryÓï¾äºÍÄãÏëÒªËü·µ»ØµÄÊý¾ÝÀàÐÍ£¬²¢ÇÒÄã¿ÉÒÔ·µ»Ø³ ......