August 11, 2008 at 8:03 am
Hi there,
I want to start providing email services for my company, primarily to send inter-departmental email notifications. I've been using SQL Server 2005 Express for about a year and a half and I don't need much more from it other than a reliable email server and maybe better tools for managing full-text services.
I've scoured the internet for information on Database Mail in Workgroup Edition, and no where does Microsoft specifically compare the availability of Database Mail across editions. You can't even download a trial of Workgroup, you have to download the Enterprise Edition which obviously has everything.
Has anyone out there worked with Workgroup Edition and confirmed that it does have the same Database Mail service as Standard/Enterprise?
August 11, 2008 at 8:13 am
I'm pretty sure that all versions of SQL Server 2005, including Express, include Database Mail.
But, it sounds like you are looking for a MAIL SERVER and database mail is just a way to send email from SQL Server it is NOT an email product. It needs and email server to connect to in order to send the mail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 11, 2008 at 8:29 am
Wow, quick responses around here. 🙂
No my company has a mail server, I need a way to get email from SQL server onto it. My understanding is that SQL server has a service called Database Mail that allows you to send out email via smtp by calling a stored proc.
SQL Express contains this stored proc, but does not include the files you need to run the database mail service which queues the mail to be sent out.
If database mail is installed you should have a file called DatabaseMail90.exe in your /binn directory. I haven't been able to get a copy of workgroup edition to verify this because Microsoft only provides trials of the Enterprise edition.
August 11, 2008 at 8:43 am
Most folks try to answer in a timely fashion, of course, that depends on when we get on.
I think the Workgroup edition will have it because Database Mail is built using Service Broker and that starts coming with Workgroup edition.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 11, 2008 at 8:55 am
I have no experience with workgroup edition, but since Books Online only mentions explicitly that database mail is not available for Express Edition, I would expect that it will work in all other editions.
But then again, they don't mention CE, and I know for sure CE does not supports database mail.
[font="Verdana"]Markus Bohse[/font]
August 11, 2008 at 2:25 pm
I've used workgroup edition. It does include database mail.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply