Oh Microsoft SQL
Monday, March 5, 2007
Enabling/Disabling xp_cmdshell
In order to use xp_cmdshell in the QA, do the following steps:
sp_configure 'xp_cmdshell','1' -- Set it enabled
reconfigure -- apply the changes in db
Now you can run xp_cmdshell.
If you want to disable it, do followings:
sp_configure 'xp_cmdshell','0' -- Set it disabled
reconfigure -- apply the changes in db
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2011
(3)
►
November
(3)
▼
2007
(13)
►
April
(4)
▼
March
(6)
Splitting an integer list in TSQL
Split Delimiter Separated Lists
INFORMATION_SCHEMA: A Map to Your Database
Changing Compatibility Mode of MSSQL2005
Outer Join Logical Processing Phases
Enabling/Disabling xp_cmdshell
►
February
(3)
About Me
oh_csharp
View my complete profile
No comments:
Post a Comment