Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asimgulzarjan
Starting Member
1 Post |
 Posted - 2010-12-07 : 07:30:06
|
| 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. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 07:38:27
|
| Can you send an email?You can always schedule a stored procedure from the windows scheduler.I would upgrade though - it will make your like easier.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
server programming urgent help