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
>

EM Issue - Missing servers in available servers list?

My PC was renamed and added to Active Directory in a new domain yesterday. Today when I tried to register a server in EM I only see SQL Servers in this new domain and not in the other, trusted, domains. I visited the machines of 5 developers and found that some people are experiencing the same issue while others can see SQL Servers in other domains, however they can only see SQL 2000 and not SQL 7 servers.

Any idea how the "Available Server" list is populate in EM and what might be causing this issue? It is important to note that even though I do not see server in the list, I can still register the servers without a problem.

Thanks, DaveThe entries are stored in the client registry, as you might have assumed:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers|||...well, that's one of the places :)

I found another one:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers|||Dave
I assume you are talking about the list of available servers in the register server wizard in Enterprise Manager? If so, then there is actually a security alert about this (lastest SQL Server cummulative patch).

Your client broadcasts out a message to all of your (sub)network, and says I"I am looking for SQL Servers". Anything listening on port 1433 or so will respond with "Hey, I am a SQL Server". The vulnerability is in the way the client accepts the response. If someone "fakes" a response from SQL Server, they can do something to you (I forget the details, but you can look it up on the SQL site under downloads). But that is the short of how the register server wizard works. That is also why I never use it. If I don't know about the server, I probably shouldn't be messing with it. Hope this helps.

rdjabarov has pointed out where you get the lists of servers already registered in SQL Server Enterprise Manager and where Query Analizer and Profiler get that drop-down list of servers to connect to. Basically just the last 20 servers you visited.|||well, my first posting shows the currently used location, and my second posting shows the location on my other workstation. Both locations are sources for EM, not Profiler or QA. The latter 2 truely are using the last 20 servers you connected to.|||Thanks for the info about the security issue. I'll read about it.

The only reason why I like to see the list of servers is to ensure nobody is trying to add an unauthorized SQL Server to our network. There are probably other ways to verify this, but I'm just use to using EM.

Dave

EM file is corrupted

I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
try to open EM it tells me that the file is not available or was created
with newer version of EM.
What can I do about it?
thank
Shimon.I resolved it. Let me know if you are interested how I did it.
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eKodAwGXFHA.160@.TK2MSFTNGP15.phx.gbl...
>I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
>try to open EM it tells me that the file is not available or was created
>with newer version of EM.
> What can I do about it?
> thank
> Shimon.
>

EM file is corrupted

I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
try to open EM it tells me that the file is not available or was created
with newer version of EM.
What can I do about it?
thank
Shimon.
I resolved it. Let me know if you are interested how I did it.
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eKodAwGXFHA.160@.TK2MSFTNGP15.phx.gbl...
>I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
>try to open EM it tells me that the file is not available or was created
>with newer version of EM.
> What can I do about it?
> thank
> Shimon.
>

EM file is corrupted

I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
try to open EM it tells me that the file is not available or was created
with newer version of EM.
What can I do about it?
thank
Shimon.I resolved it. Let me know if you are interested how I did it.
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eKodAwGXFHA.160@.TK2MSFTNGP15.phx.gbl...
>I tried to install Visual Studio 2005 and I corrupted my EM file. Now if I
>try to open EM it tells me that the file is not available or was created
>with newer version of EM.
> What can I do about it?
> thank
> Shimon.
>

EM does not install

I have a strange SQL Standart installation on Win2k
server, sp4: I selected the server components, but the EM
is not available in the program menu. I have already
installed the same SQL on the previous machine and the
installation was OK. What I'm missing? Do I need to
reinstall SQl server? Can I do this without uninstall the
existing instance?
ThanksTry reinstalling "client tools only"
--
-Vishal
MJ <mschwenger@.cca-lv.com> wrote in message
news:2f6b01c379df$9b8b6e60$a601280a@.phx.gbl...
> I have a strange SQL Standart installation on Win2k
> server, sp4: I selected the server components, but the EM
> is not available in the program menu. I have already
> installed the same SQL on the previous machine and the
> installation was OK. What I'm missing? Do I need to
> reinstall SQl server? Can I do this without uninstall the
> existing instance?
> Thanks