January 13, 2012 at 7:54 am
I'm in the process of moving a 2000 database to our new SQL 2008 R2 server. This 2000 DB uses CDO to send email and from what I can tell CDO can be used with 2008 R2 but there is also a Database Mail option.
Are there any pros/cons to using either? Any thoughts would be appreciated.
Thanks.
January 13, 2012 at 8:05 am
Ok I dug into the BOL a little bit and read more about Database mail.... looks like that's the way to go.
January 13, 2012 at 8:51 am
DBMail IMHO is a far better option.
CDO needs enabling OLE automation, which is not a good idea if you wanto to keep your surface as little as possible.
DBMail works good and has security options you don't have in CDO, so, my vote goes to database mail.
-- Gianluca Sartori
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply