How to find which version of:
1- SQL Server 2008 :
To find which version of Microsoft SQL Server 2008 is installed, connect to SQL Server 2008 by using SQL Server Management Studio ,then run the following query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
The product version (for example, 10.0.2531.0)
The product level (for example, SP1)
The edition (for example, Enterprise Edition (64-bit))
Release | SQL Version |
RTM | 2007.100.1600.0 |
SQL Server 2008 Service Pack 1 | 2007.100.2531.0 |
2- SQL Server 2005:
To find which version of Microsoft SQL Server 2005 is installed, connect to SQL Server 2008 by using SQL Server Management Studio ,then run the following query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
The product version (for example, 9.00.1399.06)
The product level (for example, RTM)
The edition (for example, Enterprise Edition)
Release | SQL Version |
RTM | 2005.90.1399 |
SQL Server 2005 Service Pack 1 | 2005.90.2047 |
SQL Server 2005 Service Pack 2 | 2005.90.3042 |
SQL Server 2005 Service Pack 3 | 2005.90.4035 |
3- SQL Server 2000 is running
To find which version of Microsoft SQL Server 2005 is installed, connect to SQL Server 2008 by using SQL Server Management Studio ,then run the following query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
The product version (for example, 8.00.534)
The product level (for example, "RTM" or "SP2")
The edition (for example, "Standard Edition").
Release | SQL Version |
RTM | 2000.80.194.0 |
SQL Server 2000 SP1 | 2000.80.384.0 |
SQL Server 2000 SP2 | 2000.80.534.0 |
SQL Server 2000 SP3 | 2000.80.760.0 |
SQL Server 2000 SP3a | 2000.80.760.0 |
SQL Server 2000 SP4 | 2000.8.00.2039 |
No comments:
Post a Comment