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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-02-02 : 11:18:04
|
| I am getting the following error: i have win xp with sql server developer edition:Just trying to execute the stored proc. but i get the error. Can you please tell me what do i have to do:Could not find stored procedure 'master.xp_smtp_sendmail'.CREATE PROCEDURE dbo.foo AS BEGIN SET NOCOUNT ON -- do some other actions DECLARE @body VARCHAR(1024) SET @body = 'foo was fired now '+ CONVERT(VARCHAR, GETDATE()) EXEC master..xp_smtp_sendmail @TO = 'rbekkary@yahoo.com', @from = 'rbekkary@pacogroup.com', @message = @body, @subject = 'foo was fired yes.', @server = 'smtp.pacogroup.com' END |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2008-12-12 : 12:08:21
|
| Hi, I need to know how to install master.xp_smtp_sendmail from SQL 2005. Can someone lead me there please?!The current link is for versions 7.0 and 2000.Thank you.Regards. |
 |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2008-12-12 : 12:28:40
|
| Never mind about the above post.Need to use sp_send_dbmail in SQL 2005 |
|
|
|
|
|
|
Could not find storedproc 'master.xp_smtp_sendmail