Merhabalar,

Bu yazımızda sistemimize kurmuş olduğumuz Sql serverin üzerinde Servic pack kurulu olup olmadığını tespit edeceğiz.Bu işlem için Microsoft Sql Server Management Studio yazılımını açıyoruz ve Help kısmında About kısmını tıklıyoruz ve aşağıda yazmış olduğum kodlar ile karşılaştırıyoruz ve bu şekilde tespit etmiş olabiliyoruz.

 

For SQL Server 2008:

@@versionVersion and Service Pack
10.00.2723.00SQL Server 2008 with Cumulative Update 3 (includes SP 1 and hot-fixes)
10.00.2531.00SQL Server 2008 with service pack 1.
10.00.1600.00SQL Server 2008, with no service pack applied.

For SQL Server 2005:

Subsequent numbers (higher than 9.00.4035) indicate security updates released after SQL Server 2005 service pack 3. See http://support.microsoft.com/kb/960598/ for details.

@@versionVersion and Service Pack
9.00.4035SQL Server 2005 with service pack 3.
9.00.3054SQL Server 2005 with service pack 2 GDR2.
9.00.3050SQL Server 2005 with service pack 2 GDR1.
9.00.3042SQL Server 2005 with service pack 2.
2005.90.2047SQL Server 2005 with service pack 1.
2005.90.1399SQL Server 2005 with no service pack applied.

For SQL Server 2000:

@@versionVersion and Service Pack
8.00.2039SQL Server 2000 with Service Pack 4
8.00.760SQL Server 2000 with Service Pack 3a
8.00.760SQL Server 2000 with Service Pack 3.
8.00.532SQL Server 2000 with Service Pack 2
8.00.384SQL Server 2000 with Service Pack 1
8.00.194SQL Server 2000 with no service pack applied

For SQL Server 7:

@@versionVersion and Service Pack
7.00.1063SQL Server 7 with Service Pack 4
7.00.961SQL Server 7 with Service Pack 3
7.00.842SQL Server 7 with Service Pack 2
7.00.699SQL Server 7 with Service Pack 1
7.00.623SQL Server 7 with no service pack applied

For SQL Server 6.5:

@@versionVersion and Service Pack
6.50.479SQL Server 6.5 with Service Pack 5a (updated)
6.50.416SQL Server 6.5 with Service Pack 5a.
6.50.415SQL Server 6.5 with Service Pack 5
6.50.281SQL Server 6.5 with Service Pack 4
6.50.258SQL Server 6.5 with Service Pack 3
6.50.240SQL Server 6.5 with Service Pack 2
6.50.213SQL Server 6.5 with Service Pack 1
6.50.201SQL Server 6.5 with no service pack applied

For SQL Server 6:

@@versionVersion and Service Pack
6.00.151SQL Server 6 with Service Pack 3
6.00.139SQL Server 6 with Service Pack 2
6.00.124SQL Server 6 with Service Pack 1
6.00.121SQL Server 6 with no service pack applied

SQL Server Service packs can be downloaded from the Microsoft web site.

See also Microsoft Knowledge Base article 321185.

 

Bir Sonraki yazımızda görüşmek üzere ..

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir