Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Database Compatibility version numbers juggling from 40 to 100

A stream of database compatibility numbers has come up to my mind while we are performing few configuration changes to the database to support a legacy application that can work upto SQL Server 2000.

So what number we used during the days of SQL Server 4.0 or even before!

40 for SQL Server 4.0 & 4.2 (to my knowledge, as I have started working with SQL 4.2 onwards)

60 for SQL Server 6.0

65 for SQL Server 6.5

70 for SQL Server 7.0

80 for SQL Server 2000

90 for SQL Server 2005 (currently)

... and it will be 100 for SQL Server 2008.

 

 

Posted: Wednesday, August 15, 2007 3:29 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

A stream of database compatibility numbers has come up to my mind while we are performing few configuration

# August 15, 2007 4:01 AM

SSQA.net - SqlServer-QA.net said:

A stream of database compatibility numbers has come up to my mind while we are performing few configuration

# August 15, 2007 5:21 AM
Anonymous comments are disabled