xp_cmdshell extended stored procedure allows to issue operating system commands directly to the Windows command shell via T-SQL code. By default xp_cmdshell extended stored procedure is disabled on new installations and can be enabled by using code shown below.
|
1 2 3 4 5 6 7 8 |
EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'xp_cmdshell', 1; GO RECONFIGURE; GO |
Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.
Leave a Comment