hi everyone,
i have a table for entering comments, there are 3 comments normal,medium and critical comments. when the audit is freezed the critical comments should be rectified with in 15 days. I have written a procedure for finding the unrectified critical comments not rectified after 15 days when audit is freezed. i want to send email these data to my  two superiors every day  at morning 7 am. we are having dedicated server. How to accomplish this. im a new bee and this is my first assignment. please help me guys. Im using vs 2008 with c# and sql server 2008.
Thanks in advance
Agaile

Go to the complete details ...