#sql server advance option

[indiandotnet]

How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82

How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82

Friends,

Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have to enable the xp_cmdShell option of  sql configuration.

To enable this we can write following statement

EXEC sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO EXEC sp_configure ‘xp_cmdshell’, 1; GO RECONFIGURE; GO

Just wanted to…

View On WordPress