Click here to Skip to main content
15,665,353 members

coolestCoder - Professional Profile


    Blog RSS
coolestCoder is working at ITCube Solutions Pvt. Ltd., India. He has total experience of 2+ years developing various types of .Net applications, viz. Windows Service, Web Application and at present working on Windows Forms applications. He likes to face challenges while coding and always ready to help others. He would like to see himself as a Technical Architect in near future. His main interests lies in understanding the internal of any program / component / technology.
He loves to read articles related to new topics, for example, Framework 3.5, LINQ, etc.....


Weekly Data. Recent events may not appear immediately. For information on Reputation please see the FAQ.


Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilver
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSubEditor, Mentor, Protector, Editor
Store personal files in your account areaplatinumplatinumSubEditor, Editor
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Edit a Question in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Edit an Answer in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Delete a Question in Q&AYesSubEditor, Protector, Editor
Delete an Answer in Q&AYesSubEditor, Protector, Editor
Report an ArticlesilversilversilversilverSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubEditor, Mentor, Protector, Editor
Edit other members' articlesSubEditor, Protector, Editor
Create an article without requiring moderationplatinumSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending QuestionProtector
Approve/Disapprove a pending AnswerProtector
Report a forum messagesilversilverbronzeProtector, Editor
Approve/Disapprove a pending Forum MessageProtector
Have the ability to send direct emails to members in the forumsProtector
Create a new tagsilversilversilversilver
Modify a tagsilversilversilversilver

Actions with a green tick can be performed by this member.

GeneralSending emails from SQL Server 2000 Pin
coolestCoder14-Nov-07 17:48
coolestCoder14-Nov-07 17:48 
There are situations in software projects where we need to send emails from within the database. This is very common for web applications
which needs some technique as "Reminders". We can send mail from sql server in an easy and clean way. Simply set some parameters of a
system stored procedure and you are ready to shoot mails from database.

The name of stored procedure used for this purpose is - xp_smtp_sendmail

Some generally used parameters are -

1. @From Emails from email address
2. @To Comma seperated list of to email address
3. @CC Comma seperated list of CC email address
4. @BCC Comma seperated list of BCC email address
5. @priority The priority of email (HIGH, for example)
6. @Subject Subject of email
7. @Message Text / Body of email
8. @type Whether email is HTML or plain text. For HTML set 'text/html'
9. @attachments Path of any attachements
10. @Server IP address of email server

This post is applicable only for SQL Server 2000.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder


General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.