alternative to Outlook/ Exchange?

Is there anything other than Outlook/ Exchange that can be used in order to
set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
Relay type of deal.
Check the following extended stored procedure for SMTP mail:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
<noemail@.bla.com> wrote:

>Is there anything other than Outlook/ Exchange that can be used in order to
>set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
>Relay type of deal.
>
|||Thanks Sue. Do you know if this is supported by MS?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b1d6519p7d7ooer6vtumjjab67g5sijker@.4ax.com...
> Check the following extended stored procedure for SMTP mail:
> http://www.sqldev.net/xp/xpsmtp.htm
> -Sue
> On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
> <noemail@.bla.com> wrote:
>
|||Depends on what you mean - Microsoft doesn't support third
party utilities but adding the extended stored procedure and
using it doesn't leave you with an unsupported installation
of SQL Server.
It's stable to use...many people use it. I've been using it
for a few years. I think it's a improvement over using SQL
Mail, Agent Mail, MAPI, etc.
-Sue
On Wed, 6 Apr 2005 07:54:08 -0700, "ChrisR"
<noemail@.bla.com> wrote:

>Thanks Sue. Do you know if this is supported by MS?
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:b1d6519p7d7ooer6vtumjjab67g5sijker@.4ax.com.. .
>

alternative to Outlook/ Exchange?

Is there anything other than Outlook/ Exchange that can be used in order to
set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
Relay type of deal.Check the following extended stored procedure for SMTP mail:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
<noemail@.bla.com> wrote:
>Is there anything other than Outlook/ Exchange that can be used in order to
>set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
>Relay type of deal.
>|||Thanks Sue. Do you know if this is supported by MS?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b1d6519p7d7ooer6vtumjjab67g5sijker@.4ax.com...
> Check the following extended stored procedure for SMTP mail:
> http://www.sqldev.net/xp/xpsmtp.htm
> -Sue
> On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
> <noemail@.bla.com> wrote:
>>Is there anything other than Outlook/ Exchange that can be used in order
>>to
>>set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
>>Relay type of deal.
>|||Depends on what you mean - Microsoft doesn't support third
party utilities but adding the extended stored procedure and
using it doesn't leave you with an unsupported installation
of SQL Server.
It's stable to use...many people use it. I've been using it
for a few years. I think it's a improvement over using SQL
Mail, Agent Mail, MAPI, etc.
-Sue
On Wed, 6 Apr 2005 07:54:08 -0700, "ChrisR"
<noemail@.bla.com> wrote:
>Thanks Sue. Do you know if this is supported by MS?
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:b1d6519p7d7ooer6vtumjjab67g5sijker@.4ax.com...
>> Check the following extended stored procedure for SMTP mail:
>> http://www.sqldev.net/xp/xpsmtp.htm
>> -Sue
>> On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
>> <noemail@.bla.com> wrote:
>>Is there anything other than Outlook/ Exchange that can be used in order
>>to
>>set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
>>Relay type of deal.
>>
>

alternative to Outlook/ Exchange?

Is there anything other than Outlook/ Exchange that can be used in order to
set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
Relay type of deal.Check the following extended stored procedure for SMTP mail:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
<noemail@.bla.com> wrote:

>Is there anything other than Outlook/ Exchange that can be used in order to
>set up SQL Mail/ Alerts? My Network Admin is hoping for some type of SMTP
>Relay type of deal.
>|||Thanks Sue. Do you know if this is supported by MS?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b1d6519p7d7ooer6vtumjjab67g5sijker@.
4ax.com...
> Check the following extended stored procedure for SMTP mail:
> http://www.sqldev.net/xp/xpsmtp.htm
> -Sue
> On Tue, 5 Apr 2005 16:30:42 -0700, "ChrisR"
> <noemail@.bla.com> wrote:
>
>|||Depends on what you mean - Microsoft doesn't support third
party utilities but adding the extended stored procedure and
using it doesn't leave you with an unsupported installation
of SQL Server.
It's stable to use...many people use it. I've been using it
for a few years. I think it's a improvement over using SQL
Mail, Agent Mail, MAPI, etc.
-Sue
On Wed, 6 Apr 2005 07:54:08 -0700, "ChrisR"
<noemail@.bla.com> wrote:

>Thanks Sue. Do you know if this is supported by MS?
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:b1d6519p7d7ooer6vtumjjab67g5sijker@.
4ax.com...
>

Alternative to DTC? - SSIS Transactions - Quick Question

Hi:

I would like to have my SSIS tasks to be transacted, but due to infrastructure issues in our network, cannot utilize DTC, because our SQL Boxes are situated where the DTC cannot communicate. Are any other alternatives? Is it a feasible alternative? Please let me know. Thanks.

MA2005 wrote:

Hi:

I would like to have my SSIS tasks to be transacted, but due to infrastructure issues in our network, cannot utilize DTC, because our SQL Boxes are situated where the DTC cannot communicate. Are any other alternatives? Is it a feasible alternative? Please let me know. Thanks.

This link should help: http://msdn2.microsoft.com/en-us/library/ms137690.aspx

Alternative to Account Delegation?

Hello,
I want to run distributed queries via a linked server using a windows
autheniticated login. Talking with our AD/network admin about the steps in
http://msdn.microsoft.com/library/d...>
ity_2gmm.asp
they have a problem with setting up account delegation for service account
and sql server computer, mainly because this is a new precedent and they
don't want to go there unless absolutely necessary.
Are there any alternatives to doing the above that would enable distributed
queries using windows authenicated logins?
Thanks,
DanHi
No. The way the OS has to impersonate and delegate security across machine
boundaries requires this. If there was an easier way, we would all be using
it.
Your admins will need to get used to it. As security gets tightened inside
the OS, you will need to use it more and more.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dan H" wrote:

> Hello,
> I want to run distributed queries via a linked server using a windows
> autheniticated login. Talking with our AD/network admin about the steps i
n
> http://msdn.microsoft.com/library/d...
urity_2gmm.asp
> they have a problem with setting up account delegation for service account
> and sql server computer, mainly because this is a new precedent and they
> don't want to go there unless absolutely necessary.
> Are there any alternatives to doing the above that would enable distribute
d
> queries using windows authenicated logins?
> Thanks,
> Dan