Enable xp_cmdshell in SQL Server 2008

You can write SQL which outperforms and is bug free.

Get your copy of my SQL Best Practices and start writing the SQL which sails through code reviews.

Cost? Pay what you want :)

Student or just starting your career? Give yourself a break and get it for free.

Database professional? Think about your hourly rate and how much time you'll save with crisp and clear best practices.
Contribute over $27 and I'll send you the Word version of the doc so you can easily customize it for yourself and your team.

Get SQL Best Practices

Want to enable xp_cmdshell in SQL Server 2008? This fast and easy T-SQL script will do the trick without trying to find the setting using the MS SQL Management Studio Object Explorer. (If you insist on using Object Explorer you can find the switch for xp_cmdshell by right clicking on the server name, selecting "Facets", selecting "Server Configuration" in the Facet dropdown. "XPCmdShellEnabled" is at the bottom of the Facet Properties window).

EXEC sp_configure 'show advanced options', 1
EXEC sp_configure 'xp_cmdshell', 1

No comments yet.

Leave a Reply