Many people are not sure of how to find the exact version of their MSSQL server. Here’s the query to be run on SQL Query Analyzer or SQL Server Management Studio thro’ new query-

Find out the version of SQL Server 6.5 -

SELECT @@VERSION

Find out the version of SQL Server 7.0 -

SELECT @@VERSION

Find out the version of SQL Server 2000 -

SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Find out the version of SQL Server 2005 -

SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Find out the version of SQL Server 2008 -

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

“`*“`arun …