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