Showing posts with label hellojust. Show all posts
Showing posts with label hellojust. Show all posts

Monday, March 19, 2012

EMAIL from SQL express

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

RobOn Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
<rob.lowein@.gmail.comwrote:

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.

Quote:

Originally Posted by

>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

|||On Dec 7, 4:41 am, Tom van Stiphout <no.spam.tom7...@.cox.netwrote:

Quote:

Originally Posted by

On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
>
<rob.low...@.gmail.comwrote:
>
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.
>
>
>

Quote:

Originally Posted by

Hello


>

Quote:

Originally Posted by

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 ?


>

Quote:

Originally Posted by

Regards


>

Quote:

Originally Posted by

Rob- Hide quoted text -


>
- Show quoted text -


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

THansk

Rob|||On Dec 6, 10:41 pm, Tom van Stiphout <no.spam.tom7...@.cox.netwrote:

Quote:

Originally Posted by

On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
>
<rob.low...@.gmail.comwrote:
>
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.
>
>
>

Quote:

Originally Posted by

Hello


>

Quote:

Originally Posted by

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 ?


>

Quote:

Originally Posted by

Regards


>

Quote:

Originally Posted by

Rob- Hide quoted text -


>
- Show quoted text -


Tom, I too am interested in some type of example. Do you do
development work in a language - VB, C#, Delphi or other?

Thanks|||On Sun, 9 Dec 2007 08:01:36 -0800 (PST), scoots987
<scoots987@.gmail.comwrote:

In Books Online, the topic "CLR [SQL Server] about CLR integration
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/c73e628a-f54a-411a-bfe3-6dae519316cc.htm
has a simple "Hello World" example.

-Tom.

Quote:

Originally Posted by

>On Dec 6, 10:41 pm, Tom van Stiphout <no.spam.tom7...@.cox.netwrote:

Quote:

Originally Posted by

>On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
>>
><rob.low...@.gmail.comwrote:
>>
>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.
>>
>>
>>

Quote:

Originally Posted by

>Hello


>>

Quote:

Originally Posted by

>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 ?


>>

Quote:

Originally Posted by

>Regards


>>

Quote:

Originally Posted by

>Rob- Hide quoted text -


>>
>- Show quoted text -


>
>Tom, I too am interested in some type of example. Do you do
>development work in a language - VB, C#, Delphi or other?
>
>Thanks
>