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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 xp_smtp_sendmail

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 29
Could not find stored procedure 'dbo.xp_smtp_sendmail'." appears.

Thanks for helping

Claudio

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-09 : 14:20:00
It doesn't come with the product. Why not use Database Mail on SQL 2008 instead?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-10 : 12:44:01
Great, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-10 : 12:44:16
quote:
Originally posted by visakh16

we use sp_send_dbmail for sending mails




Yes that is Database Mail.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -