SQLServer֨װ±¨´íERROR 17750£¬ERROR 8355
СµÜ֨װSQLServer·þÎñÆ÷£¬»¹ÔMasterÊý¾ÝÆô¶¯ºó±¨´íERROR 17750£¬ERROR 8355¡£ ´íÎóÐÅÏ¢ÈçÏ£º ERROR 17750 Could not load the DLL LEServer.dll, or one of the DLLs it references. Reason: 126(error not found). ERROR 8355 Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well. ²¹³ä˵Ã÷£º »¹ÔMASTERûÓÐÈκδíÎ󣬻¹ÔÖØÆô·þÎñºó²Å³öÏÖ¡£MasterÊý¾Ý¿â±¸·Ýǰ×ö¹ýDBCC£¬Ã»Óб¨´í¡£ Çë¸÷λ¸ßÊִͽÌ
SQLʲ麼°æ±¾ ÔÙ²¹³äWIN2003ÆóÒµ°æ+SQLServer2005ÆóÒµ°æ »¹ÔmaterÊý¾Ý¿â? »Ø4Â¥ Ó¦¸Ã˵ÊÇ×ö±¸·ÝÓþµÏñµÄSQLServer·þÎñÆ÷£¬»¹ÔÆäËüÊý¾Ý¿âºó²»Äܵǽ¡£·þÎñÆ÷ȱÉٵǽÓû§¼°Õ˺ţ¬»¹ÓÐMasterÊý¾Ý¿âÄÚ°üº¬Óкܶà·þÎñÆ÷ÉèÖÃÐÅÏ¢¼°Î¬»¤½Å±¾£¬ËùÒÔÐèÒª»¹ÔMasterÊý¾Ý¿â¡£ÒýÓà ÔÙ²¹³äWIN2003ÆóÒµ°æ+SQLServer2005ÆóÒµ°æ ÐèÒªÓÃsqlcmd»òOsql ¸Ðлroy_88µÄÈÈÐĻشð СµÜÎÒÒѾ»¹ÔÁËMASTERÊý¾Ý¿â£¬²Ù×÷ûÓÐÎÊÌ⣨Ïàͬ²Ù×÷ÒÑÔÚÆäËü·þÎñÆ÷ÉÏ×ö²ÅÈô¸É´ÎʵÑ飩¡£ ÕâMASTERµÄÔ·þÎñÆ÷²»ÊÇСµÜÎÒ°²×°µÄ£¬ÆäÖпÉÄÜÊÇËù°²×°µÄ²¿¼þ»òÕß²ÎÊýÉèÖò»Í¬¡£ËùÒÔ»¹Ôºó³öÏÖÕâÁ½¸ö´íÎó¡£ »¹Íû¸÷λÔٴͽ̡£ ÊÔÊÔ osql/s ·þÎñÆ÷Ãû/u Óû§Ãû/p ÃÜÂëÄܲ»ÄÜÁ¬½ÓÉÏ ÔÚwindowsÃüÁî´°¿ÚÖ´ÐÐ Master»¹Ôºó ·þÎñÆ÷ÔËÐÐÕý³££¬¾ÍÊÇ·þÎñÆô¶¯Ê±±¨´í¡£ÒýÓà Master»¹Ôºó ·þÎ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class QueryTest&n ......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml XML code: <?xml version="1.0" encoding="UTF-8"?> <something-else-entirely> ......
sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......
create procedure test as declare @var_0 varchar(100) declare @cc int set @cc=0 exec('select @var_'+@cc +'=fullName from contact') go exec test ......