·þÎñÆ÷ϵͳ¼¯³É¼°Êý¾Ý·þÎñÖÐÐÄ

 

Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
¡¾æŠ€æœ¯èµ„æ–?uppage=news.asp¡¿¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­>>>

¹ØÓÚ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
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
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 Óï¾ä½øÐа²×°¡£

ÖÁ´ËÎÊÌâ½â¾ö¡£

ÕªÓÚhttps://blog.csdn.net/fin86889003/article/details/62215544

·¢²¼Ê±¼ä:2019/12/20 ÔĶÁ:8732´Î À´Ô´:»¥ÁªÍø
 


¡¡
技术资æ–?uppage=news.asp·ÖÀà
   
  ÐÐÒµÐÂÎÅ
 
  ¹«Ë¾¶¯Ì¬
 
  ¼¼Êõ×ÊÁÏ
 
  µçÄÔάÐÞ
 
  »Ö¸´°¸Àý
 
  SQLÊý¾Ý¿â
 
  ´ÅÅÌÕóÁÐ
 
  ·þÎñÆ÷
 
  ²ÆÎñÈí¼þ
 
  ÍøÂçÎÊÌâ
 
  linux-XFS
 
  Æ»¹ûµçÄÔ&ϵͳ
 
  °²×¿ÏµÍ³Ïà¹Ø
 
  °ì¹«Îļþ
 
  ²Ù×÷ϵͳ
 
  ÈÕ³£Éú»î(ÑĮ̀)
 
  ÍøÕ¾Ïà¹Ø
 
   
¡¡
ÓÑÇéÁ´½Ó
¡¡
¡¡
 
 
 
   
¹«Ë¾µØÖ·£ºÑĮ̀µçÄÔÊг¡#308
µç»°£º0535-6688830 E-Mail:163@163.com
Copyright©2011-2012 ÑĮ̀Èð³Û¿ÆóÓÐÏÞ¹«Ë¾ All Rights Reserved.
³ICP±¸11014811ºÅ-1
ÄúÊDZ¾Õ¾µÚ λ·ÃÎÊÕß