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
|
Sqlservr.exe
|
|
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)
For example, the results resemble the following.
|
9.00.1399.06
|
RTM
|
Enterprise Edition
|
|
Release
|
Sqlservr.exe
|
|
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"). For example, the results resemble the
following:
8.00.534 SP2 Standard Edition
|
Release
|
Sqlservr.exe
|
|
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
|
ليست هناك تعليقات:
إرسال تعليق