CODEWITHSUNDEEP
sqlstored-proceduresemailsp-send-dbmail
Manoj
Manoj

Reputation: 5867

How to send mail from Stored Procedure?

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

Upvotes: 4

Views: 15806

Answers (2)

Marko
Marko

Reputation: 72222

You can use SQL Database Mail.

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

And here's a Tutorial

Upvotes: 4

user347594
user347594

Reputation: 1296

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.

Upvotes: 0

Related Questions