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 |
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2009-04-08 : 19:00:42
|
| What is that select statement to see if they got sent?DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-09 : 02:37:12
|
quote:
Originally posted by helixpoint
What is that select statement to see if they got sent?DaveHelixpoint Web Developmenthttp://www.helixpoint.com
If you send mail using sp_send_dbmail, see the return value (o for success and 1 for failure)MadhivananFailing to plan is Planning to fail |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-04-09 : 03:50:09
|
| There is a table in the msdb database .. i think sys.databasemail..not sure .check it out..that will give you all the emails that are sent from the sql server..worth checking it.http://www.sqlserver007.com |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-09 : 05:11:39
|
| See the description columnselect * from msdb..sysmail_logMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
select statement for database mail