Archive for the 'Database' Category

Mengecek Versi dan Edition di SQL Server

Published
by
joule
on June 10, 2008
in Database
. 0 Comments

Jika anda seorang admin database tentunya sangat membutuhkan informasi dari Versi dan Edition dari SQL Server yang terinstall. Berikut adalah “Command” yang biasa di gunakan berdasarkan Edition SQL Server:

1. SQL Server 6.5 

SELECT @@VERSION

6.50.479
SQL Server 6.5 Service Pack 5a (SP5a) Update

6.50.416
SQL Server 6.5 Service Pack 5a (SP5a)

6.50.415
SQL Server 6.5 Service Pack 5 (SP5)

6.50.281
SQL Server 6.5 Service Pack 4 (SP4)

6.50.258
SQL Server 6.5 Service Pack 3 (SP3)

6.50.240
SQL Server 6.5 Service Pack 2 (SP2)

6.50.213
SQL Server 6.5 Service Pack 1 (SP1)

6.50.201
SQL Server 6.5 RTM

2. SQL Server 7.0 

SELECT @@VERSION

 

Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
        Nov 27 1998 22:20:07
        Copyright (c) 1988-1998 Microsoft Corporation
        Desktop Edition on Windows NT 5.1 (Build 2600: )

7.00.1063
SQL Server 7.0 Service Pack 4 (SP4)

7.00.961
SQL Server 7.0 Service Pack 3 (SP3)

7.00.842
SQL Server 7.0 Service Pack 2 (SP2)

7.00.699
SQL Server 7.0 Service Pack 1 (SP1)

7.00.623
SQL Server 7.0 RTM (Release To Manufacturing)

3. SQL Server 2000

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

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

4. SQL Server 2005

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

RTM
2005.90.1399

SQL Server 2005 Service Pack 1
2005.90.2047

SQL Server 2005 Service Pack 2
2005.90.3042