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¾µØ¹ÜµÀ»¹ÊÇÍøÂç¹ÜµÀÒ²ºÜÖØÒª¡£Èç¹û·þÎñÆ÷Ó
Ïà¹ØÎĵµ£º
ÍêÈ«±¸·Ý»òÈÕÖ¾±¸·ÝËä˵¶¼ÓнضÏÈÕÖ¾µÄ¹¦ÄÜ,µ«ÊDz»»áÊÕËõÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳ.
Èç¹ûÄãÏ뽫ÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳµÄ»°,Ö»ÓÐÒ»ÖÖ·½·¨,¾ÍÊÇÊÕËõÊý¾Ý¿â(Ñ¡ÔñÈÕÖ¾Îļþ)
ZTÒ»¸öÏà¹ØÌû×Ó,¹©²Î¿¼!
ÎïÀíÈÕÖ¾Îļþ£º
Õâ¸ö±È½ÏºÃÀí½â£¬ÊµÊµÔÚÔڵĶ«Î÷£¬Êý¾Ý¿âĿ¼ÏÂÃæµÄ.ldfÎļþ¾ÍÊÇ£¬ÓÐЩÈËϲ»¶¸Äºó ......
ÔÚÍøÉÏ¿´µ½Ò»¸öºÜºÃµÄÀý×Ó½²½âinºÍexistsµÄÇø±ð£¬ÕâÀﱸÍüÏ¡£
±¾Ê¾ÀýËùʾ²éѯ²éÕÒÓÉλÓÚÒÔ×Öĸ B ¿ªÍ·µÄ³ÇÊÐÖеÄÈÎÒ»³ö°æÉ̳ö°æµÄÊéÃû£º
USE pubs
SELECT title
from titles WHERE EXISTS
(SELECT *
from publishers
WHERE pub_id = titles.pub_id ......
ijÏîĿ֮ǰµÄÊý¾Ý¿âÓб仯£¬µ«ÊÇÒÔǰдµÄ³ÌÐòÊÇÖ§³ÖÀÏÊý¾Ý¿âµÄ£¬ÐÂÊý¾Ý¿âÓÐһЩÎÊÌ⣬ÐèÒªÐ޸ģ¬µ«ÊÇÊý¾Ý¿â¾ÍÖظ´ÁË£¬ÓÚÊǾÍÒª°Ñ¿ª·¢»úÉÏ֮ǰµÄÊý¾Ý¿âÖØÐÂÃüÃû¡£
ÕâÀï¼Ç¼һϲ½Ö裨¾ÉÃû³Æ£ºMobileMsg£¬ÐÂÃû³Æ£ºMobileMsg_old£©£º
1¡¢¹ØµôÆóÒµ¹ÜÀíÆ÷£¬´ò¿ª²éѯ·ÖÎöÆ÷£»
2¡¢ÐÞ¸ÄÊý¾Ý¿âÃû³Æ£º
EXEC sp_dboption 'MobileMs ......
֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇÇ°Ò»¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql ......
1¡¢°²×°Sql Server2005 Mobile Edition£»
2¡¢¾ßÌåÔÚ´´½¨Ò»¸ö¹¤³ÌÒÔºó£¬ÏëʹÓÃSqlServerCe±ØÐëÔÚ×Ô¼º¹¤³ÌµÄÒýÓÃÀïÃæÌí¼ÓÒ»¸ödll²ÅÐУ»
ÆäĿ¼ÔÚ£ºC:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\System.Data.SqlServerCe.dll
Ìí¼ÓÁËÒÔºó¾Í¿ÉÒÔʹÓÃMobileµÄһЩÊý¾Ý¿â²Ù×÷µÄÀà¿âÁË¡£ ......