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

ÖÕ¼¶½â¾öSQL Server 2005 δÕý³£Ð¶ÔØ£¬ÖØа²×°ÎÊÌâ

 ÔÚжÔØVisual Studio 2008 ʱ£¬Ìí¼Ó/ɾ³ý³ÌÐò ÀïÃæÓÐÐí¶àµÄ°²×°Îļþ£¬´ËʱÈç¹ûûÓÐÏÈжÔØSQL Server 2005 £¬
¶øÏÈжÔØ.Net Framework£¨Ìáʾ£ºÐ¶ÔØ.net FrameworkµÄµÃ°²°æ±¾´Ó¸ßµ½µÍµÄ˳Ðò£©£¬
ÕâʱSQL Server 2005¾ÍÎÞ·¨Ð¶ÔØ,ɾ³ýProgram files ÏÂÃæµÄ Microsoft SQL Server Îļþ¼ÐҲûÓÐ×÷Óá£
ÖØа²×°ÌáʾÊý¾Ý¿âʵÀýÒѾ­´æÔÚ£¬ÇëÖØÐÂÑ¡ÔñÁíÒ»¸öʵÀýÃû³Æ¡£
  ¾­¹ý×Ðϸ·ÖÎö£¬Òѽâ¾öÈçÉÏÎÊÌâ¡£½â¾ö²½ÖèÈçÏÂ:
  1.Í£ÓÃWindows 2003 ϵÄÊý¾Ý¿â·þÎñ,ÓÒ¼üµã»÷ÎҵĵçÄÔ-->¹ÜÀí-->·þÎñ,Í£ÓÃSQL Server (MSSQLSERVER)¡¢SQL Server Agent (MSSQLSERVER)¡¢SQL Server FullText Search (MSSQLSERVER)¡¢SQL Server Browser¡¢SQL Server VSS WriterµÈSQL Server Ïà¹Ø·þÎñ.
  2.½øÈë×¢²á±í(regedit)-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services £¬
ÕÒµ½²½Öè1ËùÍ£ÓõÄSQL ServerÏà¹Ø·þÎñ×¢²á±íÏ½«Æäɾ³ý¡£
  3¡£½øÈë×¢²á±í(regedit)--
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft,
ÕÒµ½Microsoft SQL Server¡¢
    Microsoft SQL Server 2005 Redist¡¢
    MSSQLServer
×¢²á±íÏ½«Æäɾ³ý¡£
  4¡£ÖØÐÂÆô¶¯µçÄÔ£¬°²×°SQL Server2005³É¹¦£¡
¸½£ºÈç¹û°²×°SQL Server2005 ÌáʾSQLXML4°²×°³ö´í£¬´Ëʱ¿É½øÈëÌí¼Ó/ɾ³ý³ÌÐò ½«ÒÑ°²×°¹ýµÄSQLXML4ɾ³ý£¬ÔÙÖØа²×°SQL Server 2005,ÎÊÌâ½â¾ö£¡(´ËÎÊÌâÊÇÒòΪ£¬SQL Server 2005Ëù´øµÄSQLXML4°æ±¾ÎÊÌâÒýÆðµÄ)£¡
Áí£ºÔø¾­Åöµ½ÔÚWindow2003SP2ÏÂÎÞ·¨°²×°SQL Server 2005£¬Èç¹û³¢ÊÔÆäËüµÄ·½·¨¶¼ÎÞ·¨½â¾ö£¬ÄÇô´ËÎÊÌâºÜ¿ÉÄÜÊÇÒòΪ Winodws Installer MSXML 6.0 Parser[6.00.3883.8]ÒýÆðµÄ£¬´ó¼Ò¿Éµ½ÍøÉÏÏÂÔØWinodws Installer Clean Up À´Çå³ý´ËÏî.
×ÊÁÏÒýÓÃ:http://www.knowsky.com/533046.html


Ïà¹ØÎĵµ£º

轉SQL Server Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ

 Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ
--
½¨Á¢Á¬½Ó·þÎñÆ÷
EXEC
sp_addlinkedserver
'
Ô¶³Ì·þÎñÆ÷IP
'
,
'
SQL Server
'
--
±ê×¢´æ´¢
EXEC
sp_addlinkedserver
@server

=

'
server
'
,
--
Á´½Ó·þÎñÆ÷µÄ±¾µØÃû³Æ¡£Ò²ÔÊÐíʹÓÃʵÀýÃû³Æ£¬ÀýÈçMYSERVER\SQL1
@srvproduct

=

'
product_name ......

SQL Server ÒÆÖ²µ½Oralce ÏîĿʵս

ÏîÄ¿±³¾°
         ÒÆÖ²Ò»¸öÏÖÓÐϵͳµ½Oracle¡£Ô­ÏµÍ³»ùÓÚ.Net Framework 1.1, SQL Server 2000Êý¾Ý¿â£¬Êý¾Ý²Ù×÷»ù±¾È«²¿Ê¹ÓÃStore Procedure£¬×ÜÊýÓâǧ£¬Òò´Ë×ÜÌåÉæ¼°µÄPL SQL ¿ª·¢Á¿±È½Ï´ó¡£
 
         ÓÅÏȼ¶¸ß£¬¿ª·¢Ê±³Ì¶Ì£ ......

SQL Server 2005ÀûÓ÷ÖÇø¶Ôº£Á¿Êý¾ÝµÄ´¦Àí


³¬´óÐÍÊý¾Ý¿âµÄ´óС³£³£´ïµ½Êý°ÙGB£¬ÓÐʱÉõÖÁÒªÓÃTBÀ´¼ÆËã¡£¶øµ¥±íµÄÊý¾ÝÁ¿ÍùÍù»á´ïµ½ÉÏÒڵļǼ£¬²¢ÇҼǼÊý»áËæ×Åʱ¼ä¶øÔö³¤¡£Õâ²»µ«Ó°Ïì×ÅÊý¾Ý¿âµÄÔËÐÐЧÂÊ£¬Ò²Ôö´óÊý¾Ý¿âµÄά»¤ÄѶȡ£³ýÁ˱íµÄÊý¾ÝÁ¿Í⣬¶Ô±í²»Í¬µÄ·ÃÎÊģʽҲ¿ÉÄÜ»áÓ°ÏìÐÔÄܺͿÉÓÃÐÔ¡£ÕâЩÎÊÌⶼ¿ÉÒÔͨ¹ý¶Ô´ó±í½øÐкÏÀí·ÖÇøµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£µ±±íºÍË÷Òý ......

AMD ÈýºË´¦ÀíÆ÷°²×°SQL Server2005³ö´í´¦Àí½â¾ö·½°¸¡£

     ×î½üѧSQL Server2005£¬ÏÂÔØÁËSQL2005ÖÐÎÄ¿ª·¢°æ£¬µ«ÊÇͬѧÃǶ¼°²×°ÉÏÁË£¬Î¨¶ÀÎҵĻúÆ÷°²×°²»ÉÏ¡£
     ÿ´Î°²×°DATABASEµÄʱºò¶¼ÌáʾÎÞ·¨Æô¶¯sqlservr.exe·þÎñÎÞ·¨Æô¶¯£¬ÖØװϵͳҲ²»ÐУ¬WINXP WIN 7ÏÂÃ涼ÎÞ·¨°²×°£¬ÓÚÊÇÉÏÍø²éÁËÏ£¬Ô­À´SQL2005²»Ö§³Ö3ºË´¦ÀíÆ÷£¬Î¢ÈíÒ²×Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ