cdo in sql please help thru email | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
cdo in sql please help thru emaili 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