How do you deploy SQL Server Management Objects (SMO) runtime?   Follow this 3 step process for success.

STEP 1: Download and Install Microsoft Core XML Services (MSXML) 6.0 

STEP 2: Download and Install Microsoft SQL Server Native Client 

STEP 3: Download and Install Microsoft SQL Server 2005 Management Objects Collection

The links above point to the X86 framework however at the time of writing the Feature Pack for Microsoft SQL Server 2005 – February 2007 was the latest and had links to the various processor architectures that are supported by Microsoft

I guess the next logical step is to find out what the differences will be between SQL Server 2005 and SQL Server 2008 seeing as its release is imminent. That being said my total time invested in Microsoft’s latest database technology has been zero.

While I am deviating. Am I the only one not really concerned with SQL Server 2008’s launch?

• Previous Entry: Vista UAC Visual Studio and Run As Administrator Gotcha’s
• Next Entry: The Long Drop