ChetOS.net

When using the table designer in SQL Server Management Studio 2008 SP2 against a SQL Server 2005 database I get the following error: Invalid column name "lock_escalation_desc".

After using the SQL Profiler to see what is being queried by SSMS, I see that the problem is that 2008 expects the sys.tables table to contain a column called lock_escalation_desc.  The problem is that this column wasn't added until SQL 2008.  It doesn't exist in SQL 2005.

Pre-SP2, the SSMS queried the table properly -- that is, it took into account that this is a 2005 database and didn't include that column in the query.  After installing SP2 it stopped working.

Uninstalling Microsoft Sql Server 2008 SP2 resolved the issue.