Friday, April 1, 2011

How to Find Version, Level and Edition of Your Microsoft SQL Server

Microsoft offers several SQL Server products from MS SQL server 7.0, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, MS SQL Server 2008 R2. Day by day Microsoft updates its products for the better performance and accessibility. Many times database administrators found problem to “how to determine the the version, level and edition of running MS SQL Server”. This article has been written to keep this point in mind and hope helpful for the database administrator.

For MS SQL Server 2000 run given below command:

“SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')”

For MS SQL Server 2005 run given below command:

“SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')”

For MS SQL Server 2008 run given below command:

“SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')”

For MS SQL Server 7.0 run given below command:

“SELECT @@VERSION”

Reference: http://support.microsoft.com/kb/321185

No comments:

Post a Comment