SQL-DMO and SQL Server 2008

Published 12 August 09 07:27 PM | josephsa 

Just a reminder that SQL-DMO will be removed in a future version of Microsoft SQL Server - so if you have an application that depends on SQL-DMO, the clock is ticking (although you have a few years to correct probably). 

Also, if you are installing SQL Server 2008 on a fresh server (no other previous versions of SQL installed) and you need SQL-DMO, you can install SQL-DMO via the Microsoft SQL Server 2005 Backward Compatibility Components.  Or you can also get it off of the install media under \x86\Setup\x86\SQLServer2005_BC.msi.

Building something new?  Don't use SQL-DMO - use SMO (SQL Server Management Objects) instead.

Comments

No Comments
Anonymous comments are disabled

About josephsa

I am a dedicated support engineer in the Microsoft Premier Field Engineering organization and have worked with SQL Server since 1997. I'm responsible for proactive and reactive support of enterprise customer environments. When time permits, I like to write and review technical books and articles. My third and latest book is "SQL Server 2008 Transact-SQL Recipes" (Apress, July 2008).

Search

This Blog

Syndication

Page view tracker