News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



sql server: Why can't I use the xp_cmdshell in SSMS?

You will need to enable the feature first.

Follow these steps:

EXEC sp_configure 'show advanced options', 1
GO
-- this updates whatever the currently configured value for advanced options
RECONFIGURE
GO
-- Now enable the command shell
EXEC sp_configure 'xp_cmdshell', 1
GO
--update the currently configured value with xp_cmdshell setting update.
RECONFIGURE
GO
Monday, September 14, 2015 7:39 AM

Feedback

No comments posted yet.


Post A Comment
Title:
Name:
Email:
Comment:
Verification: