You’ve installed SQL Server 2008 on a clean machine and your vb script that uses DMO doesn’t work. You’re asking yourself: What the heck happened? Did those goofballs over @ MS hose me? Deprecation of DMO was announced in SQL Server 2005, but SQL Server 2005 still installed DMO. In SQL Server 2008 we’ve taken the next step down the deprecation path – we ship DMO but don’t automatically install it. There are two places to get DMO:
- SQL Server 2008 Installation Media: go to ..\x86\Setup\x86\SQLServer2005_BC.msi
- SQL Server 2008 Feature Pack @ the Microsoft Download Center: http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
Generally it’s best to go to http://www.microsoft.com/downloads, search for "SQL Server Feature Pack" and sort by Release Date to find the latest version.
With the addition of PowerShell support in SQL Server 2008 we highly encourage you to move off of DMO and start using SMO.