в 13:46, 26 мая 2010

2010-05-26T13:46:16Z

Admin: 1 версия

2010-05-26T10:23:49Z

1 версия

Новая страница

== Granting PUBLIC permissions will cause you grief.==



<source lang="sql">
The syntax of this stored procedure is xp_cmdshell "command"[,no_output]

xp_cmdshell "dir c:\"</source>

== output the contents of the root directory of the server to the console.==



<source lang="sql">
5>
6>
7> DECLARE @myresult int
8> EXEC @myresult = xp_cmdshell "dir c:\tim.txt"
9> IF (@myresult = 0)
10> PRINT "Success"
11> ELSE
12> PRINT "Failure"
13> GO
Msg 15281, Level 16, State 1, Server J\SQLEXPRESS, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure "sys.xp_cmdshell" of component "xp_cmdshell" because this component is turned off as part of the security configuration for this server. A system administrator c
an enable the use of "xp_cmdshell" by using sp_configure. For more information about enabling "xp_cmdshell", see "Surface Area Configuration" in SQL Server Books Online.
Failure</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL Server/T-SQL Tutorial/System Settings/xp cmdshell - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия