Google olsa da, sikca sorulan sorulardan bir tanesi. Elinizde bir Microsoft SQL veritabani sunucusu var ve SQL surum numarasindan patch seviyesini ogrenmek istiyorsunuz. SQL Query Analyzer’i kullanarak “SELECT @@version” ciktisini aliyorsunuz ve Google imdadiniza yetisiyor.
Bir cok sitede surum numarasina gore service pack seviyesini hizlica belirleyebileceginiz tablolar yeraliyor. Ancak burada bulunan SQL Server 2000 Build Chart oldukca detayli.
SQL Server 2000 | |
Version | Service Pack |
8.00.2039 | SQL Server 2000 Service Pack 4 (SP4) |
8.00.760 | SQL Server 2000 Service Pack 3 (SP3) |
8.00.534 | SQL Server 2000 Service Pack 2 (SP2) |
8.00.384 | SQL Server 2000 Service Pack 1 (SP1) |
8.00.194 | SQL Server 2000 RTM (Release To Manufacturing) |
SQL Server 7.0 | |
Version | Service Pack |
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) |
SQL Server 6.5 | |
Version | Service Pack |
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 (Release To Manufacturing) |
SQL 2000’de “SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)” sorgusu kullanilarak da ozet bilgi alinabilir.
Kaynaklar
How to identify your SQL Server version and edition
SQL Server 2000 Build Chart