MattLog.net

SQL Server Management Studio 2008 with SQL Server 2005

Posted April 20th, 2009 by Matt Shadbolt

I’ve been having some issues with my maintenance plans in SQL Server 2005. I’ve been using the newer 2008 Server Management Studio to manage my SQL servers and it didn’t occur to me that the newer version would break my maintenance plans.

When I modify the plans in 2005 Management Studio I receive the following error:

The DDS layout contains an invalid control progid.

After opening the maint plans in 2005 and resaving them they are back to their old glory and working perfectly.

Tags: SQL Server 2005, SQL Server Management Studio 2008

No Responses