How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:
>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
Joe
Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to send mail through SQL Server...

Hi,
I have a requirement of sending mail through SQL Server through SMTP port... But, I dont want to configure my database server as e-mail client...
Is there any way to do it...
Thanks in advance...You can use the procedure xp_sendmail to send email. I'm not sure what you mean with 'client', but sqlserver won't take the place of outlook, pegasus mail or some other email client you have.|||For SQL Server to use xp_xxxmail it MUST be configured as a MAPI-complient client (as the poster noted). To avoid that you can use this:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=670&lngWId=5|||I have also used vbSendMail from www.freevbcode.com with a lot of success. Again, you have to write a stored procedure to "wrap around" the DLL, but it works quite well.

Regards,

hmscott|||I would also go the CDOSYS way that rdjabarov suggests, then you don't need to worry about other things than the SQL part...

Here is another link that might be worth checking out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech|||True, its hassle-free than direct SQL Mail procedures.