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
I love Programming, and Eager to learn New things Curious about Microsoft Products, Interested in Knowledge sharing. If you can dream IT, You can become it, If you can think IT, You can do IT, If you can believe it, you can achieve IT.