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 - 2002-10-04 : 10:15:05
|
| Ed writes "I put in the following, form one of your articles, and it did not work. I suspect there is a lot of configuration that has to be done. However, your article said it was easy and that this was all you needed to do. I get a message saying incorrect syntax near the xp_sendmail. xp_sendmail@recipients='graz@sqlteam.com',@subject='The Yaks are loose again',@Message='Summon the Yak Herders!'If you can tell me how to do this I would really appreciate it. Thank You Ed" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-10-04 : 12:16:16
|
| If you're not in master, don't forget master..So, it would be:master..xp_sendmail @recipients='graz@sqlteam.com', @subject='The Yaks are loose again', @Message='Summon the Yak Herders!' -Chad |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-04 : 14:15:08
|
| Have you actually set SQL Mail up ?And if its not the first statement in the batch include the exec as well as the reference to master exec master.dbo.xp_sendmail.....Here's a few links for setting up SQL Mail and common problemsSQL Mail[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url]Support Web Cast[url]http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp[/url]HTHJasper Smith |
|
|
|
|
|
|
xp_sendmail