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
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
You can use SQL Database Mail.
See Database Mail and SQL Mail Stored Procedures (Transact-SQL)
And here's a Tutorial