USE master
GO
EXECUTE sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'xp_cmdshell', '1'
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO
20 octubre, 2009
Cómo habilitar xp_cmdshell en SQL Server 2008
Antes de SQL Server 2008 podíamos habilitar al xp_cmdshell usando la herramienta Surface Area Configuration (SAC), pero dicha herramienta fué sustituida en SQL Server 2008 por SQL Server Configuration Manager. El siguiente scriptlet puede hacer la tarea:
USE master
GO
EXECUTE sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'xp_cmdshell', '1'
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO
USE master
GO
EXECUTE sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'xp_cmdshell', '1'
RECONFIGURE WITH OVERRIDE
GO
EXECUTE sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO
Suscribirse a:
Enviar comentarios (Atom)
Entradas
excelente..........felicitaciones
ResponderEliminarQUIERO PARTICIPAR EN LOS FOROS...
ResponderEliminarCOMO HAGO.......
Hola Raulin! Para participar en los foros MSDN de SQL server en Español simplemente debes ir al sitio http://social.msdn.microsoft.com/Forums/es-ES/sqlserveres/threads
EliminarPara acceder debes usar una cuenta MSN Live (Messenger).
Saludos, nos vemos alí.
me aparece el siguiente error
ResponderEliminarDBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Mens 15123, Nivel 16, Estado 1, Procedimiento sp_configure, Línea 78
The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.
Valid configuration options are:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.