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

¹ØÓÚsql server ´úÀí£¨ÒѽûÓôúÀíxp£©

Ö¢×´£º
SQL SERVER2005ÀïÃæ£¬Æô¶¯SQL´úÀí·þÎñ£¬Æô¶¯Õý³££¬µ«ÊÇÔÚsql server ´úÀí»¹ÊÇÏÔʾÒѽûÓôúÀí xp
ÔÚManagement StudioÖÐн¨Î¬»¤¼Æ»®Ê±£¬ÌáʾÒÔÏ´íÎóÐÅÏ¢£º
“´úÀíXP”×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʹÓÃsp_configureÀ´ÆôÓÓ´úÀíXP”¡£ÓÐ¹ØÆôÓÓ´úÀíXP” µÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄSQL ServerÁª»ú´ÔÊéÖеēÍâΧӦÓÃÅäÖÃÆ÷”¡£
½â¾ö·½·¨£º
Sql´úÂë
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
ÕâÊǰïÖúÎĵµ¸ø³öµÄ´ð°¸£¬Ïêϸ¿É²é¿´http://msdn.microsoft.com/zh-cn/library/ms178127.aspx
µ«Êǵ±Ö´ÐÐÉÏÃæµÄÓï¾ä£¬È´±¨´í£º“²»Ö§³Ö¶ÔϵͳĿ¼½øÐм´Ï¯¸üС£”
ÔÚÍøÉÏÕÒÁËÏ£¬ÖÕÓÚÕÒµ½´ð°¸£¬sqlÈçÏ£º
Sql´úÂë
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE; --¼ÓÉÏWITH OVERRIDE
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE WITH OVERRIDE --¼ÓÉÏWITH OVERRIDE
GO
ÅäÖÃÑ¡Ïî 'show advanced options' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÅäÖÃÑ¡Ïî 'Agent XPs' ÒÑ´Ó 0 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£


Ïà¹ØÎĵµ£º

SQL Server 2005||2008ÒÆÖ²Êý¾Ý¿â³öÏÖµÄÎÊÌâ

Óû§¡¢×é»ò½ÇÉ«′sde'ÔÚµ±Ç°Êý¾Ý¿âÖÐÒÑ´æÔÚ
Use dbName
go
sp_change_users_login ‘update_one’
,
‘loginName’
, ‘loginName‘
Õª×Ô:http://www.softbunny.net/post/SQL_Login_User.shtml
......

SQLÓï¾ä ´´½¨Ë÷Òý

Óï·¨£º
CREATE [Ë÷ÒýÀàÐÍ] INDEX Ë÷ÒýÃû³Æ
ON ±íÃû(ÁÐÃû)
WITH FILLFACTOR = Ìî³äÒò×ÓÖµ0~100
GO
/*ʵÀý*/
USE ¿âÃû
GO
IF EXISTS
(SELECT * from SYSINDEXES WHERE NAME='IX_TEST_TNAME')--¼ì²âÊÇ·ñÒѾ­´æÔÚIX_TEST_TNAMEË÷Òý
DROP INDEX
TEST.IX_TEST_TNAME--Èç¹û´æÔÚÔòɾ³ý
--´´½¨Ë÷Òý
CREATE NONCLUSTER ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹ØÏµ
ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼­·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØÆ½ºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf ºÍ Data3.ndf£©£¬²¢½«ÕâÈý¸ ......

ÅäÖÃODBCÁ¬²»ÉÏSQL ServerµÄ½â¾ö·½·¨

1¡¢¸ÃÓû§ÓеǼȨÏÞ¡£
2¡¢ServerÈç¹û¿ªÁËFirewall£¬ÔÚexceptionsÀïÌí¼Ó1433 port ¡£
3¡¢ÅäÖù¤¾ß->SQL ServerÍâΧӦÓÃÅäÖÃÆ÷->·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷->´ò¿ªMSSQLSERVER½ÚµãÏ嵀 Database Engine ½Úµã£¬Ñ¡Ôñ“Ô¶³ÌÁ¬½Ó”£¬½ÓϽ¨ÒéÑ¡Ôñ"ͬʱʹÓÃTCP/IPºÍnamed pipes"£¬È·¶¨ºó£¬ÖØÆôÊý¾Ý¿â·þÎñºó ......

{ת}SQLÓÅ»¯34 Ìõ½¨Òé

(1)  Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò
(
Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ
)
£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àí
from
×Ó¾ä
ÖеıíÃû£¬
from
×Ó¾äÖÐдÔÚ×îºóµÄ±í
(
»ù´¡±í 
driving table)
½«±»×îÏÈ´¦Àí£¬ÔÚ
from
×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ
,
Äã±ØÐëÑ¡
Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ