How to configure xp_cmdshell

There are a lot of situations when we have to send the Emails from Sql Server.
But before sending Emails from Sql Server, we have to Enable this feature because by default this feature is disbled.

To enable this feature we have to fire the below command.

sp_configure 'xp_cmdshell', '1'

After executing this command you will see the following message.

"Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install."

Now we have to Run the following query.

RECONFIGURE

Press F5 to run this command.
After executing this command you will see the following message.

"Command(s) completed successfully."

Now your SQl Server database is ready to send Emails.

Regards,
Anuj Rathi

2 comments:

Anonymous said...

jkfdsajfsdjlksd;ajfl;sjfsdjfsdjf

Anonymous said...

I suggest you to change the background.. People cannot stare at this blog for more than few secs.