The following is from the network, which describes how to enable xp_cmdshell extended stored procedures to command
First, Introduction
The xp_cmdshell extended stored procedure executes the command string as the operating system command shell and returns all output in the form of a line of text.
Iii. xp_cmdshell in SQL Server 2005
Because of a security risk, xp_cmdshell is turned off by default in SQL Server 2005.
At this point, if the execution xp_cmdshell will prompt the service is not turned on:
exec xp_cmdshell ' dir c:/'
Message 15281, Level 16, State 1, Process xp_cmdshell, line 1th
SQL Server blocked access to the process ' Sys.xp_cmdshell ' of component ' xp_cmdshell ' because this component has been shut down as part of this server security configuration. System administrators can enable ' xp_cmdshell ' by using sp_configure. For more information about enabling ' xp_cmdshell ', see "Perimeter Configuration" in SQL Server Books Online.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.