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.
@@version | Version and Service Pack |
|---|---|
| 10.00.2723.00 | SQL Server 2008 with Cumulative Update 3 (includes SP 1 and hot-fixes) |
| 10.00.2531.00 | SQL Server 2008 with service pack 1. |
| 10.00.1600.00 | SQL Server 2008, with no service pack applied. |
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.
@@version | Version and Service Pack |
|---|---|
| 9.00.4035 | SQL Server 2005 with service pack 3. |
| 9.00.3054 | SQL Server 2005 with service pack 2 GDR2. |
| 9.00.3050 | SQL Server 2005 with service pack 2 GDR1. |
| 9.00.3042 | SQL Server 2005 with service pack 2. |
| 2005.90.2047 | SQL Server 2005 with service pack 1. |
| 2005.90.1399 | SQL Server 2005 with no service pack applied. |
@@version | Version and Service Pack |
|---|---|
| 8.00.2039 | SQL Server 2000 with Service Pack 4 |
| 8.00.760 | SQL Server 2000 with Service Pack 3a |
| 8.00.760 | SQL Server 2000 with Service Pack 3. |
| 8.00.532 | SQL Server 2000 with Service Pack 2 |
| 8.00.384 | SQL Server 2000 with Service Pack 1 |
| 8.00.194 | SQL Server 2000 with no service pack applied |
@@version | Version and Service Pack |
|---|---|
| 7.00.1063 | SQL Server 7 with Service Pack 4 |
| 7.00.961 | SQL Server 7 with Service Pack 3 |
| 7.00.842 | SQL Server 7 with Service Pack 2 |
| 7.00.699 | SQL Server 7 with Service Pack 1 |
| 7.00.623 | SQL Server 7 with no service pack applied |
@@version | Version and Service Pack |
|---|---|
| 6.50.479 | SQL Server 6.5 with Service Pack 5a (updated) |
| 6.50.416 | SQL Server 6.5 with Service Pack 5a. |
| 6.50.415 | SQL Server 6.5 with Service Pack 5 |
| 6.50.281 | SQL Server 6.5 with Service Pack 4 |
| 6.50.258 | SQL Server 6.5 with Service Pack 3 |
| 6.50.240 | SQL Server 6.5 with Service Pack 2 |
| 6.50.213 | SQL Server 6.5 with Service Pack 1 |
| 6.50.201 | SQL Server 6.5 with no service pack applied |
@@version | Version and Service Pack |
|---|---|
| 6.00.151 | SQL Server 6 with Service Pack 3 |
| 6.00.139 | SQL Server 6 with Service Pack 2 |
| 6.00.124 | SQL Server 6 with Service Pack 1 |
| 6.00.121 | SQL 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 ..