dbTalk Databases Forums  

EMAIL from SQL express

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss EMAIL from SQL express in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
roblowein
 
Posts: n/a

Default EMAIL from SQL express - 12-06-2007 , 12:52 PM






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

Reply With Quote
  #2  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: EMAIL from SQL express - 12-06-2007 , 10:41 PM






On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein
<rob.lowein (AT) gmail (DOT) com> 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.


Quote:
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

Reply With Quote
  #3  
Old   
roblowein
 
Posts: n/a

Default Re: EMAIL from SQL express - 12-07-2007 , 10:27 AM



On Dec 7, 4:41 am, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:
Quote:
On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein

rob.low... (AT) gmail (DOT) com> 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


Reply With Quote
  #4  
Old   
scoots987
 
Posts: n/a

Default Re: EMAIL from SQL express - 12-09-2007 , 10:01 AM



On Dec 6, 10:41 pm, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:
Quote:
On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein

rob.low... (AT) gmail (DOT) com> 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 -
Tom, I too am interested in some type of example. Do you do
development work in a language - VB, C#, Delphi or other?

Thanks




Reply With Quote
  #5  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: EMAIL from SQL express - 12-10-2007 , 08:09 AM



On Sun, 9 Dec 2007 08:01:36 -0800 (PST), scoots987
<scoots987 (AT) gmail (DOT) com> wrote:

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:
On Dec 6, 10:41 pm, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:
On Thu, 6 Dec 2007 10:52:46 -0800 (PST), roblowein

rob.low... (AT) gmail (DOT) com> 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 -

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

Thanks


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.