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 |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2010-07-15 : 15:56:49
|
| I need to write a store procedure where in the body of the email the body is coming from a table in the database any help would be appreciated thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-07-15 : 16:08:36
|
We are running sql 2008i know that an email can be sent but can the body of it be coming from a table in the database? if so please send a scriptquote:
Originally posted by tkizer
If you are using SQL Server 2005 or 2008, then you can use Database Mail. For SQL Server 2000, you'd use SQL Mail. Both allow you to run a query and put into the email. Check BOL for details or let us know if you have any questions.There are other email options, but Database Mail and SQL Mail are built into SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-07-16 : 10:42:17
|
| hmm ok so that worked thanks for that but now i need to add an html code in the body so it formats it better and also concat the fields....sorry am new at this! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-16 : 11:05:19
|
| Read the DOCs ... the various options are all described there |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-07-16 : 11:10:14
|
THE DOCS?quote:
Originally posted by Kristen
Read the DOCs ... the various options are all described there
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Store Procedure Email