Tag-Archive for » MSSQL version «

Find the exact version of your MSSQL server
admin
06
Sep 2009

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 …
VN:F [1.6.7_924]
Rating: 0.0/5 (0 votes cast)
VN:F [1.6.7_924]
Rating: 0 (from 0 votes)
Category: MSSQL 2000, 2005, 2008  Tags:  2 Comments