Monday, November 5, 2007

SQL Server Storage Engine

What's the difference between database version and database compatibility level?

I had a question this week from someone who'd heard me say at SQL Connections (paraphrasing) "database compatibility level is mostly about query parsing" and was having trouble trying to forcibly attach a 2005 or 7.0 database to a 2000 server.

His confusion is between database compatibility level and database version. Here's a quick explanation of the difference.

No comments: