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

SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí

SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓëDOX/UNIX¼æÈݲ¢Ö§³ÖÖ±½Óµ÷ÓÃ.NETÄ£¿é×öÐÐÃüÁî±à¼­£¬ÊǷdz£ÖµµÃÉîÈëÑо¿µÄ¹¤¾ß£¨ÔÚSQL2008°²×°Ê±»á×Ô¶¯¸üа²×°£©
3. ÐèҪȷ±£Windows InstallerµÄ³É¹¦Æô¶¯£¬ÐèÒª4.5ÒÔÉÏ°æ±¾£¨ÐèÒª¼ì²é·þÎñÆô¶¯×´Ì¬service.msc)
4. ÐèÒªMDAC2.8 sp1µÄÖ§³Ö£¨XPÒÔÉÏϵͳÖÐÒѼ¯³É£©
5. Èô»úÆ÷ÉÏÒѾ­°²×°Visual studio 2008ÔòÐèÒªVS 2008 sp1ÒÔÉÏ°æ±¾µÄÖ§³Ö
±È½ÏÁ½¸öÊý¾Ý¿â±í½á¹¹µÄ²îÒì
========================
http://www.itwis.com/html/database/sqlserver/20090902/5907.html
ͼ½â¾Û´ØË÷ÒýÓë·Ç¾Û´ØË÷ÒýµÄÇø±ð¼°ÆäÓÅ»¯²éѯ
==============================
http://www.itwis.com/html/database/sqlserver/20090611/4602.html
named pipes
==============================================
"ÃüÃû¹ÜµÀ"»ò"ÃüÃû¹ÜÏß"(Named Pipes)ÊÇÒ»ÖÖ¼òµ¥µÄ½ø³Ì¼äͨÐÅ(I P C)»úÖÆ,
Microsoft Windows NT,Windows 2000,Windows 95ÒÔ¼°Windows 98¾ùÌṩÁ˶ÔËüµÄÖ§³Ö
(µ«²»°üÀ¨Windows CE).ÃüÃû¹ÜµÀ¿ÉÔÚͬһ̨¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,»òÔÚ¿çÔ½Ò»¸öÍøÂçµÄ
²»Í¬¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,Ö§³Ö¿É¿¿µÄ,µ¥Ïò»òË«ÏòµÄÊý¾ÝͨÐÅ.
ÃüÃû¹ÜµÀÓë   TCP/IP   Ì×½Ó×Ö  
  ÔÚ¿ìËÙ¾ÖÓòÍø   (LAN)   »·¾³ÖУ¬´«Êä¿ØÖÆЭÒé»ò   Internet   ЭÒé   (TCP/IP)   Ì×½Ó×Ö¿Í»§¶ËºÍÃüÃû¹ÜµÀ¿Í»§¶ËÔÚÐÔÄÜ·½Ãæ²»ÏàÉÏÏ¡£µ«ÊÇ£¬ÍøÂçËÙ¶ÈÔ½Âý£¨ÈçÔÚ¹ãÓòÍø   (WAN)   »ò²¦ºÅÍøÂçÉÏ£©£¬TCP/IP   Ì×½Ó×Ö¿Í»§¶ËÓëÃüÃû¹ÜµÀ¿Í»§¶ËµÄÐÔÄܲîÒìÔ½Ã÷ÏÔ¡£ÕâÊÇÒòΪ½ø³Ì¼äͨѶ   (IPC)   »úÖÆÔÚ¶ÔµÈÏî¼äµÄͨѶ·½·¨²»Í¬¡£  
   
  ¶ÔÓÚÃüÃû¹ÜµÀ£¬Í¨³£ÍøÂçͨÐŽ»»¥ÐÔ¸üÇ¿¡£Ò»¸ö¶ÔµÈÏîÖ±µ½ÁíÒ»¸ö¶ÔµÈÏîʹÓöÁÈ¡ÃüÁîÇëÇóÊý¾Ýʱ²Å·¢ËÍÊý¾Ý¡£ÔÚ¿ªÊ¼¶ÁÈ¡Êý¾ÝÇ°£¬ÍøÂç¶ÁÈ¡Ò»°ã°üÀ¨Ò»ÏµÁпúÊÓÃüÃû¹ÜµÀµÄÐÅÏ¢¡£ÕâÔÚÂýËÙÍøÂçÖпÉÄÜ»¨·Ñ·Ç³£¶à²¢µ¼Ö¹ý¶àµÄÍøÂçÁ÷Á¿£¬ÆäËüµÄÍøÂç¿Í»§¶Ë·´¹ýÀ´Ò²»áÊܵ½Ó°Ïì¡£  
   
  ²ûÃ÷ËùÌÖÂÛµÄÊDZ¾µØ¹ÜµÀ»¹ÊÇÍøÂç¹ÜµÀÒ²ºÜÖØÒª¡£Èç¹û·þÎñÆ÷Ó


Ïà¹ØÎĵµ£º

¸ü¸ÄSQL 2005µÄµÇ½·½Ê½

Èç¹ûÄãµÄÉí·ÝÑéÖ¤·½Ê½ÎªWindows¼¯³ÉÉí·ÝÑéÖ¤¸ü¸ÄΪ»ìºÏ·½Ê½µÄÉí·ÝÑéÖ¤£¬ÐèÒªÔÚSQL Server Configuration ManagementÖУ¬°ÑTCP/IPµÄ»î¶¯ÆôÓã¬Ò²¾ÍÊǵÚÒ»¸öÑ¡ÔñµÄµØ·½£¬Ñ¡ÔñÆôÓᣲ¢ÇÒʹÓü¯³ÉÉí·ÝÑéÖ¤·½Ê½µÇ¼ºó£¬ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏÑ¡ÔñÊôÐÔ£¬°Ñ°²È«ÐÔϵÄWINDOWSģʽ¸ÄΪSQLÓëWINDOWSģʽ ......

MS sql serverɾ³ý·þÎñÆ÷×é...

֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇÇ°Ò»¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql ......

SQL²éѯÿÐÐÖÐ×î´óÖµµÄ¼¼ÇÉ

--------------------------------------------------------------------------
--  Author : htl258(Tony)
--  Date   : 2010-04-23 08:08:36
--  Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  ......

SQL SERVERÖÐһЩÌرðµØ·½µÄÌرð½â·¨

SQL code
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-04-20 20:10:41
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ