• dmbaker (11/19/2010)


    Jeff Moden (11/18/2010)


    Jeff Moden (11/4/2010)


    I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?

    Anyone?

    I'm not certain, but I don't think CDONTS will be available. Don't think it'd be part of the install of SQL Server Express, but it *might* be part of the OS install, or might come with Microsoft Office if you've got the right parts installed. You're more likely to have CDOSYS I think, if it's newer version of Windows. In googling a bit it looks like maybe SQL Server Express does have email stuff on the SQL Server side, but the core email components (DLLs) are not included and emailing-related services are disabled and buried.

    Sorry for the waffly answer. 🙂

    I am running 2008 developer, 2005 standard and Express and yes Express comes with the sp_OA just like SQL Server 2008 developer but no CDONTS. The reason those are COM dll which the developer division have depreciated since 2005 version of .NET.

    Kind regards,
    Gift Peddie