EMAIL from SQL express

EMAIL from SQL express

am 06.12.2007 19:52:46 von roblowein

Hello

Just figured out that database mail is not available in SQL Express.
Anyone have any ideas on how I can send mail from sql express ... as
part of a trigger ?

Regards

Rob

Re: EMAIL from SQL express

am 07.12.2007 05:41:18 von Tom van Stiphout

On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
wrote:

All versions of SQL Server have support for Common Language Runtime
and .NET Integration. So you could write a .NET assembly to send
emails.

-Tom.


>Hello
>
>Just figured out that database mail is not available in SQL Express.
>Anyone have any ideas on how I can send mail from sql express ... as
>part of a trigger ?
>
>Regards
>
>Rob

Re: EMAIL from SQL express

am 07.12.2007 17:27:29 von roblowein

On Dec 7, 4:41 am, Tom van Stiphout wrote:
> On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
>
> wrote:
>
> All versions of SQL Server have support for Common Language Runtime
> and .NET Integration. So you could write a .NET assembly to send
> emails.
>
> -Tom.
>
>
>
> >Hello
>
> >Just figured out that database mail is not available in SQL Express.
> >Anyone have any ideas on how I can send mail from sql express ... as
> >part of a trigger ?
>
> >Regards
>
> >Rob- Hide quoted text -
>
> - Show quoted text -

Thanks for the reply..... could provide any more details .... this
quite new to me

THansk

Rob