SQL Server – What am I running? Configurations.

Here are some useful debugging information queries.

SET nocount ON
            USE master
GO
EXEC xp_msver
SELECT
    'Microsoft SQL Server ' +
            CONVERT(VARCHAR, SERVERPROPERTY('ProductVersion') ) + ' ' +
            CONVERT(VARCHAR, SERVERPROPERTY('ProductLevel') ) + ' ' +
            CONVERT(VARCHAR, SERVERPROPERTY('Edition') ) + ' ' +
            CONVERT(VARCHAR, SERVERPROPERTY('EngineEdition') ),
    @@VERSION
GO
            PRINT '** Database master compatibility level:'
EXEC sp_dbcmptlevel master
GO
            

Here is a good resource to figure out what version of SQL you are running using the version number.