Using Expressmaint on SQL Server 2008
With the release of SQL 2008 Express I thought it would be helpful to add a note that it you try to use the ExpressMaint utility to perform database maintenance operations against SQL Server 2008 on a computer which has never had SQL Server 2005 installed you will encounter an error. This is because ExpressMaint references the SQL 2005 SMO assemblies. In order for it to work correctly, simply install the SMO 2005 redistributable on the SQL Server 2008 computer and apply at least SQL 2005 Post SP2 Cumulative Update 5. I am currently working on a new version that will remove the SMO dependency and support all versions from SQL Server 2000 upwards as well as adding a new graphical UI and the concept of packages (think maintenance plans) to help simply maintenance operations. Download links below