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

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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

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

Çósqlserver 2005 Êý¾Ý¿âÁ¬½Ó½â¾öÎÊÌâ¡£

ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......

sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ

    sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾­´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......

sqlserver ´æ´¢¹ý³ÌÈçºÎ¶¯Ì¬µÄÉùÃ÷ ±äÁ¿

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


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ