Microsoft SQL Version Bilgisi
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