views:

42

answers:

2

Hi All,

I need to send a mail from Stored Procedure. I knew it is possible. I studied it from this link . How do i authenticat in SMTP Server. Do you have any idea.?

Thanks

A: 

Using extended stored procedures to create an use and ActiveX that sends the email or create an assembly that sends the mails and use it from sql2008.

+1  A: 

You can use SQL Database Mail.

See Database Mail and SQL Mail Stored Procedures (Transact-SQL)

And here's a Tutorial

Marko
How to authenticate the sender?Thanks.
Manoj
Have you created a profile in Database Mail? You can specify credentials there. Management Studio > Management > Database Mail > New Profile
Marko