Ask Paula!

...bringing you notes from the field...

  Home  |   Contact  |   Syndication    |   Login
  147 Posts | 5 Stories | 133 Comments | 0 Trackbacks

News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud


Archives

Post Categories

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

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
posted on Monday, September 14, 2015 7:39 AM