cdo in sql please help thru email | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cdo in sql please help thru email

i am working on a project where registered users keep reminders of the events like birthday,holiday,appointment according to date all the events are stored in an event log.(sql server 2005 express edition)the event log stores details like user,eventname,date,emailid,emailmesage,emailsub etcon the day the event is supposed to happen users are informed through a mail which is stored in the event log..i need to know how can these automatic mails be generated either in sql server 2005. i tried using cdo but job scheduler is not present in sql server express edition.is there any way i can make it work on sql server 2005 express edition.or should i upgrade to standard edition.is there any other way i can send emails for the same through asp.net front end.asimgulzarjan @ gmail . com
Welcome to the forums.
As you are using SQL 2005 you can take advantage of Database mail in this case, http://msdn.microsoft.com/en-us/library/ms175887.aspx fyi

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |