Dbmail Doesn't Rely On IIS SMTP, How To Set Bounced Email Redirect Email Etc.? Thanks
Under IIS SMTP I can set bounced email redirect etc. how to do that with dbmail, the idea is I can get the list of bounced emails somewhere so I can create a report.
Any idea?
thanks
View Complete Forum Thread with Replies
Related Forum Messages:
SMTP EMAIL TO SEND TO OPERATOR
Hi all, I figured other people would have a tutorial or some know how for this.. But does anyone have any step by step instructions to be able to "Email an Operator" if a job fails using SMTP????? The other methods of having an email client is not possible for this situation. Thanks
View Replies !
Using IS For Email Notification With Gmail Smtp
Hi, I want to setup a SMTP using gmail. How to configure it, it says, In your email client software, under Outgoing mail, set the SMTP server to smtp.gmail.com. Set the your username is yourgooglemailname@gmail.com and make sure "Use username and password" is checked. Also check off "TLS" under "Use secure connection." I tried to do this in code: Dim htmlMessage As MailMessage Dim mySmtpClient As SmtpClient htmlMessage = New MailMessage(From, SendTo, Subject, Body) htmlMessage.IsBodyHtml = IsBodyHTML mySmtpClient = New SmtpClient(Server) Dim myCred As New System.Net.NetworkCredential("myemail@gmail.com", "mypassword") 'CredentialCache mySmtpClient.UseDefaultCredentials = False 'Credentials = System.Net.CredentialCache.DefaultNetworkCredentials mySmtpClient.Credentials = myCred mySmtpClient.Send(htmlMessage) however, i cannot do the turning off of TLS in code. I'm often prompted with this error once i run: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first Anyone who knows how to do this? cherriesh
View Replies !
Why Do I Get The Following SMTP Email Error In A SSIS Package
I am running a SSIS package under a trusted account and I am running into a problem when I am executing a email task. The error is an operation timeout which was reported in the log. I am using windows authentication on the connection manager. Other email task configured the exact same way run correctly in the same run. Also when I execute task from BIDS the email is sent. Is there a bug in SSIS which would cause this behavior or some kind of exchange server configuration issue? Any help would be appreciated. Thanks, Greg
View Replies !
Generate A Email Using Smtp Server (was &"Help With Query....&")
Help with query: I currently cannot be alerted by SQL Mail so I would like to take the script that was generated by SQL server and using the store procedure sp_sqlsmtpmail to generate a email using smtp server to alert me. The store procedure does work. I would like to know if this is possible. Thanks Lystra -- Script generated on 1/21/2005 10:04 AM -- By: MAMSIsa -- Server: (local) IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Demo: Full tempdb')) ---- Delete the alert with the same name. EXECUTE msdb.dbo.sp_delete_alert @name = N'Demo: Full tempdb' BEGIN EXECUTE msdb.dbo.sp_add_alert @name = N'Demo: Full tempdb', @message_id = 9002, @severity = 0, @enabled = 1, @delay_between_responses = 10, @include_event_description_in = 5, @database_name = N'tempdb', @category_name = N'[Uncategorized]' Then Exec sp_sqlsmtpmail @vcTo = 'lwilliams@Huc.com', @vcBody ='Check out problem Immediataly.', @vcSubject ='DOCSITE01FDK - Full Tempdb Log' END
View Replies !
Mass Email: Text Body Keeps Looping In Each Email
First off, my server uses CDO, the updated version of CDONTS, to send mail. The script works however, it sends the emails out and keeps looping the message body within the text of the email. here's an example: I added fake users to my table called REALTORS. this was the result of the email sent out: <!-- START EMAIL MAIL OUT --> I am an realtor in Florida and I found you from surfing around Poop Title http://www.poop.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around Haha titleage http://www.hahaha.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around niclipse . com http://www.niclipse.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around. I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code." <!--[==-- EMAIL MAIL OUT FINISHED -------> ANY IDEAS ON HOW TO SEND EACH EMAIL TO EACH USER INDIVIDUALLY WHILE USING THE INFORMATION LINKED IN THE DATABASE WITHOUT LOOPING OTHER PEOPLE'S DB INFO IN THE SAME EMAIL? Here's the script below.... <title>Email The List</title> <% nickemail = request.form("sender") subject = request.form("subject") If Len(subject) > 0 Then dsn="Provider=SQLOLEDB;Data Source=sql.string.com, etc ect" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dsn Set RS = Server.CreateObject("ADODB.Recordset") SQL = "SELECT title, url, email FROM Realtors" RS.open SQL, conn Do While NOT RS.eof strTXT = strTXT & "I am an realtor in Florida and I found you from surfing around" If Len(RS("title")) > 0 Then strTXT = strTXT & vbcrlf & vbcrlf & RS("title") & vbcrlf strTXT = strTXT & RS("url") & vbcrlf & vbcrlf Else strTXT = strTXT & "." & vbcrlf & vbcrlf End If strTXT = strTXT & "I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a ""vote"" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation." &vbcrlf &vbcrlf strTXT = strTXT & "If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories:" &vbcrlf strTXT = strTXT & "http://www.realestate321.com/resources/resources.asp" & vbcrlf strTXT = strTXT & "Once added you will be placed in a ""holding bin"" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a ""robot"" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot." & vbcrlf &vbcrlf strTXT = strTXT & "Best Regards," & vbcrlf & vbcrlf strTXT = strTXT & "Nick McGirr" & vbcrlf strTXT = strTXT & "Real Estate Agent" & vbcrlf strTXT = strTXT & "http://www.realestate321.com/" & vbcrlf strTXT = strTXT & """Buying and Selling Homes in the (321) Area Code.""" set objMessage = createobject("cdo.message") set objConfig = createobject("cdo.configuration") ' Setting the SMTP Server Set Flds = objConfig.Fields Flds.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 Flds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost" Flds.update Set objMessage.Configuration = objConfig objMessage.To = RS("email") objMessage.From = nickemail objMessage.Subject = subject objMessage.TextBody = strTXT 'objMessage.HtmlBody = strHTML objMessage.fields.update objMessage.Send RS.movenext Loop Conn.close set Conn = nothing set objMessage = nothing set objConfig = nothing ShowThanksMsg Else End If ShowForm Sub ShowForm %> <% Session("department")="home" %> <center> <form action=email.asp method=post> <table border=0 cellpadding=4 cellspacing=2> <table> <tr><td><font class=tbody><b>From:</b></font></td><td><input type=text name=sender value="me@me.com"></td></tr> <tr><td><font class=tbody><b>To:</b></font></td><td><font class=tbody>Brevard County Emails</font></td></tr> <tr><td><font class=tbody><b>Subject:</b></font></td><td><input class=inputfield type=text name=subject size=22></td></tr> <tr><td colspan=2><input type=image align=right src=/_images/submit.gif border=0 name=B1></td></tr> </table> </form></center> <!-- <tr><td colspan=2><font class=tbody><b>Comments:</b></font><br><textarea class=inputfield rows=3 maxlength=100 name=message cols=40></textarea></td></tr> --> <% End Sub Sub ShowThanksMsg() response.write "<center><font size=5><b>Message Sent!</b></font><br><br>" response.write "your message has been delivered to all members." End Sub %>
View Replies !
Help Split List Of Email Add Comma For Evry Email
need help split list of email add comma for evry email i have tabe "tblLogin" and in this table i have field emall like this emall ----------------------------------------- aaa@hhhh.mm nnn@hhhh.mm mmm@hhhh.mm need to do ilke this Code Snippet @list_email = (SELECT emall FROM tblLogin) --------------------------i get this -----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm @recipients = @list_email Code Snippet IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] ) BEGIN DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX) SET @xml =CAST(( SELECT FirstName AS 'td','', LastName AS 'td','' , Date_born AS 'td','' , Age AS 'td','' , BirthdayToday AS 'td','' , BirthdayThisWeek AS 'td' FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX)) SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl> <tr> <td>name</td> <td>fname</td> <td>date</td> <td>age</td> <td>aaaaaaaaa</td> <td>bbbbbbbbbbbbbbb</td> </tr>' SET @body = @body + @xml +'</table></body></html>' EXEC msdb.dbo.sp_send_dbmail @recipients =N'rrr@iec.co.il', @copy_recipients='rrrrr@iec.co.il', @body = @body, @body_format ='HTML', @subject ='ggggggggggggggggggggg', @profile_name ='ilan' END ELSE print 'no email today'
View Replies !
SSRS 2005 - Linked Report Email Doesn't Have &"https&"
I've got a report server that I recently inherited. I'll be the first to admit that I'm not an expert on SSRS, but I've figured out a lot in the past few weeks. One issue I'm having (apparently it's always been there, but nobody ever bothered to fix it in the past) has to do with the report subscriptions and linked reports. We have an SSL cert inside IIS. I have SSRS configured to "require SSL connections" in the Report Server Virtual Directory tab. So the user gets an email with a link to a report. But the link has an "http://" as opposed to "https://." When you click on the link, it throws your standard "page must be viewed on a secure channel." When I manually append an S to the url, it works great. There has to be a way to automagically add the S to the url, but I can't seem to figure out how. Anyone ever run into this before? Google has not been good to me this morning either.
View Replies !
Default SMTP Virtual Server Node In IIS Not Visible Even After Installing SMTP For IIS
Hi, I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager. This is the third day I am working on this issue ..please help me out guys, prashant
View Replies !
Email
Quick question ..does DatabaseMail work in sql server express 2008.And if not ... is there a simple work around / solution to get thesame effect .. ie to send email out from sql expressRegardsRob
View Replies !
SQL Email
I want to write a stored procedure that will email Sales Associates and notify them if a customer has had a return number issed for return of defective product. I wanted to do this daily. I am using SQL Server 2000. Is there a way to get SQL to send an email without using Microsoft Exchange? I have a network that is using Workgroup mode and not domains. I can provide SQL a mailbox on our Linux mail server to send the mail.
View Replies !
Email
Hi all me again I gotta question, the Sr executive asst has a number of reports that gets emailed to different department, only problem is those departments are on a totally different server. I am guessing that we need to start SQL AGENT Emailing MAPI to do this for us, of course I could be wrong. This is one of the stored procedures that creates one of the reports CREATE PROCEDURE createSecurityListtobeEmailed AS SELECT SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type INTO SecurityList FROM SecurityListX GROUP BY SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type HAVING (((SecurityListX."Last Name") Is Not Null)) GO
View Replies !
Email Through SQL
I am trying to setup my sql to send automatic emails to different companies but I am not doing so well. The user puts an email address in the database and then presses a button (command button) that will execute a stored procedure xp_sendmail to a recepient. I need to know how to include read receipts and delivery receipts into the stored procedure, because right now its set up in his outlook as a rule to do this and I want to set it up in sql. The user deals with companies and these companies have several contacts with several email addresses which sql will store in a seperate table.
View Replies !
Email
How can I implement the functionality of sending mail with the help of SP or DTS? Subhasish
View Replies !
Sql Email
I have created a dts email task to attach an externally created file. Outlook is installed on the local server which we use to process email. The problem is that email messages appear in the sent items folder in outlook as unsent items (Envelope Closed icon) If i manually forward the email under outlook everything works fine. Any Ideas Sql 2000 sp4 Outlook 2000 Thanks in advance Mike Osbourn
View Replies !
Email From A Job
Trying to get a job step to send an email with an explaination in certain failure conditions. The problem is I want the recipient to be the job's operator. don't know of a way to accesss the job's operator email address cleanly from inside a step Any ideas?
View Replies !
Email
HI, I have sucessfully setup email on SQL 2000 using Exchange. It works fine with xp_sendmail but when I test the email account on operator it tells me that the mail was sent successfully but I never get the email? Help?? Thanks!!
View Replies !
DTS- Email How TO
IF I HAVE ONE OR MANY PACKAGES HOW DO SEND AN EMAIL TO MY BOSS IF IT BLOWS UP?? ex. INPUT IS MY TRUNCATE STEP, CONNECTION 1 IS MY ODBC, CONECTION 2 IS WHERE THE RESULT WILL BE PLACED INTO. AT ANY ONE OF THOSE STEPS, It BLOWS HOW TO SEND AN EMAIL. THE EMAIL IS ALREADY SETUP BECAUSE I TESTED IT IN THE QUERY ANALYZER WITH THIS STATEMENT ( EXEC xp_sendmail @recipients = 'robertk;laurac', @message = 'The master database is full.', @copy_recipients = 'anned;michaels', @subject = 'Master Database Status') AND IT WORKS.
View Replies !
Email From SQL
How do i get the email to be send automatically from SQL My SQL Server is configured so if sends an email after running a job. The email is been succesfully sent by SQL, but is not atually sent until you login and start up Microsoft Outlook and client on Send and Receive. Surely there is a way to get SQL to automatically send the message. I have got outlook to send message immeditally. My mail server is SendMail - SCO Open Server 5.06 Thanks David
View Replies !
SQL Email
I've setting up SQL email for alerts and I've got Outlook Express working with our SMTP server. But when I try testing email to an operator, I'm getting a "Error 22022: SqlServerAgen Error: The SQLServerAgent mail session is not running, check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog." I checked the archives of this list and found an identical discussion, but the person said to check the properties of SQL Server Agent and then look at Mail. Is there supposed to be a Mail tab or is it the "Mail Session" box under the General tab (where I have the Mail Profile name). Thanks for any help. Ed
View Replies !
Email
EXEC master.dbo.xp_sendmail @recipients=N'myemailaddress@somewhere.com', @message=N'job failed.' ; Do you know why the following error is produced? xp_sendmail: Procedure expects parameter @user, which was not supplied. Thanks
View Replies !
Email Not Being Sent...
I was attempting to send an e-mail from a package and it was not working correctly when I deployed to the remote DB server. I would simply get the "Failed sending mail" message. I was setting the SmtpServer property of the connection through a configuration file to the remote SMTP server IP address (was 127.0.0.1 for development). It turned out that the configuration setting was applied to the SMTP Connection Manager and the connection string would return the changed IP address BUT it was still connecting to the development 127.0.0.1 IP address. Once I changed the configuration property to be the connection string that was configured it functioned just fine. I will be logging this as a bug with MS but thought people might want to know about this... Fred
View Replies !
Email
I would like to automate a report to be emailed to an email address. When viewing the report, clicked on new subscription. In the subscription window what options should there be for Delievered By: ? I currently have: Report Server File Share in the drop down. Should there be other entries in the list too? Thanks
View Replies !
ERD Of An Email App
Hi, I've been asked to create a small application to send and receive emails with basic functionality like reply and forward messages. All of them will be stored in a sql database. I am mainly a programmer so I would like to know if you have any sample ERD I can use as a reference or if you can help me define the entities, I am not sure how I need to handle the "replied messages" and "Forwarded messages" Any help will be appreciated. Armando.
View Replies !
Sql + Email
Hello everyone I am working on a little project for work which get the relvant data every 2mins and puts the data into a Data Grid in ASP.net 2.0 Now my SQL scipt runs every 2min and i need to know if at a certain time i could tell the SQL script to run the report and email me the results??? any help would be great thanks alistair
View Replies !
DTS And Email
Hi all, I am using SQL 2000 and i have DTS packages that are used to trasfer data from a datasource to SQL server. i want to set up the packges so i get an email for every step that failes, so i use on failure send email for each step. the question is what do i use to send the email, i know DTS has a MailTask but is this the only option and how is that different from XP_sendmail?? Appreciate any help thanks
View Replies !
Email From Ftp
I have tried a few different stored procedures but i'm looking for away to send email from a server that does not have email enabled. (I want to pass in the smtp server and email and password. Does anyone know of any script?
View Replies !
INNER Join On Email
I have two tables both have email address in them I want to have a datagrid that shows which email addresses are in Table A (NZ) but not in B (Members) Here is the Code but it doesn't work SelectCommand="SELECT Members.Company,Members.UserEmail, NZ.F1UserEmail, NZ.StaffID FROM Members INNER JOIN NZ ON NZ.F1UserEmail <> Members.UserEmail WHERE (([Company] = @Company) OR ([Company] = @Company2)) "> Any ideas would be appreciated
View Replies !
Distinct Name And Email.
hey guys . you see how fenix.sn has a couple of entries BUT the same email and DIFFErENT BET IDS. okay this is what i wanna do. i wanna send an email to fenix.sn (just ONE email) saying you have won the following bets: xxx, xxx, xxx, xxx then i wanna delete the entreis from the table.
View Replies !
Email Error
the site i am working on is www.papertrailinvites.com on the left when you enter your email address and hit submit i get this error: Server Error in '/' Application. Must declare the scalar variable "@Email". Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Email".Source Error: Line 29: Line 30: conn.Open(); Line 31: cmd.ExecuteNonQuery(); Line 32: Line 33: } My code is below: protected void Button1_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) { string email = Newsletter_Email.Text; SqlCommand cmd = new SqlCommand("INSERT INTO Email (EmailAddress) Values (@Email)", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Name", email); conn.Open(); cmd.ExecuteNonQuery(); } }
View Replies !
Select_identity() Sent Through Email...
Ok i'm new to asp but familiar with other server side scripting languages. I'm writing a simple query to insert data into a table, then i want to be able to email someone saying data has been inserted. The problem I am having is i want to be able to add a link to go straight to the page that shows the information of the inserted data. so i figure a .asp?id=???? I have researched select_identity() for this method, but am unable to figure out exactly how I am supposed to code this. Any help or alternative methods would be appreciated. Thanks.
View Replies !
Send Email Through SQL
Hi all, can i send an email through SQL? i don't want to use third party software. Also, i can't configure the customer's db server. It is possible to send an email without much configuration. If configuration needed, is it possible to configure through SQL script? thx
View Replies !
Email Trigger
Hello Can you setup a trigger to mail some one when a record is updated in SQL server 2005? If you can, can anyone help me? C
View Replies !
Email Alert
I'm trying to develop a email alert feature on my project. I was trying to approach with SQL trigger wich I think is the best option. Basically, when a new record is inserted into ad table, a email alert goes to peolpe who selected to receive alert wehen certain conditions are met. What would be the best approach? any examples?Thanks
View Replies !
Sending SQL Email
I have developed a B2B Application which is successfully running, now the problem is that my client says that he need a process which sends report of total orders on daily bases. I am using SQL Server and think that SQL Mail is a good idea, I can find many articles about which needs Outlook for that which is much difficult on the web server. Remember I need to send email only not to receive. Thanks, any reply will be highly appreciated.
View Replies !
Auto Email
Hi All, I want to write a console application to send email. There is a Date field in the SQL Server and I need to send email 2 weeks before that date.I have no idea how to write a console application and make it work.Does anybody have code for this? If so please post it. Thanks a lot, Kumar.
View Replies !
Email On Insert
Hi all,I wanted sql server to shoot an email upon insert into a table. I treated atrigger on that table as below.CREATE TRIGGER [emailoninsert] ON [dbo].[table_name]FOR INSERTASexec sp_sendSMTPmail 'user@user.com', 'New records are inserted intable_name table', 'Please investigate and take necessary actions.',@cc='', @BCC = '',@Importance=1,@Attachments='', @HTMLFormat = 0,@From ='notification@sqlserver.com'Is this solution a good method?Thanks,Guju
View Replies !
Help Sending Email
My code below works fine when run from my pc (changed all the values forobvious reasons). The code is placed inside a DTS task via VBS scripting.But when I try to run directly from the server where sqlserver is installed,the script fails.I have SMTP running, but there is no outlook installed.Can someone please advise what I am missing.ThanksBobSet objEmail = CreateObject("CDO.Message")objEmail.From = "send@test.com"objEmail.To = "receive@test.com"objEmail.Subject = "TEST SUBJECT"objEmail.AddAttachment "\server est.csv"objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "SERVER_NAME"objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username"objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "userpwd"objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25objEmail.Configuration.Fields.UpdateobjEmail.Sendset objEmail = nothing
View Replies !
EMAIL From SQL Express
HelloJust figured out that database mail is not available in SQL Express.Anyone have any ideas on how I can send mail from sql express ... aspart of a trigger ?RegardsRob
View Replies !
Email Being Sent, But No Message
I have setup an email notifications system, that basically takes eachrow from a table and sents out an email according to the data in thatrow. The emails get sent, with the subject being filled as expected.Only problem is that sometimes there is no message.Here is the stored procedure that is being called every hour to sendthe emails:CREATE PROCEDURE dbo.RemindersSendEmails AS--CursorDECLARE RemindersCursor CURSOR FORSELECT *FROM RemindersTodaysAndUnsent--Values for cursorDECLARE@I_Reminder_ID bigint,@I_Notice_ID bigint,@V_Reminder_Text varchar(250),@SDT_Reminder_Date smalldatetime,@V_Email varchar(50),@I_Reminder_Type bigint,@SDT_Reminder_Sent smalldatetime,@I_Attempts_Made int,@V_Notice_Type varchar(50),@I_Notice_Period int,@V_Period_Description varchar(50),@I_Project_ID bigint,@V_Notice_Ref varchar(10)--values for sending the mailDECLARE @NEWLINE varchar(2)OPEN RemindersCursorFETCH NEXT FROM RemindersCursorINTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,@I_Project_ID, @V_Notice_Ref--INTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,--@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,--@I_Project_ID, @V_Notice_RefSET @NEWLINE = char(10)--PRINT 'start'WHILE @@FETCH_STATUS = 0BEGINDECLARE @EmailMessage varchar(6000), @Subject varchar(100), @StatusintSET @Subject = RTRIM(CONVERT(varchar(8), @I_Reminder_ID)) + ' NoticeAlert - Project ' + RTRIM(CONVERT(varchar(8), @I_Project_ID)) + 'Notice Ref ' + RTRIM(@V_Notice_Ref)SET @EmailMessage = 'Project: ' + RTRIM(CONVERT(varchar(8),@I_Project_ID)) + @NEWLINE +'Notice: ' + RTRIM(@V_Notice_Ref) + @NEWLINE +'Notice Type: ' + RTRIM(@V_Notice_Type) + ' - ' +RTRIM(@V_Period_Description) + @NEWLINE +'Reminder: ' + RTRIM(@V_Reminder_Text) + @NEWLINE + @NEWLINE +'Reminder date: ' + CONVERT(varchar(11), @SDT_Reminder_Date) +@NEWLINE +'Reminder sent: ' + CONVERT(varchar(11), GETDATE()) + @NEWLINE +'Email sent to: ' + @V_Email + @NEWLINE +'Number of attempts made at sending this email (once every hour): '+ CONVERT(varchar(4), @I_Attempts_Made)--@I_Reminder_ID, @I_Notice_ID, @V_Email, @I_Reminder_Type,@I_Notice_Period,PRINT 'subject = ' + @SubjectPRINT 'message = ' + @EmailMessageSET @V_Email = LTRIM(RTRIM(@V_Email))EXEC @Status = master..xp_sendmail @recipients = @V_Email,@message = @EmailMessage,@subject = @Subject--PRINT 'XXXXXXXXXXXXXXXXXXXXXX status = ' + CONVERT(varchar(2),@Status)--If send mail is a successIF (@Status = 0)BEGINUPDATE RemindersSET SDT_Reminder_Sent = GETDATE(), I_Attempts_Made =@I_Attempts_Made + 1WHERE I_Reminder_ID = @I_Reminder_IDEND--Else send mail failedELSEBEGINUPDATE RemindersSET I_Attempts_Made = @I_Attempts_Made + 1WHERE I_Reminder_ID = @I_Reminder_IDEND-- Get the next reminderFETCH NEXT FROM RemindersCursorINTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,@I_Project_ID, @V_Notice_RefEND--PRINT 'End'CLOSE RemindersCursorDEALLOCATE RemindersCursorGO
View Replies !
SQL Email Trigger
Hi, I am looking for a SQL trigger that will send email notification to a mailing list whenever a folders contents have been changed. Can anyone help on this as I have little to no experience with SQL??
View Replies !
Anyone Know About Parsing An Email?
Hello everyone Heres what it looks like: I have a large file of over 40k email records. The emails are all mixed up and come in various formats but i noticed that most of them are in this format: firstname.lastname@email.com firstname.middlename.lastname@email.com For all those emails with the period (.) in between, the (.) actually separates an individuals first and last name. My task is this, to separate all the emails that are in this format into first and last name fields. I'm stimped folks and I'll really appreciate any pointers or ideas on how to go about solving this task. Thanks
View Replies !
Email Task
In my DTS package I tried to make an email task and it works if I execute it manualy, but if I schedule it I get the following error: DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_16 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_16 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 8 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Erro... Process Exit Code 1. The step failed. What could it be?
View Replies !
Need Help On Email Setup
I can't use the SQL Server Mail but I heard if I have an exchange server with SMTP I can still use SQL Server Stored Procs to send emails . can someone please explain or direct me to it
View Replies !
Alerts To Email
Hi all! I'm trying to configure MS SQL Server 6.5 to be able to send alerts to email and eventually to pagers. We are currently running NT 4.0. Unfortunately, the training class I took used NT 3.5.1, and I'm having trouble figuring out how to set up the NT Mail Client and the SQL Mail Client. Our company email facility is Novell's Groupwise, which I believe is MAPI compliant, so I think we can use it as the post office. If anyone has experience setting up alerts for email, I would be very interested to hear from you. TIA, Wayne Kline PMI Group
View Replies !
Email Operator
How do you modify the email operator, or delete an email operator from the TSQL TASK OPTION in the MANAGED SCHEDULE TASK option in the SQL executive manager. We have couple of people who has left or their pager numbers are changed due to change in Area code. Please help Thanks in advance! Raj
View Replies !
|
TRACKER
