Dynamics NAV on SQL Server Versions

I know that this blogpost is far from orriginal but I am always looking for this information so I am putting it in my blog

The table $ndo$dbproperty has a field DatabaseVersionNo. This is a list of recent versions.

With special thanks to Dean McRae!


/ Database versions for: 2.50
// 1   : Beta 1 data formats
// 2   : Beta 2 data formats (change in Code field value format from space-padded prefix to hex prefix)
// 3   : Beta 3 data formats (change in Code field value format from hex prefix to no prefix or special format)
// 4   : Release data formats (SIFT trigger identifiers changed and new indexes on SIFT tables)
// Database versions for: 2.60(A->C)
// 5   : Release data formats (change in Session view and SIFT triggers to use CONVERT rather than CAST for datetime fields)
// Database versions for: 2.60(D->F)
// 6   : Changes in SIFT triggers due to UPDATE... WHERE... performance problem
// Database versions for: 3.00
// 7   : Beta 1 data formats (change in Session view for SQL Server 2000; change in chartable)
// 8   : Beta 1 data formats (change in chartable; changes in SIFT triggers due to UPDATE... WHERE... performance problem)
// 9   : Beta 1 data formats (added maintainviews dbproperty)
// 10  : Beta 2 data formats (mapped invalid characters to "_" for SQL object identifiers)
// 11  : Release data formats (added diagnostics dbproperty)
// Database versions for: 3.01, 3.01A, 3.01B
// 12  : Release data formats (added identifiers dbproperty)
// Database versions for: 3.10, 3.10A
// 13  : Release data formats (added maintainrelationships dbproperty)
// Database versions for: 3.60
// 14  : Release data formats (change in Session view for new extensions; identifer conversion dbproperties; per-database license dbproperty)
// Database versions for: 3.70
// 15  : Release data formats (change in chartable; added checkcodepage, quickfind, maintaindefaults dbproperties;
//                             change in Session view for new extensions and column COLLATE;
//                             change in Database File view for column COLLATE)
// 16  : Hotfix 5 data formats (change in Session View for removing duplicate connections based on 'sysprocesses.ecid')
// 17  : Hotfix 12 data formats (change in Session View for removing duplicate connections based on 'sysprocesses.ecid';
//                               the identifiers and invalididentifierchars dbproperties are updated to OEM)
// 18  : 3.70B data formats (change in Session View, removing join to syslockinfo; also removed from session count query)
// Database versions for: 4.0
// 20  : Pre-release data formats (change in Session view for new Idle Time column;
//                                 change in permission table to include new object types)
// 30  : Security release data formats (change in Session view, removing join to syslockinfo;
//                                      change in chartable; creation of security objects)
// Database versions for: 4.1
// 40  : Release data formats (added locktimeout, locktimeoutperiod, hardrowlock and bufferedrows dbproperties)
// Database versions for: 4.2
// 50  : Update 3 (no actual database conversion was made)
// Database versions for: 4.2 Update 4, 4.3
// 60  : Alterable security option; fix for SIFT data corruption around Closing Dates (added securityoption dbproperty)
// 61  : Rebuilding SIFT triggers in order to correct the Sum problem
// 62  : Rebuilding SIFT triggers in order to correct the delete statement
// 63  : Prevention of updating SIFT twice
// Database versions for: 5.0
// 80  : Release data formats (added system tables for office integration and record links; change in table descriptions for clustered property)
// 81  : Rebuilding SIFT triggers in order to correct the Sum problem
// 82  : Rebuilding SIFT triggers in order to correct the delete statement
// Database versions for: 5.0 SP1
// 95  : Removed SIFT tables and triggers, creating Indexed Views instead
// Database versions for: 6.0
// 120 : Release data formats (incl. CTP1) (added several new system tables;
//                                          extended record links system table)
// 130 : Pre-release data formats (incl. CTP2) (removed SIFT tables and triggers, creating Indexed Views instead)
// 140 : Pre-release data formats (removed Assembly and Relationship system tables;
//                                 added enabledforservice dbproperty)

Comment List
Related
Recommended