Outlook vs. cdosysmail SQL 2000

Hello everyone,

I'm trying to get a feeling of which method of setting up e-mail notifcations is more used and why. I'm finding that once Outlook is set up on a server using the e-mail functions are pretty straight forward and flexable. I've also been experimenting with using cdosysmail so I can avoid installing and configuring Outlook, but it's a big more of a work around.

What do you do?

Thanks

Using MAPI on SQL Server 2000 is generally considered a unnecessary risk.

I suggest that you examine using xp_smtpmail instead. Refer to this thread for more information.

Outlook locked when using sql 2005 - please help

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
email operator and defined notifications on a job to send out emails when job
completes.
The issue is the my outlook client on the server gets locked once sql server
agent is started and no emails get sent out when the job is executed.
I get the message - Unable to open your default email folders....when
opening outlook.
It is outlook 2003, we are using POP as email and sql is 2005 standard.
The email notifications are only sent out when I stop the sql server agent,
open outlook, close it and then start sql server agent again.Jack wrote:
> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when job
> completes.
> The issue is the my outlook client on the server gets locked once sql server
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent,
> open outlook, close it and then start sql server agent again.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?|||No, we do not have one.
"Tracy McKibben" wrote:
> Jack wrote:
> > I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> > email operator and defined notifications on a job to send out emails when job
> > completes.
> >
> > The issue is the my outlook client on the server gets locked once sql server
> > agent is started and no emails get sent out when the job is executed.
> >
> > I get the message - Unable to open your default email folders....when
> > opening outlook.
> >
> > It is outlook 2003, we are using POP as email and sql is 2005 standard.
> >
> > The email notifications are only sent out when I stop the sql server agent,
> > open outlook, close it and then start sql server agent again.
> >
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.

Outlook locked when using sql 2005 - please help

Jack wrote:
> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when
job
> completes.
> The issue is the my outlook client on the server gets locked once sql serv
er
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent
,
> open outlook, close it and then start sql server agent again.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?No, we do not have one.
"Tracy McKibben" wrote:

> Jack wrote:
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.|||I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
email operator and defined notifications on a job to send out emails when jo
b
completes.
The issue is the my outlook client on the server gets locked once sql server
agent is started and no emails get sent out when the job is executed.
I get the message - Unable to open your default email folders....when
opening outlook.
It is outlook 2003, we are using POP as email and sql is 2005 standard.
The email notifications are only sent out when I stop the sql server agent,
open outlook, close it and then start sql server agent again.|||Jack wrote:
> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when
job
> completes.
> The issue is the my outlook client on the server gets locked once sql serv
er
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent
,
> open outlook, close it and then start sql server agent again.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?|||No, we do not have one.
"Tracy McKibben" wrote:

> Jack wrote:
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.

Outlook locked when using sql 2005

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
email operator and defined notifications on a job to send out emails when jo
b
completes.
The issue is the my outlook client on the server gets locked once sql server
agent is started and no emails get sent out when the job is executed.
I get the message - Unable to open your default email folders....when
opening outlook.
It is outlook 2003, we are using POP as email and sql is 2005 standard.
The email notifications are only sent out when I stop the sql server agent,
open outlook, close it and then start sql server agent again.Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:

> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when
job
> completes.
> The issue is the my outlook client on the server gets locked once sql serv
er
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent
,
> open outlook, close it and then start sql server agent again.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Is there any reason why you are not using Database Mail? You would not nee
d
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
>|||Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:

> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when
job
> completes.
> The issue is the my outlook client on the server gets locked once sql serv
er
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent
,
> open outlook, close it and then start sql server agent again.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Is there any reason why you are not using Database Mail? You would not nee
d
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
>sql

Outlook locked when using sql 2005

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
email operator and defined notifications on a job to send out emails when job
completes.
The issue is the my outlook client on the server gets locked once sql server
agent is started and no emails get sent out when the job is executed.
I get the message - Unable to open your default email folders....when
opening outlook.
It is outlook 2003, we are using POP as email and sql is 2005 standard.
The email notifications are only sent out when I stop the sql server agent,
open outlook, close it and then start sql server agent again.Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:
> I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when job
> completes.
> The issue is the my outlook client on the server gets locked once sql server
> agent is started and no emails get sent out when the job is executed.
> I get the message - Unable to open your default email folders....when
> opening outlook.
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
> The email notifications are only sent out when I stop the sql server agent,
> open outlook, close it and then start sql server agent again.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
> Is there any reason why you are not using Database Mail? You would not need
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
> > I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> > email operator and defined notifications on a job to send out emails when job
> > completes.
> >
> > The issue is the my outlook client on the server gets locked once sql server
> > agent is started and no emails get sent out when the job is executed.
> >
> > I get the message - Unable to open your default email folders....when
> > opening outlook.
> >
> > It is outlook 2003, we are using POP as email and sql is 2005 standard.
> >
> > The email notifications are only sent out when I stop the sql server agent,
> > open outlook, close it and then start sql server agent again.

out join, need configuration?

Hello:
I tried a query with outer join in SQL Analyzer, but it does not work as
expected. Is there any configuration/setting I need to do in SQL server, in
order to make it work?
Thanks.
QHi,
There is no configuration change need to be made to make outer joins change
its behaviour.
Thanks
Hari
SQL Server MVP
"Q" <Q@.discussions.microsoft.com> wrote in message
news:7ACD64A0-A4C2-4BF4-BDE0-36C3A26469AD@.microsoft.com...
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server,
in
> order to make it work?
> Thanks.
> Q|||Hi
There are no setting that are required to be changed.
Probably you require to change the order of the TABLES that you are using.
LEFT / RIGHT OUTER Joins..
Hope this solved your problem
thanks and regards
Chandra
"Q" wrote:

> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server,
in
> order to make it work?
> Thanks.
> Q|||Thanks for all your replies! For some reason LEFT/RIGHT outer does not work
.
But *= or =* does work.
Q
"Chandra" wrote:
[vbcol=seagreen]
> Hi
> There are no setting that are required to be changed.
> Probably you require to change the order of the TABLES that you are using.
> LEFT / RIGHT OUTER Joins..
> Hope this solved your problem
> thanks and regards
> Chandra
>
> "Q" wrote:
>|||My guess is that you are filtering in the WHERE clause and for an ANSI join,
you need to put that
filter in the FROM clause. "Doesn't work" is not a good problems description
. Posting the error
message, or describing in what way you get unexpected result back is a bette
r problem description.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Q" <Q@.discussions.microsoft.com> wrote in message
news:F911E946-0796-49C9-B665-27525C761E32@.microsoft.com...[vbcol=seagreen]
> Thanks for all your replies! For some reason LEFT/RIGHT outer does not wo
rk.
> But *= or =* does work.
> Q
> "Chandra" wrote:
>

out join, need configuration?

Hello:
I tried a query with outer join in SQL Analyzer, but it does not work as
expected. Is there any configuration/setting I need to do in SQL server, in
order to make it work?
Thanks.
QHi,
There is no configuration change need to be made to make outer joins change
its behaviour.
Thanks
Hari
SQL Server MVP
"Q" <Q@.discussions.microsoft.com> wrote in message
news:7ACD64A0-A4C2-4BF4-BDE0-36C3A26469AD@.microsoft.com...
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server,
in
> order to make it work?
> Thanks.
> Q|||Hi
There are no setting that are required to be changed.
Probably you require to change the order of the TABLES that you are using.
LEFT / RIGHT OUTER Joins..
Hope this solved your problem
thanks and regards
Chandra
"Q" wrote:
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server, in
> order to make it work?
> Thanks.
> Q|||Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
But *= or =* does work.
Q
"Chandra" wrote:
> Hi
> There are no setting that are required to be changed.
> Probably you require to change the order of the TABLES that you are using.
> LEFT / RIGHT OUTER Joins..
> Hope this solved your problem
> thanks and regards
> Chandra
>
> "Q" wrote:
> > Hello:
> >
> > I tried a query with outer join in SQL Analyzer, but it does not work as
> > expected. Is there any configuration/setting I need to do in SQL server, in
> > order to make it work?
> >
> > Thanks.
> >
> > Q|||My guess is that you are filtering in the WHERE clause and for an ANSI join, you need to put that
filter in the FROM clause. "Doesn't work" is not a good problems description. Posting the error
message, or describing in what way you get unexpected result back is a better problem description.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Q" <Q@.discussions.microsoft.com> wrote in message
news:F911E946-0796-49C9-B665-27525C761E32@.microsoft.com...
> Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
> But *= or =* does work.
> Q
> "Chandra" wrote:
>> Hi
>> There are no setting that are required to be changed.
>> Probably you require to change the order of the TABLES that you are using.
>> LEFT / RIGHT OUTER Joins..
>> Hope this solved your problem
>> thanks and regards
>> Chandra
>>
>> "Q" wrote:
>> > Hello:
>> >
>> > I tried a query with outer join in SQL Analyzer, but it does not work as
>> > expected. Is there any configuration/setting I need to do in SQL server, in
>> > order to make it work?
>> >
>> > Thanks.
>> >
>> > Q

out join, need configuration?

Hello:
I tried a query with outer join in SQL Analyzer, but it does not work as
expected. Is there any configuration/setting I need to do in SQL server, in
order to make it work?
Thanks.
Q
Hi,
There is no configuration change need to be made to make outer joins change
its behaviour.
Thanks
Hari
SQL Server MVP
"Q" <Q@.discussions.microsoft.com> wrote in message
news:7ACD64A0-A4C2-4BF4-BDE0-36C3A26469AD@.microsoft.com...
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server,
in
> order to make it work?
> Thanks.
> Q
|||Hi
There are no setting that are required to be changed.
Probably you require to change the order of the TABLES that you are using.
LEFT / RIGHT OUTER Joins..
Hope this solved your problem
thanks and regards
Chandra
"Q" wrote:

> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server, in
> order to make it work?
> Thanks.
> Q
|||Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
But *= or =* does work.
Q
"Chandra" wrote:
[vbcol=seagreen]
> Hi
> There are no setting that are required to be changed.
> Probably you require to change the order of the TABLES that you are using.
> LEFT / RIGHT OUTER Joins..
> Hope this solved your problem
> thanks and regards
> Chandra
>
> "Q" wrote:
|||My guess is that you are filtering in the WHERE clause and for an ANSI join, you need to put that
filter in the FROM clause. "Doesn't work" is not a good problems description. Posting the error
message, or describing in what way you get unexpected result back is a better problem description.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Q" <Q@.discussions.microsoft.com> wrote in message
news:F911E946-0796-49C9-B665-27525C761E32@.microsoft.com...[vbcol=seagreen]
> Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
> But *= or =* does work.
> Q
> "Chandra" wrote:

osql with proxy account errors

I've got a proxy account set up that is working fine for DTS packages, etc.
I've also got an environmental variable set up for osql setting the user to
the proxy account. The problem I'm having is within a scheduled job, when I
execute this statement:
EXEC master..xp_cmdshell 'osql.exe -S OnyxRptServer -E -n -w 121 -Q "EXEC
SBTDataAudit.dbo.OrnumCshipnumScript" -o
" \\onyxrptserver\SBTDataAudits\Outputs\Cs
hipno_Ornum_Audit_Results.txt'
I'm getting an error saying my job owner doesn't have permissions to execute
xp_cmdshell.
My job owner is not a member of the sa server role, so I was thinking that
the proxy account user would pick up and execute the xp_cmdshell call.
Any help would be appreciated.
Thanks,
JoanFrom BOL:
"If you choose to use a Windows NT account that is not a member of the local
administrator's group for the MSSQLServer service, users who are not members
of the symin fixed server role cannot execute xp_cmdshell."
"jmeyers" wrote:

> I've got a proxy account set up that is working fine for DTS packages, etc
.
> I've also got an environmental variable set up for osql setting the user t
o
> the proxy account. The problem I'm having is within a scheduled job, when
I
> execute this statement:
> EXEC master..xp_cmdshell 'osql.exe -S OnyxRptServer -E -n -w 121 -Q "EXEC
> SBTDataAudit.dbo.OrnumCshipnumScript" -o
> " \\onyxrptserver\SBTDataAudits\Outputs\Cs
hipno_Ornum_Audit_Results.txt'
> I'm getting an error saying my job owner doesn't have permissions to execu
te
> xp_cmdshell.
> My job owner is not a member of the sa server role, so I was thinking that
> the proxy account user would pick up and execute the xp_cmdshell call.
> Any help would be appreciated.
> Thanks,
> Joan
>|||The proxy user is a local admin.
"Cris_Benge" wrote:
> From BOL:
> "If you choose to use a Windows NT account that is not a member of the loc
al
> administrator's group for the MSSQLServer service, users who are not membe
rs
> of the symin fixed server role cannot execute xp_cmdshell."
>
> "jmeyers" wrote:
>