Enable ‘xp_cmdshell’ SQL Server

by

You need to enable it. Check out the Permission section of the xp_cmdshell MSDN docs:

http://msdn.microsoft.com/en-us/library/ms190693.aspx:

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

More Related Contents:

  1. SQL group_concat function in SQL Server [duplicate]
  2. Pivot Dynamic Columns, no Aggregation
  3. varchar(max) everywhere?
  4. T-SQL: Export to new Excel file
  5. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  6. SQL MERGE statement to update data
  7. How to get the last record per group in SQL
  8. How to convert float to varchar in SQL Server
  9. A transport-level error has occurred when receiving results from the server [closed]
  10. How can I load a large flat file into a database table using SSIS?
  11. How to convert datetime in Persian in SQL Server
  12. storing passwords in SQL Server
  13. How to restore to a different database in SQL Server?
  14. Why is SQL Server 2008 Management Studio Intellisense not working?
  15. Reporting Services permissions on SQL Server R2 SSRS
  16. T-SQL substring – separating first and last name
  17. SQL Server: Split operation
  18. How to implement polymorphic associations in an existing database
  19. How to deploy SQL Server Compact Edition 4.0?
  20. Optional parameters in SQL Server stored procedure
  21. Entity Framework Database.SetInitializer simply not working
  22. Restoring database from .mdf and .ldf files of SQL Server 2008
  23. What is the default transaction isolation level for SQL Server with ADO.NET?
  24. Restrict SQL Server Login access to only one database
  25. T-SQL strip all non-alpha and non-numeric characters
  26. Avoiding IF ELSE due to variable been NULL
  27. Where are SQL Server connection attempts logged?
  28. Can I pass variable to select statement as column name in SQL Server [duplicate]
  29. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  30. Recursive Child/Parent queries in T/SQL

Leave a Comment