FRIDAY, JANUARY 07, 2011
SQL Management Studio 2008 against SQL 2005 Database
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.
Posted by Anonymous at 1:10 PM
Post a Comment
Feel Free To Share Your Thoughts
You can use [b], [u], [i], and [url]
More About Me
Philosophy for Understanding Theology
20,000 Leagues Under the Sea
Settlers of Catan
Misc Arduino projects