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.Hiya Des...I'm sure others more knowledgeable will soon come to your rescue, but I don't think there are that kind of specific email options in xp_sendmail. However, Though I use the xp_sendmail quite a bit, I am no expert (as my recent thread posting shows).

HOWEVER, that said, perhaps you could send a "regular" email to your user from SQL Server, then set up some rules in Outlook to massage the necessary options and forward the email on to the appropriate customers? I know that's kinda a round-about way to get there, but it seems to me that it would work if nobody comes up with a definitive answer from SQL Server...

Just a thought

Email delivery not functioning

I am trying to set up automatic email delivery on our production reporting
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>

Effect of "Do not recompute statistics" option

I'm looking into the automatic recompilation of stored procedures and
I have been reading up on the "Do not recompute statistics" option on
indexes.

Am I correct in concluding that disabling the "Do not recompute
statistics" option for an index, will ensure that no automatic
recompilations will occur as a result of updates to data in that
index?

Am I also correct in understanding that the "Update Statistics" will
still update statistics for the index even if the "Do not recompute
statistics" option is disabled?

Regards

BjrnBjrn (bjornsuneandersen@.gmail.com) writes:

Quote:

Originally Posted by

I'm looking into the automatic recompilation of stored procedures and
I have been reading up on the "Do not recompute statistics" option on
indexes.
>
Am I correct in concluding that disabling the "Do not recompute
statistics" option for an index, will ensure that no automatic
recompilations will occur as a result of updates to data in that
index?
>
Am I also correct in understanding that the "Update Statistics" will
still update statistics for the index even if the "Do not recompute
statistics" option is disabled?

That is how I would read it to. I would still prefer to use sp_autostats
turn autostats off/on.

What sort of table are you considering to turn off autostats for? It seems
to me that this mainly is useful with tables that are modest in size, but
which are updated frequently.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx