Enable ‘xp_cmdshell’ SQL Server

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

Related Posts:

  1. Rename column SQL Server 2008
  2. Efficiently convert rows to columns in sql server
  3. T-SQL split string based on delimiter
  4. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  5. How can I truncate a datetime in SQL Server?
  6. SQL Server WITH statement
  7. SQL Server Insert if not exists
  8. SQL Server: Invalid Column Name
  9. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  10. Arithmetic overflow error converting numeric to data type numeric
  11. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  12. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  13. Sql query to insert datetime in SQL Server
  14. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  15. Bulk load data conversion error (truncation)
  16. Can I use multiple “with”?
  17. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  18. Backup a single table with its data from a database in sql server 2008
  19. How can I group by date time column without taking time into consideration
  20. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  21. Filter data based on date in sql
  22. Varchar invalid for Sum operator
  23. LIKE vs CONTAINS on SQL Server
  24. What’s the best way to search for a UPC code in a Database?
  25. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  26. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  27. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  28. What is an MDF file? [closed]
  29. What is the difference between UNION and UNION ALL?
  30. Selecting COUNT(*) with DISTINCT
  31. Case in Select Statement
  32. What is a stored procedure?
  33. What is the difference between varchar and nvarchar?
  34. ORA-00904: invalid identifier
  35. SQL WITH clause example [duplicate]
  36. Unknown column in ‘field list’ error on MySQL Update query
  37. Unknown column in ‘field list’ error on MySQL Update query
  38. SQL Inner-join with 3 tables?
  39. The wait operation timed out. ASP
  40. What is SELF JOIN and when would you use it? [duplicate]
  41. The wait operation timed out. ASP
  42. Conversion failed when converting date and/or time from character string while inserting datetime
  43. Self Join to get employee manager name
  44. How do I UPDATE from a SELECT in SQL Server?
  45. how to fix oracle ORA-01722 invalid number error
  46. SQL query to select dates between two dates
  47. MySQL – Operand should contain 1 column(s)
  48. SQL SELECT WHERE field contains words
  49. Conversion failed when converting date and/or time from character string while inserting datetime
  50. When should I use CROSS APPLY over INNER JOIN?
  51. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  52. Insert Data Into Temp Table with Query
  53. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  54. MySQL create table if not exists and insert record only if table was created
  55. error, string or binary data would be truncated when trying to insert
  56. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  57. NOT IN vs NOT EXISTS
  58. SQL SELECT WHERE field contains words
  59. Online SQL Query Syntax Checker
  60. How can I do an UPDATE statement with JOIN in SQL Server?
  61. Must declare the scalar variable
  62. How do I use MySQL through XAMPP?
  63. ORA-00979 not a group by expression
  64. T-SQL split string
  65. ORA-00907: missing right parenthesis
  66. How do I use properly CASE..WHEN in MySQL
  67. Must declare the scalar variable
  68. Why do we need “Relationships” between tables at all?
  69. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  70. Using group by on multiple columns
  71. How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
  72. How to delete duplicate rows in SQL Server?
  73. How can I do a FULL OUTER JOIN in MySQL?
  74. Nested select statement in SQL Server
  75. PostgreSQL “DESCRIBE TABLE”
  76. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  77. Using group by on multiple columns
  78. SQL SELECT WHERE field contains words
  79. SQL Query with NOT LIKE IN
  80. MySQL query String contains
  81. How do I escape a single quote in SQL Server?
  82. What’s the difference between VARCHAR and CHAR?
  83. Case statement in MySQL
  84. IDENTITY_INSERT is set to OFF – How to turn it ON?
  85. How to declare a variable in MySQL?
  86. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  87. Finding duplicate values in a SQL table
  88. ORA-01843 not a valid month- Comparing Dates
  89. SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
  90. SQL Server Management Studio, how to get execution time down to milliseconds
  91. How to rename a table in SQL Server?
  92. MySQL Cannot Add Foreign Key Constraint
  93. Drop a temporary table if it exists
  94. How do I escape a single quote in SQL Server?
  95. ORA-00918: column ambiguously defined in SELECT *
  96. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  97. How Stuff and ‘For Xml Path’ work in SQL Server?
  98. IDENTITY_INSERT is set to OFF – How to turn it ON?
  99. Oracle error : ORA-00905: Missing keyword
  100. An attempt was made to access a socket in a way forbidden by its access permissions

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)