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