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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-07-28 : 06:52:14
|
| when i tried to send test email through sql server 2000 xp_sendmail procedure i m getting following error message.Could not find stored procedure 'xp_sendmail'.code is used asexec xp_sendmail 'im_xiber@hotmail.com', @query='select * from caclientslogin'tell me what's wrong with the code. or do i need some thing to install in order to access extended procedures.thx in advance |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-07-28 : 07:17:45
|
| You must use the Master database for this.Duane. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-28 : 08:45:46
|
| exec master..xp_sendmail 'im_xiber@hotmail.com', @query='select * from caclientslogin'Just for clarification. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Could not find stored procedure 'xp_sendmail'.