Hi,
I have a program continously updating an SQL (using Microsoft 2005 Server for Management) database, and I need to set up a way that when ever a certain column or tag is generated to the database, an alert is forwarded to my e-mail, through VB or C or whatever can handle this. Any help would be terrific, thanks.
Myself and a user have the same issue which is when we hit forward and type our reply, spell check checks the entire email. I want it to just check what I wrote.
We both have Ignore original message text in reply or forward checked off under, Tools, Options & Spelling
This does not help.
Any suggestions
Thank you,
Tom
Hi There
Anyone have a good resource for a forwarding example ?
I have a distributed service broker application working but i would like to add a forwarder in the mix, all i can find in BOL is that you must create an endpoint for forwarding and create the correct routes on a frowarder but thats it.
Is that all you require ? AN instance with a forwarding endpoint correct routes ?
I am looking for an actual example, cannot find anything in BOL on how to actually implement it ?
I downloaded forwarder1.1 example from getdotnet.com, but that example sucks, it does even create routes ???
Thanx
I have been triyng to find an explanation for this error everywhere, but so far have been unsuccessful:
Cyclical forwarding detected for event 17806: Event source was 'SP-MINCL-WDB04' which matches the current forwarding server. The event was not forwarded.
Does anyone know what this means?
Thanks!
Hi There
I am doing the follwing , sending a message from initiator A to service73 at targetA.
I am profiling the initiator, forwarer and target.
At the initiator everything is 100%, at the forwarder message is forwarded 100%.
I am receiving the following error at the target:
Could not forward the message because forwarding is disabled in this SQL Server instance.
Now i have had these errors before, this was due to the fact that the service did not exist at the target or the service name was incorrect etc.
I have check , service73 exists and is fully functional at the target, all message types, contracts etc are all 100%.
Queue for service73 is enabled 100%
please help.
Thanx
Hi,
I have a program continously updating an SQL (using Microsoft 2005 Server for Management) database, and I need to set up a way that when ever a certain column or tag is generated to the database, an alert is forwarded to my e-mail, through VB or C or whatever can handle this. Any help would be terrific, thanks.
I am trying to centralize my alerts and events forwarding using this feature in SQL server 2000. I setup event forwading in every one of my satellite SQL servers, however I am not getting any events or notifications.
Anybody has worked on this or know of any good information on this topic.
Hi,
Is there any concerns or problems with forward a port to SQL server
from our internet firewall so that you can access the databases over the internet? Is it a standard practice to do this in order to remotely access the SQL server. Or is there a better way to do this? Also, if it is ok to do this are any things you need to do to enhance your security from vulnerabilities being open to the internet.
Any suggestions or comments would be appreciated on this subject.
Thanks
Hi,
I have to add the fields coming from the source AS IS but, I need to add current date as a column to it. So, What I do is to add an Script Component and add each and every output column in that along with defining their types and writing an "assignments" script.
Is there any possibility for me to save time in the scenarios where I am almost passing on the information to next level in the data flow ?
Any input regarding this will sincerely be appreciated.
Fahad
I know that SQL Servers can be set up to forward alerts to a singleSQL Server. I am wondering if same would be true for the MaintenancePlan Reports. Basically, I want to have only one SQL Server on thenetwork that has the SQL Agent Mail profile set up, and to use thatserver for all e-mail and/or pager notifications for all alerts andevents raised by any of the SQL Servers on the network, includingMaintenance Plan reports. Is this possible? Is anything required toset this up beyond alerts forwarding?Alexey Aksyonenko
View 1 Replies View RelatedI have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.
View 2 Replies View RelatedUnder 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
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'
I have a problem regarding forwarding 'n number of parameters' from Visual Studio 2005 using VB to SQL-Server 2005 stored procedure.I have to save N number of rows in my stored procedure as a transaction. If all rows are not saved successfully, I have to roll-back else update some other table also after that. I am unable to handle - How to send variable number of parameters from Visual Stduio to Sql - Server ? My requirement is to use the SQL-Stored Procedure to store all the rows in the base table and related tables and then update one another table based on the updations done. Please Help .....
View 1 Replies View RelatedHello ALL
what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.
I also want to update some users using a different text file.
Please help me with the best way to do this
Thanks in advance
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
Is there a way SQL server to email/send a query results to a user ?
Thanks in advance.
Ivan
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?
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.
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 1 Replies View RelatedHi 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
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 1 Replies View RelatedHow can I implement the functionality of sending mail with the help of SP or DTS?
Subhasish
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?
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
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 1 Replies View RelatedEXEC 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
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.
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
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 8 Replies View RelatedOk 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 8 Replies View Relatedthe 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();
}
}
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.