Deadlocks increasing

I have setup a SQL alert that email's me if deadlocks occur. I recently
started getting flooded with alot of emails(see below) with deadlocks. The
current value does not drop back down, it remains at 4 until I restart the
SQL server. This has happened once in the past before, about 3 weeks ago.
We fixed it by restarting the server. I have DBCC OPENTRAN on all databases
and there are no active transaction open. Perfmon shows that I have 0
deadlocks but still I get these emails. Turning trace 1204 also shows me 0
deadlocks occurring. Can someone help me.
Tim
DATE/TIME: 10/13/2004 10:24:02 AM
DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
(instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
threshold of 3.00 (the current value is 4.00).
COMMENT: (None)
JOB RUN: (None)
More information to supply:
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>
|||More information:
select * from sysperfinfo where counter_name = 'Number of Deadlocks/sec'
object_name counter_name instance_name cntr_value cntr_type
MSSQL$INST01:Locks Number of Deadlocks/sec Extent 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Key 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Page 4 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Table 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec RID 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Database 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec _Total 4 272696320
I have 4 page deadlocks that will not release or reset. SP_LOCK shows no
current page locks.
Tim
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>
|||Hi Tim,
To troubleshoot this issue, there would be several other things to try and
to check. However, as this is an issue that happens randomly, we may spend
extensive time to narrow it down since random issues are always hard to
troubleshoot. I would like to recommend that you contact Microsoft Product
Support Services and open a support incident and work with a dedicated
Support Professional.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
For now, from your descriptions, I understood that something were blocked
more frequently than you had exptected. Have I understood you? Correct me
if I was wrong.
Based on my scope, you'd better follow the instrunctions in KB below to
collect more information and what cause the block. Blocking could becaused
by various factors
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/kb/224453/en-us
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Deadlocks increasing

I have setup a SQL alert that email's me if deadlocks occur. I recently
started getting flooded with alot of emails(see below) with deadlocks. The
current value does not drop back down, it remains at 4 until I restart the
SQL server. This has happened once in the past before, about 3 weeks ago.
We fixed it by restarting the server. I have DBCC OPENTRAN on all databases
and there are no active transaction open. Perfmon shows that I have 0
deadlocks but still I get these emails. Turning trace 1204 also shows me 0
deadlocks occurring. Can someone help me.
Tim
----
--
DATE/TIME: 10/13/2004 10:24:02 AM
DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
(instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
threshold of 3.00 (the current value is 4.00).
COMMENT: (None)
JOB RUN: (None)More information to supply:
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||More information:
select * from sysperfinfo where counter_name = 'Number of Deadlocks/sec'
object_name counter_name instance_name cntr_value cntr_type
MSSQL$INST01:Locks Number of Deadlocks/sec Extent 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Key 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Page 4 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Table 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec RID 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Database 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec _Total 4 272696320
I have 4 page deadlocks that will not release or reset. SP_LOCK shows no
current page locks.
Tim
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||Hi Tim,
To troubleshoot this issue, there would be several other things to try and
to check. However, as this is an issue that happens randomly, we may spend
extensive time to narrow it down since random issues are always hard to
troubleshoot. I would like to recommend that you contact Microsoft Product
Support Services and open a support incident and work with a dedicated
Support Professional.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
For now, from your descriptions, I understood that something were blocked
more frequently than you had exptected. Have I understood you? Correct me
if I was wrong.
Based on my scope, you'd better follow the instrunctions in KB below to
collect more information and what cause the block. Blocking could becaused
by various factors
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/kb/224453/en-us
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!sql

Deadlocks increasing

I have setup a SQL alert that email's me if deadlocks occur. I recently
started getting flooded with alot of emails(see below) with deadlocks. The
current value does not drop back down, it remains at 4 until I restart the
SQL server. This has happened once in the past before, about 3 weeks ago.
We fixed it by restarting the server. I have DBCC OPENTRAN on all databases
and there are no active transaction open. Perfmon shows that I have 0
deadlocks but still I get these emails. Turning trace 1204 also shows me 0
deadlocks occurring. Can someone help me.
Tim
----
--
DATE/TIME: 10/13/2004 10:24:02 AM
DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
(instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
threshold of 3.00 (the current value is 4.00).
COMMENT: (None)
JOB RUN: (None)More information to supply:
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||More information:
select * from sysperfinfo where counter_name = 'Number of Deadlocks/sec'
object_name counter_name instance_name cntr_value cntr_type
MSSQL$INST01:Locks Number of Deadlocks/sec Extent 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Key 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Page 4 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Table 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec RID 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Database 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec _Total 4 272696320
I have 4 page deadlocks that will not release or reset. SP_LOCK shows no
current page locks.
Tim
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||Hi Tim,
To troubleshoot this issue, there would be several other things to try and
to check. However, as this is an issue that happens randomly, we may spend
extensive time to narrow it down since random issues are always hard to
troubleshoot. I would like to recommend that you contact Microsoft Product
Support Services and open a support incident and work with a dedicated
Support Professional.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
For now, from your descriptions, I understood that something were blocked
more frequently than you had exptected. Have I understood you? Correct me
if I was wrong.
Based on my scope, you'd better follow the instrunctions in KB below to
collect more information and what cause the block. Blocking could becaused
by various factors
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/kb/224453/en-us
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

DDS Sends multiple emails. Bug?

Hi,
can anyone tell me what's going on here.
I BCC myself on all data driven subscriptions to ensure people are receiving
their subscriptions and there is no funny business going on.
In one case, the query for my data driven subscription returns one record.
So I should only get one email sent out. However, 2 emails are being
posted.
In other cases however, the correct emails are sent.
Is this a bug? Or is something happening that is causing RS to
occaisionally pick up duplicates?
thanks
MattDDS should not send out duplicate emails. The log files should give you
some hint if the same notification is being processed twice.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:#HDHciTlEHA.896@.TK2MSFTNGP12.phx.gbl...
> Hi,
> can anyone tell me what's going on here.
> I BCC myself on all data driven subscriptions to ensure people are
receiving
> their subscriptions and there is no funny business going on.
> In one case, the query for my data driven subscription returns one record.
> So I should only get one email sent out. However, 2 emails are being
> posted.
> In other cases however, the correct emails are sent.
> Is this a bug? Or is something happening that is causing RS to
> occaisionally pick up duplicates?
> thanks
> Matt
>|||I have this same issue, although mine isn't a DDS. Just a standard
subscription. I had one that sent to multiple people, but they were
getting two emails every morning so I disabled it to test out the
issue. I created a new subscription last night and when I came in this
morning, I had THREE emails waiting for me. All had the exact same
time stamp down to the second. I have no idea why it would deliver to
me three times, but this is obviously a big issue.
Does anyone have any insights into what causes this? Most of my
subscriptions work just fine. But there's just something off with a
few of these.
Alison
On Wed, 8 Sep 2004 08:14:43 +0800, "Matt"
<NoSpam:Matthew.Moran@.Computercorp.com.au> wrote:
>Hi,
>can anyone tell me what's going on here.
>I BCC myself on all data driven subscriptions to ensure people are receiving
>their subscriptions and there is no funny business going on.
>In one case, the query for my data driven subscription returns one record.
>So I should only get one email sent out. However, 2 emails are being
>posted.
>In other cases however, the correct emails are sent.
>Is this a bug? Or is something happening that is causing RS to
>occaisionally pick up duplicates?
>thanks
>Matt
>

DBMail used for job and alert emails

Can you use DBMail for job and alert emails without having to resort to usin
g
the DBMail stored procs? I have DBMail setup and the test email works fine
but when I run a job and expect to see a completion email send to a defined
operator no email occurs but neither does any error stating why the email wa
s
not sent. I have told SQLAgent to use DBMail and a specified account so I a
m
unsure what else I need to do.Any errors on the Database Mail Log? (Right-click Database Mail and select
View Database Mail Log).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jerry Boggess" wrote:

> Can you use DBMail for job and alert emails without having to resort to us
ing
> the DBMail stored procs? I have DBMail setup and the test email works fin
e
> but when I run a job and expect to see a completion email send to a define
d
> operator no email occurs but neither does any error stating why the email
was
> not sent. I have told SQLAgent to use DBMail and a specified account so I
am
> unsure what else I need to do.|||Database Mail alerts did not work for me until after applying SQL 2005 SP1.
"Jerry Boggess" <JerryBoggess@.discussions.microsoft.com> wrote in message
news:BF1A9E66-BDEB-4E53-B43A-693BE8BC4112@.microsoft.com...
> Can you use DBMail for job and alert emails without having to resort to
> using
> the DBMail stored procs? I have DBMail setup and the test email works
> fine
> but when I run a job and expect to see a completion email send to a
> defined
> operator no email occurs but neither does any error stating why the email
> was
> not sent. I have told SQLAgent to use DBMail and a specified account so I
> am
> unsure what else I need to do.|||I found the issue. When you alter a DBMail configuration you need to restar
t
SQL Server Agent. The SQL Server Agent retains the last DBMail setting that
was available when the Agent started. Since I had no DBMail the last time
SQL Server Agent had been started it did not care what I was doing with
DBMail until I started the Agent again and then it refreshed its information
and worked fine.
This means any changes to an existing configuration of DBMail will also
require a restart of SQL Server Agent otherwise the Agent will be using the
configuration that existed when it started last. I was hoping for more of a
dynamic communication between DBMail and SQL Server Agent but it is working
now for jobs and alerts so hooray.
"Michael D'Angelo" wrote:

> Database Mail alerts did not work for me until after applying SQL 2005 SP1
.
> "Jerry Boggess" <JerryBoggess@.discussions.microsoft.com> wrote in message
> news:BF1A9E66-BDEB-4E53-B43A-693BE8BC4112@.microsoft.com...
>
>

DBMail used for job and alert emails

Can you use DBMail for job and alert emails without having to resort to using
the DBMail stored procs? I have DBMail setup and the test email works fine
but when I run a job and expect to see a completion email send to a defined
operator no email occurs but neither does any error stating why the email was
not sent. I have told SQLAgent to use DBMail and a specified account so I am
unsure what else I need to do.Any errors on the Database Mail Log? (Right-click Database Mail and select
View Database Mail Log).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jerry Boggess" wrote:
> Can you use DBMail for job and alert emails without having to resort to using
> the DBMail stored procs? I have DBMail setup and the test email works fine
> but when I run a job and expect to see a completion email send to a defined
> operator no email occurs but neither does any error stating why the email was
> not sent. I have told SQLAgent to use DBMail and a specified account so I am
> unsure what else I need to do.|||Database Mail alerts did not work for me until after applying SQL 2005 SP1.
"Jerry Boggess" <JerryBoggess@.discussions.microsoft.com> wrote in message
news:BF1A9E66-BDEB-4E53-B43A-693BE8BC4112@.microsoft.com...
> Can you use DBMail for job and alert emails without having to resort to
> using
> the DBMail stored procs? I have DBMail setup and the test email works
> fine
> but when I run a job and expect to see a completion email send to a
> defined
> operator no email occurs but neither does any error stating why the email
> was
> not sent. I have told SQLAgent to use DBMail and a specified account so I
> am
> unsure what else I need to do.|||I found the issue. When you alter a DBMail configuration you need to restart
SQL Server Agent. The SQL Server Agent retains the last DBMail setting that
was available when the Agent started. Since I had no DBMail the last time
SQL Server Agent had been started it did not care what I was doing with
DBMail until I started the Agent again and then it refreshed its information
and worked fine.
This means any changes to an existing configuration of DBMail will also
require a restart of SQL Server Agent otherwise the Agent will be using the
configuration that existed when it started last. I was hoping for more of a
dynamic communication between DBMail and SQL Server Agent but it is working
now for jobs and alerts so hooray.
"Michael D'Angelo" wrote:
> Database Mail alerts did not work for me until after applying SQL 2005 SP1.
> "Jerry Boggess" <JerryBoggess@.discussions.microsoft.com> wrote in message
> news:BF1A9E66-BDEB-4E53-B43A-693BE8BC4112@.microsoft.com...
> > Can you use DBMail for job and alert emails without having to resort to
> > using
> > the DBMail stored procs? I have DBMail setup and the test email works
> > fine
> > but when I run a job and expect to see a completion email send to a
> > defined
> > operator no email occurs but neither does any error stating why the email
> > was
> > not sent. I have told SQLAgent to use DBMail and a specified account so I
> > am
> > unsure what else I need to do.
>
>

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

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

DB Mail sends to an SMTP server. You need to configure the SMTP server to return bounced emails.

Normally, this goes to "postmaster,sender" as a default.

|||

That makes sense, I just found I set dbmail profile to use relay server, which runs Kerio email, I guess it is Kerio SMTP which send out the email, then the setting need to be done on Kerio.

Thanks