Enable XP_CmdShell
in [Server Configuration]
|
From: Muhammad Bilal on 29 Jul 2010 14:13 Hi How to enable XP_CmdShell in SQL Server 2000 as I ran the following script to enable EXEC MASTER.dbo.SP_CONFIGURE 'Show Advanced Options', 1 RECONFIGURE EXEC MASTER.dbo.SP_CONFIGURE 'XP_CmdShell', 1 RECONFIGURE But I get the following error message Server: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78 The configuration option 'XP_CmdShell' does not exist, or it may be an advanced option. Regards, Muhammad Bilal
From: Erland Sommarskog on 29 Jul 2010 17:15 Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: > How to enable XP_CmdShell in SQL Server 2000 as I ran the following script > to enable > > EXEC MASTER.dbo.SP_CONFIGURE 'Show Advanced Options', 1 > RECONFIGURE > EXEC MASTER.dbo.SP_CONFIGURE 'XP_CmdShell', 1 > RECONFIGURE > > But I get the following error message > Server: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78 > The configuration option 'XP_CmdShell' does not exist, or it may be an > advanced option. xp_cmdshell cannot be disabled in SQL 2000, so you don't need to enable it. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Pages: 1 Prev: get number of monday, tuesday,... between 2 dates Next: SQL server 2008 64 bit |