how can we send Mail using Store Procedure in SQl 2000

Question

hi i searching lot of procedure to send mail using store procedure but no one can send Can any one know tested storeprocedure sending mail using SMTP server Regards Kirti Darji

sundara moorthy · Answer

hi kirti darji Refer this link http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm Thanks & Regards sundar

Kirti Darji · Answer

Smtp Server Name how can we find if smtp server are Remote base then it work what about user credential

Sanjay Chauhan · Answer

Hi This is the tested mail sending sp for sql server 2000 EXEC master.dbo.xp_smtp_sendmail @FROM = 'abc@test.com' @FROM_NAME = 'abc@test.com' @TO = @vc_mailto @replyto = '' @CC = '' @BCC = @bcc_mail @priority = 'NORMAL' @subject = @vc_subject @message = @vc_message @type = 'text/html' @messagefile = '' @attachment = '' @attachments = '' @codepage = 0 @server = 'smtpserver'