Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

MS SQL Server Can be used to send Auto Generated Email's - How?

user-image
Question added by Ahmed Yousry , Administrator, CRM Development , Majid Al Futtaim Group
Date Posted: 2016/07/11
Mohamed  Yasin
by Mohamed Yasin , Web Administrator/ Front End Developer , Royal Crown LLC

Using Stored Procedure you can do it..

 

Ref: http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/

Zainab Abdali
by Zainab Abdali , Technical Business Analyst , The Family Office

yes,there are several options:

- from jobs (in SQL management studio) you can configure a schedueled job to do that

- you can configure an ssis package and scheduel it again from jobs in sql

- via stored procedure

mostafa abdellah
by mostafa abdellah , System Analyst , ETECHS

Yes It can send emails, http://dba.stackexchange.com/questions/10190/how-to-create-and-send-mail-in-sql-server-2008

More Questions Like This