how to configure SQL server 2000 Agent Mail to use outlook express

Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:
> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> > Hi,
> >
> > I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> > send out job notifications. On our SQL server 2000, I logged on as the
> > service account which runs both SQL server and SQL server agent. I was
> > able
> > to send mail manually from outlook express. But how should I make SQL
> > Agent
> > use outlook express? I've searched google but was not able to find any
> > step
> > by step instruction on that. I checked the properties of SQL Server
> > Agent.
> > Under the General tab, the Mail session is grayed out. I think that's
> > correct because outlook express doesn't have a profile. No other mail
> > configurations are available.
> >
> > I'd appreciate if anybody can shed some light or provide some pointers.
> >
> > Thanks,
> >
> > Bing
>

how to configure SQL server 2000 Agent Mail to use outlook express

Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
Bing
Outlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing
|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:

> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
>

how to configure SQL server 2000 Agent Mail to use outlook express

Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing

How to configure bidirectional replication

In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
transactional replication. Distributor and publisher are on the same server
(quad processor machine). I Intent to publish a relatively small db (@. 60
articles) to a subscriber in a remote SQL Server cluster and would like to
have updates made to subscribers also replicated back to publisher. I
understand bidirectional replication is not supported by the replication
wizard in enterprise manager. How can that be achieved?
For starters, this article may help:
http://support.microsoft.com/default...75&Product=sql
There's also an article on this subject in SQL Server Magazine
(www.sqlmag.com) by Bren Newman, ArticleID 42858.
"Cesar" wrote:

> In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
> transactional replication. Distributor and publisher are on the same server
> (quad processor machine). I Intent to publish a relatively small db (@. 60
> articles) to a subscriber in a remote SQL Server cluster and would like to
> have updates made to subscribers also replicated back to publisher. I
> understand bidirectional replication is not supported by the replication
> wizard in enterprise manager. How can that be achieved?
>
>