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

Óû§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 


Ïà¹ØÎĵµ£º

How do I release sql express database?


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 ......

Sql Server Êý¾Ý¿âÁ¬½ÓÎÊÌâ

²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâ ......

ÈçºÎÉý¼¶sql server 2000ÖÁ2005

´Ó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 ÐÐÁÐת»»

ÔÚ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 ......

SQL Server2005µÄXMLÊý¾ÝÀàÐÍÖ®»ù´¡Æª2

value·½·¨
µ±Äã²»Ïë½âÊÍÕû¸ö²éѯµÄ½á¹û¶øÖ»ÏëµÃµ½Ò»¸ö±êÁ¿ÖµÊ±£¬Õâ¸övalue·½·¨ÊǺÜÓаïÖúµÄ¡£Õâ¸övalue·½·¨ÓÃÓÚ²éѯXML²¢ÇÒ·µ»ØÒ»¸öÔ­×ÓÖµ¡£
Õâ¸övalue·½·¨µÄÓï·¨ÈçÏ£º
value(XQuery£¬datatype)
½èÖúÓÚvalue·½·¨£¬Äã¿ÉÒÔ´ÓXMLÖеõ½µ¥¸ö±êÁ¿Öµ¡£Îª´Ë£¬Äã±ØÐëÖ¸¶¨XQueryÓï¾äºÍÄãÏëÒªËü·µ»ØµÄÊý¾ÝÀàÐÍ£¬²¢ÇÒÄã¿ÉÒÔ·µ»Ø³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ