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 |
claudiopache
Starting Member
2 Posts |
Posted - 2012-01-09 : 14:10:53
|
Hello,I have a job that uses this = master.dbo.xp_smtp_sendmail procedure in SQL-Server 2000.Now I can't get it works on SQL-Server 2008.The message:"Msg 2812, Level 16, State 62, Line 29Could not find stored procedure 'dbo.xp_smtp_sendmail'." appears.Thanks for helpingClaudio |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-10 : 04:26:32
|
we use sp_send_dbmail for sending mails------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
claudiopache
Starting Member
2 Posts |
Posted - 2012-01-10 : 05:42:52
|
Thanks. It works with this.The only disadvantage is that I have to configure a valid profile of the SMTP server. With the other procedure I didn't need that.Thanks anyway |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|