sending mail through sql server 2005

Question

I need to send mail through sqlserver 2005! thanks in advance regards, gowtham, eternalsoftwares, chennai.

Suthish Nair · Answer

check for SP in master database, if not found contact your DB team and get it re-configured

Suthish Nair · Answer

change EXEC msdb.dbo.sp_send_dbmail to EXEC master.dbo.xp_sendmail

Jiteendra Sampathirao · Answer

Hi, Write all this under Submit button click event write a select query and get the required values like this string selectquery = ""; selectquery = "select RID, UserName, Email_Id, CONVERT(varchar, DOB, 103) AS DOB, CONVERT(varchar, DOJ, 103) AS DOJ, State, Pin_Code FROM Registration where RID=" + hdnvalue; SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer"]); SqlCommand sqlcomm = new SqlCommand(); sqlcomm = sqlcon.CreateCommand(); sqlcomm.CommandType = CommandType.Text; sqlcomm.CommandText = selectquery; sqlcon.Open(); SqlDataReader sqlred = null; sqlred = sqlcomm.ExecuteReader(); if (sqlred.Read()) { if (sqlred["UserName"] != null) { String strFrom = sqlred["UserName"].ToString(); } if (sqlred["Email_Id"] != null) { string strTo= sqlred["Email_Id"].ToString(); } if (sqlred["DOJ"] != null) { string strSubject= sqlred["DOJ"].ToString(); } if (sqlred["Pin_Code"] != null) { string strbodytext= sqlred["Pin_Code"].ToString(); } } sqlcomm.Dispose(); sqlcon.Close(); SmtpMail.Send(strFrom, strTo, strSubject, strbodytext); Response.Write("Message was sent to" + strTo); Modify this to your requirement..............

Gowtham manju · Answer

still i am got stuck in to it....can not find the solution i do not get the proper idea to follow do not mistaken me

Jiteendra Sampathirao · Answer

Hi refer http://msdn.microsoft.com/en-us/library/ms378108%28v=sql.90%29.aspx http://vstoolsforum.com/blogs/sqlserver/archive/2007/04/20/creating-a-stored-procedure-with-output-parameters.aspx

Gowtham manju · Answer

can u provide me some suitable links or references to solve

Jiteendra Sampathirao · Answer

get the values using output variables in Stored procedure and write a sendmail method in code-behind...There use these values... Refer Create SP's and how to send mail articles

Gowtham manju · Answer

thanks for posting.......! the coding which i created was use master go SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE sendemail1 @subjectText varchar(5000), @bodytext varchar(5000), @to varchar(150) AS BEGIN exec master.dbo.sp_sendmail @recipients='mail@xxx.com', @copy_recipients='mail@yyy.com', @subject ='hi', @body = 'sample', @body_format = 'HTML' ; END GO but i am getting those errors can u guide me

Jiteendra Sampathirao · Answer

Hi, Create Stored procedure and use that code in that SP....

Gowtham manju · Answer

Ya, jagan thanks for posting!!! i too tried the same code but got error such as Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.sp_sendmail'. The stored procedure will still be created.

Jaganathan Bantheswaran · Answer

Hi, The following script will send an e-mail with an attached file named FileAttachment.txt, which is located on my C: drive. You will need to make sure that this file exists so that the procedure does not error. EXEC msdb.dbo.sp_send_dbmail @recipients=N'xxxxx@gmail.com', @body='Message Body', @subject ='Message Subject', @profile_name ='Database-mailProfile', @file_attachments ='C:\FileAttachment.txt';

sending mail through sql server 2005

Answers (11)