Version SQL de création d’une base de données

Il arrive parfois qu’on s’interroge sur la vie d’une base de données : sous quelle version de SQL Server a-t’elle été créée à l’origine ?

Ce petit script vous permet de le savoir.

/*-------------------------------------------------------------------
[SCRIPT] Database_SQLCreateVersion  
[DATABASE] Current
[DESCRIPTION] Trouver la version SQL de création de la base courante
[MAJ PAR] DATAFLY - Arian Papillon
[DATE] 20190125
-------------------------------------------------------------------*/
CREATE TABLE #DBINFOTemp
(
    ParentObject VARCHAR(255),
    [Object] VARCHAR(255),
    Field VARCHAR(255),
    [Value] VARCHAR(255)
);
INSERT #DBINFOTemp
EXEC ('DBCC DBINFO() WITH TABLERESULTS');
SELECT CASE CAST(Value AS INT)
           WHEN 869 THEN
               '2017'
           WHEN 852 THEN
               '2016'
           WHEN 782 THEN
               '2014'
           WHEN 706 THEN
               '2012'
           WHEN 684 THEN
               '2012 CTP'
           WHEN 661 THEN
               '2008 R2'
           WHEN 660 THEN
               '2008 R2'
           WHEN 655 THEN
               '2008'
           WHEN 612 THEN
               '2005 SP2'
           WHEN 611 THEN
               '2005'
           WHEN 539 THEN
               '2000'
           WHEN 515 THEN
               '7.0'
           WHEN 408 THEN
               '6.5'
           ELSE
               '?'
       END AS CreateSQLVersion,
       Value AS InternalBuild
FROM #DBINFOTemp
WHERE Field IN ( 'dbi_createVersion' );

/*-------------------------------------------------------------------

[SCRIPT] Database_SQLCreateVersion

[DATABASE] Current

[DESCRIPTION] Trouver la version SQL de création de la base courante

[MAJ PAR] DATAFLY - Arian Papillon

[DATE] 20190125

-------------------------------------------------------------------*/

CREATE TABLE #DBINFOTemp

(

ParentObject VARCHAR(255),

[Object] VARCHAR(255),

Field VARCHAR(255),

[Value] VARCHAR(255)

);

INSERT #DBINFOTemp

EXEC ('DBCC DBINFO() WITH TABLERESULTS');

SELECT CASE CAST(Value AS INT)

WHEN 869 THEN

'2017'

WHEN 852 THEN

'2016'

WHEN 782 THEN

'2014'

WHEN 706 THEN

'2012'

WHEN 684 THEN

'2012 CTP'

WHEN 661 THEN

'2008 R2'

WHEN 660 THEN

'2008 R2'

WHEN 655 THEN

'2008'

WHEN 612 THEN

'2005 SP2'

WHEN 611 THEN

'2005'

WHEN 539 THEN

'2000'

WHEN 515 THEN

'7.0'

WHEN 408 THEN

'6.5'

ELSE

'?'

END AS CreateSQLVersion,

Value AS InternalBuild

FROM #DBINFOTemp

WHERE Field IN ( 'dbi_createVersion' );