MSSQL 빌드넘버에 따른 상세 설명

시스템운영/MSSQL|2012.10.15 11:44

 

 

 

MSSQL 빌드넘버에 따른 상세 설명

 

1. 버전 확인 방법 : select @@version

 

 

 

 

SQL Server

Version

Build Number

Build Description

SQL Server 7.0

7.0

Unknown SQL Server 7.0 Build

SQL Server 7.0

7.00.1063

Unknown Build

SQL Server 2000

8.00.194

2000 No Service Pack

SQL Server 2000

8.00.210

2000 No Service Pack + Q275900

SQL Server 2000

8.00.211

2000 No Service Pack + Q276329

SQL Server 2000

8.00.203

Unknown Build

SQL Server 2000

8.00.204

2000 No Service Pack + Q274329

SQL Server 2000

8.00.205

2000 Service Pack 3 + Q274330

SQL Server 2000

8.00.217

2000 No Service Pack + Q279293 / Q279296

SQL Server 2000

8.00.218

2000 No Service Pack + Q279183

SQL Server 2000

8.00.222

2000 No Service Pack + Q281769

SQL Server 2000

8.00.223

2000 No Service Pack + Q280380

SQL Server 2000

8.00.225

2000 No Service Pack + Q281663

SQL Server 2000

8.00.226

2000 No Service Pack + Q278239

SQL Server 2000

8.00.231

2000 No Service Pack + Q282279

SQL Server 2000

8.00.233

2000 No Service Pack + Q282416

SQL Server 2000

8.00.239

2000 No Service Pack + Q285290

SQL Server 2000

8.00.249

2000 No Service Pack + Q288122

SQL Server 2000

8.00.250

2000 No Service Pack + Q291683

SQL Server 2000

8.00.287

2000 No Service Pack + Q297209

SQL Server 2000

8.00.384

2000 Service Pack 1

SQL Server 2000

8.00.428

2000 Service Pack 1 + Q304850

SQL Server 2000

8.00.443

2000 Service Pack 1 + Q307538

SQL Server 2000

8.00.444

2000 Service Pack 1 + Q307540 / Q307655

SQL Server 2000

8.00.452

2000 Service Pack 1 + Q308547

SQL Server 2000

8.00.475

2000 Service Pack 1 + hot fix

SQL Server 2000

8.00.532

2000 Service Pack 2

SQL Server 2000

8.00.534

2000 Service Pack 2.01

SQL Server 2000

8.00.534

2000 Service Pack 2.01

SQL Server 2000

8.00.561

2000 Service Pack 2 + hot fix

SQL Server 2000

8.00.561

2000 Service Pack 2 + hot fix

SQL Server 2000

8.00.578

2000 Service Pack 2 + Q317979

SQL Server 2000

8.00.578

2000 Service Pack 2 + Q317979

SQL Server 2000

8.00.604

2000 Service Pack 2 + hot fix

SQL Server 2000

8.00.608

2000 Service Pack 2 + Q319507

SQL Server 2000

8.00.655

2000 Service Pack 2 + Q323875

SQL Server 2000

8.00.667

2000 Service Pack 2 + hot fix

SQL Server 2000

8.00.760

2000 Service Pack 3a

SQL Server 2000

8.00.765

2000 Service Pack 3a + Q810163/688/811611/813769/813759/812995/814665/460/813494

SQL Server 2000

8.00.780

2000 Service Pack 3a + Q815114 hot fix

SQL Server 2000

8.00.818

2000 Service Pack 3a + Q815495 cumulative security update

SQL Server 2000

8.00.859

2000 Service Pack 3a + Q821334 hotfix

SQL Server 2000

8.00.873

2000 Service Pack 3a + Q830887 hotfix

SQL Server 2000

8.00.878

2000 Service Pack 3a + Q831950

SQL Server 2000

8.00.952

2000 Service Pack 3a + hot fix build 2000.80.952

SQL Server 2000

8.00.977

2000 Service Pack 3a + hotfix build 2000.80.977

SQL Server 2000

8.00.997

2000 Service Pack 3a + Q891311

SQL Server 2000

8.00.998

2000 Service Pack 3a + Hot Fix Build 2000.80.978

SQL Server 2000

8.00.1001

2000 Service Pack 3a + Hot Fix Build 2000.80.1001

SQL Server 2000

8.00.1007

2000 Service Pack 3a + Hot Fix Build 2000.80.1007

SQL Server 2000

8.00.1029

2000 Service Pack 3a + Hot Fix build 2000.80.1029

SQL Server 2000

8.00.2039

2000 Service Pack 4

SQL Server 2000

8.00.2040

2000 Service Pack 4 + AWE Hotfix Q899761

SQL Server 2000

8.00.2050

2000 Service Pack 4 + Security Update MS08-040

SQL Server 2000

8.00.2055

2000 Service Pack 4 + Security Update KB960082

SQL Server 2000

8.00.2145

2000 Service Pack 4 + Q926906[1]/Q836651[2]

SQL Server 2000

8.00.2148

2000 Service Pack 4 + Q899430[3]/Q899431/Q900390/Q900404/Q901212/Q902150/Q902955

SQL Server 2000

8.00.2166

2000 Service Pack 4 + Hotfix Build KB909734[4]

SQL Server 2000

8.00.2171

2000 Service Pack 4 + Hotfix Build KB909369[5]

SQL Server 2000

8.00.2187

2000 with Hot Fix Build 2000.80.2187

SQL Server 2000

8.00.2249

Unknown Build

SQL Server 2000

8.00.2273

2000 Service Pack 4 + Security Update MS08-040 (QFE) Note: QFE 2273 (KB948111) == GDR 2050 (KB948110)

SQL Server 2000

8.00.2282

2000 Service Pack 4 + Security Update KB960083

SQL Server 2005

9.00.1187.07

2005 June CTP Release (Pre RTM)

SQL Server 2005

9.00.1399.06

2005 No Service Pack (RTM)

SQL Server 2005

9.00.1406.00

Unknown Build

SQL Server 2005

9.00.1541.00

2005 with Hot Fix Build 2005.90.1541

SQL Server 2005

9.00.2047.00

2005 Service Pack 1

SQL Server 2005

9.00.2050.00

Unknown Build

SQL Server 2005

9.00.2153.00

Unknown Build

SQL Server 2005

9.00.3042.00

2005 Service Pack 2

SQL Server 2005

9.00.3050.00

2005 Service Pack 2 + Post-GDR update

SQL Server 2005

9.00.3054.00

2005 Service Pack 2 + Cumulative Hotfix 3054

SQL Server 2005

9.00.3068.00

Unknown Build

SQL Server 2005

9.00.3073.00

Unknown Build

SQL Server 2005

9.00.3077.00

Unknown Build

SQL Server 2005

9.00.3159.00

Unknown Build

SQL Server 2005

9.00.3200.00

Unknown Build

SQL Server 2005

9.00.3215.00

Unknown Build

SQL Server 2005

9.00.3228.00

Unknown Build

SQL Server 2005

9.00.3239.00

Unknown Build

SQL Server 2005

9.00.3257.00

Unknown Build

SQL Server 2005

9.00.3282.00

Unknown Build

SQL Server 2005

9.00.3310.00

2005 Service Pack 2 + MS09-004 Security Patch

SQL Server 2005

9.00.4035.00

2005 Service Pack 3

SQL Server 2005

9.00.4207.00

2005 Service Pack 3 + Cumulative update package 1

SQL Server 2005

9.00.4211.00

2005 Service Pack 3 + Cumulative update package 2

SQL Server 2005

9.00.4216.00

2005 Service Pack 3 + Analysis Services service crash fix

SQL Server 2005

9.00.4216.00

2005 Service Pack 3 + Hotfix 3318

SQL Server 2005

9.00.4220.0

2005 Service Pack 3 + Cumulative update package 3

SQL Server 2005

9.00.4226.0

2005 Service Pack 3 + Cumulative update package 4

SQL Server 2005

9.00.4305.0

2005 Service Pack 3 + Cumulative update package 10 Hotfix request

SQL Server 2008

10.0.1600.22

SQL Server 2008 RTM

SQL Server 2008

10.00.2531.00

SQL Server 2008 Service Pack 1

SQL Server 2008

10.00.2710.00

SQL Server 2008 Service Pack 1 + Cumulative update package 1

SQL Server 2008

10.00.2714.00

SQL Server 2008 Service Pack 1 + Cumulative update package 2

SQL Server 2008

10.00.2723.00

SQL Server 2008 Service Pack 1 + Cumulative update package 3

SQL Server 2008

10.00.2734.00

SQL Server 2008 Service Pack 1 + Cumulative update package 4

SQL Server 2008

10.00.2746.00

SQL Server 2008 Service Pack 1 + Cumulative update package 5

SQL Server 2008

10.00.2757.00

SQL Server 2008 Service Pack 1 + Cumulative update package 6

SQL Server 2008

10.00.2766.00

SQL Server 2008 Service Pack 1 + Cumulative update package 7

SQL Server 2008

10.00.2775.00

SQL Server 2008 Service Pack 1 + Cumulative update package 8 Hotfix request

SQL Server 2008 R2

10.50.1600.10

SQL Server 2008 R2 RTM

SQL Server 2008 R2

10.50.1702.00

SQL Server 2008 R2 Cumulative update package 1 Hotfix request

SQL Server 2008 R2

10.50.1720.00

SQL Server 2008 R2 Cumulative update package 2 Hotfix re

 

SQL Server 버전과 에디션을 확인하는 방법 : http://support.microsoft.com/kb/321185 

 

태그 : ,

댓글()