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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-16 : 07:43:24
|
| Corey writes "How can you control the Subject line when SQLMail sends out notifications?The default is waaaaay too revealing.Any thoughts?Thanks." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-16 : 12:43:43
|
| The only way that I know of to change the subject line would be to explicitly call xp_sendmail. I doubt that you will be able to change the notification since there isn't any place to modify the e-mail that it sends. So instead of using the notification e-mail option, create a custom job that checks for whatever you want notification about and have the job send the e-mail by calling xp_sendmail.Tara |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-04-16 : 14:11:41
|
| It can't currently be done. I looked into this when I was trying to get notifications on my cell phone via text paging. The phone could only handle a max of 200 chars per message though. So I looked for a way to change what was being sent out by the SQL Server Agent. Long story short, it's embedded in the SQL Server code and can not be changed. I'm hoping they will make this configurable in Yukon.....Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
SQL2000 Mail