SqlServer 版本号

 

 

RTM (no SP)

SP1

SP2

SP3

SP4

 SQL Server 2014
     codename Hekaton SQL14

12.00.2000.8

 

 

 

 

 SQL Server 2012
     codename Denali

11.00.2100.60

11.00.3000.0

11.00.5058.0

 

 

 SQL Server 2008 R2
     codename Kilimanjaro

10.50.1600.1

10.50.2500.0
or 10.51.2500.0

10.50.4000.0
or 10.52.4000.0

 

 

 SQL Server 2008
     codename Katmai

10.00.1600.22

10.00.2531.0

10.00.4000.0

10.00.5500.0

 

 SQL Server 2005
     codename Yukon

9.00.1399.06

9.00.2047

9.00.3042

9.00.4035

9.00.5000

 SQL Server 2000
     codename Shiloh

8.00.194

8.00.384

8.00.532

8.00.760

8.00.2039

 SQL Server 7.0
     codename Sphinx

7.00.623

7.00.699

7.00.842

7.00.961

7.00.1063

All SQLServer service packs are cumulative, meaning that each new service pack contains all the fixes that are included with previous service packs and any new fixes.

You can comment here. If you know of a hotfix build or KB that we don't have listed here, please use the comments.


Microsoft SQL Server 2014 Builds

Build

File version

KB / Description

Release Date

12.00.2370

2014.120.2370.0

2967546 Cumulative update package 2 (CU2) for SQL Server 2014

June 27, 2014

12.00.2342

2014.120.2342.0

2931693 Cumulative update package 1 (CU1) for SQL Server 2014

April 21, 2014

12.00.2000

2014.120.2000.8

SQL Server 2014 RTM

April 1, 2014

12.00.1524

2014.120.1524.0

Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)

October 15, 2013

11.00.9120

2013.110.9120.0

Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1)

June 25, 2013

Microsoft SQL Server 2012 Builds

Build

File version

KB / Description

Release Date

11.00.9000

2011.110.9000.5

Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3)

November 27, 2012

11.00.5532

2011.110.5532.0

2976982 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 2

July 24, 2014 *new

11.00.5522

2011.110.5522.0

2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP2)

June 20, 2014

11.00.5058

2011.110.5058.0

SQL Server 2012 Service Pack 2 (SP2)

June 10, 2014

11.00.3449

2011.110.3449.0

2975396 Cumulative update package 11 (CU11) for SQL Server 2012 Service Pack 1

July 21, 2014 *new

11.00.3437

2011.110.3437.0

2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP1)

June 10, 2014

11.00.3431

2011.110.3431.0

2954099 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 1

May 19, 2014

11.00.3412

2011.110.3412.0

2931078 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 1

March 18, 2014

11.00.3401

2011.110.3401.0

2917531 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 1

January 20, 2014

11.00.3393

2011.110.3393.0

2894115 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1

November 18, 2013

11.00.3381

2011.110.3381.0

2874879 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 1

September 16, 2013

11.00.3373

2011.110.3373.0

2861107 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 1

July 16, 2013

11.00.3368

2011.110.3368.0

2833645 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 1

May 31, 2013

11.00.3350

2011.110.3350.0

2832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1

April 17, 2013

11.00.3349

2011.110.3349.0

2812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1

March 18, 2013

11.00.3339

2011.110.3339.0

2790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1

January 25, 2013

11.00.3335

2011.110.3335.0

2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1

January 14, 2013

11.00.3321

2011.110.3321.0

2765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1

November 20, 2012

11.00.3128

2011.110.3128.0

2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1

January 3, 2013

11.00.3000

2011.110.3000.0

SQL Server 2012 Service Pack 1 (SP1)

November 6, 2012

11.00.2845

2011.110.2845.0

SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4)

September 20, 2012

11.00.2809

2011.110.2809.24

SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3)

July 5, 2012

11.00.2424

2011.110.2424.0

2908007 Cumulative update package 11 (CU11) for SQL Server 2012

December 17, 2013

11.00.2420

2011.110.2420.0

2891666 Cumulative update package 10 (CU10) for SQL Server 2012

October 21, 2013

11.00.2419

2011.110.2419.0

2867319 Cumulative update package 9 (CU9) for SQL Server 2012

August 21, 2013

11.00.2410

2011.110.2410.0

2844205 Cumulative update package 8 (CU8) for SQL Server 2012

June 18, 2013

11.00.2405

2011.110.2405.0

2823247 Cumulative update package 7 (CU7) for SQL Server 2012

April 15, 2013

11.00.2401

2011.110.2401.0

2728897 Cumulative update package 6 (CU6) for SQL Server 2012

February 18, 2013

11.00.2395

2011.110.2395.0

2777772 Cumulative update package 5 (CU5) for SQL Server 2012

December 18, 2012

11.00.2383

2011.110.2383.0

2758687 Cumulative update package 4 (CU4) for SQL Server 2012

October 18, 2012

11.00.2376

2011.110.2376.0

Microsoft Security Bulletin MS12-070

October 9, 2012

11.00.2332

2011.110.2332.0

2723749 Cumulative update package 3 (CU3) for SQL Server 2012

August 29, 2012

11.00.2325

2011.110.2325.0

2703275 Cumulative update package 2 (CU2) for SQL Server 2012

June 18, 2012

11.00.2316

2011.110.2316.0

2679368 Cumulative update package 1 (CU1) for SQL Server 2012

April 12, 2012

11.00.2218

2011.110.2218.0

Microsoft Security Bulletin MS12-070

October 9, 2012

11.00.2214

2011.110.2214.0

2685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence

April 6, 2012

11.00.2100

2011.110.2100.60

SQL Server 2012 RTM

March 6, 2012

11.00.1913

2011.110.1913.37

Microsoft SQL Server 2012 Release Candidate 1 (RC1)

December 16, 2011

11.00.1750

2011.110.1750.32

Microsoft SQL Server 2012 Release Candidate 0 (RC0)

November 17, 2011

11.00.1440

2010.110.1440.19

Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 3 (CTP3)

July 11, 2011

11.00.1103

2010.110.1103.9

Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 1 (CTP1)

November 8, 2010

Microsoft SQL Server 2008 R2 Builds

Build

File version

KB / Description

Release Date

10.50.4319

2009.100.4319.0

2967540 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 2

June 30, 2014

10.50.4305

2009.100.4305.0

2938478 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 2

April 21, 2014

10.50.4302

2009.100.4302.0

2926028 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 2

February 18, 2014

10.50.4297

2009.100.4297.0

2908087 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 2

December 16, 2013

10.50.4295

2009.100.4295.0

2887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2

October 29, 2013

10.50.4290

2009.100.4290.0

2871401 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 2

August 30, 2013

10.50.4286

2009.100.4286.0

2844090 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 2

June 17, 2013

10.50.4285

2009.100.4285.0

2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (updated)

June 13, 2013

10.50.4279

2009.100.4279.0

2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (replaced)

April 15, 2013

10.50.4276

2009.100.4276.0

2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2

February 18, 2013

10.50.4270

2009.100.4270.0

2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2

December 17, 2012

10.50.4266

2009.100.4266.0

2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2

October 15, 2012

10.50.4263

2009.100.4263.0

2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2

August 29, 2012

10.50.4260

2009.100.4260.0

2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2

August 1, 2012

10.50.4000

2009.100.4000.0

SQL Server 2008 R2 Service Pack 2 (SP2)

July 26, 2012

10.50.3720

2009.100.3720.0

SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP)

May 13, 2012

10.50.2881

2009.100.2881.0

2868244 An on-demand hotfix update package for SQL Server 2008 R2 Service Pack 1

August 12, 2013

10.50.2876

2009.100.2876.0

2855792 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 1

June 17, 2013

10.50.2875

2009.100.2875.0

2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (updated)

June 13, 2013

10.50.2874

2009.100.2874.0

2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (replaced)

April 15, 2013

10.50.2861

2009.100.2861.0

Microsoft Security Bulletin MS12-070

October 9, 2012

10.50.2869

2009.100.2869.0

2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1

February 18, 2013

10.50.2868

2009.100.2868.0

2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1

December 17, 2012

10.50.2866

2009.100.2866.0

2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1

November 6, 2012

10.50.2861

2009.100.2861.0

2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012

October 9, 2012

10.50.2822

2009.100.2822.0

2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1

August 29, 2012

10.50.2817

2009.100.2817.0

2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1

June 18, 2012

10.50.2811

2009.100.2811.0

2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1

April 16, 2012

10.50.2807

2009.100.2807.0

2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2

March 12, 2012

10.50.2806

2009.100.2806.0

2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1

February 22, 2012

10.50.2799

2009.100.2799.0

2633357 FIX: "Non-yielding Scheduler" error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2

February 22, 2012

10.50.2796

2009.100.2796.0

2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1

December 20, 2011

10.50.2789

2009.100.2789.0

2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1

October 17, 2011

10.50.2776

2009.100.2776.0

2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2

October 18, 2011

10.50.2772

2009.100.2772.0

2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1

August 15, 2011

10.50.2769

2009.100.2769.0

2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1

July 18, 2011

10.50.2550

2009.100.2550.0

Microsoft Security Bulletin MS12-070

October 9, 2012

10.50.2500

2009.100.2500.0

SQL Server 2008 R2 Service Pack 1 (SP1)

July 11, 2011

10.50.1817

2009.100.1817.0

2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2

June 18, 2012

10.50.1815

2009.100.1815.0

2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2

April 17, 2012

10.50.1810

2009.100.1810.0

2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2

February 21, 2012

10.50.1809

2009.100.1809.0

2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2

January 9, 2012

10.50.1807

2009.100.1807.0

2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2

October 19, 2011

10.50.1804

2009.100.1804.0

2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2

August 16, 2011

10.50.1800

2009.100.1800.0

2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system

October 18, 2011

10.50.1797

2009.100.1797.0

2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2

June 20, 2011

10.50.1790

2009.100.1790.0

2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011

June 17, 2011

10.50.1777

2009.100.1777.0

2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2

June 16, 2011

10.50.1769

2009.100.1769.0

2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used

April 18, 2011

10.50.1765

2009.100.1765.0

2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2

February 21, 2011

10.50.1753

2009.100.1753.0

2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2

December 23, 2010

10.50.1746

2009.100.1746.0

2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2

October 18, 2010

10.50.1734

2009.100.1734.0

2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2

August 20, 2010

10.50.1720

2009.100.1720.0

2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2

June 25, 2010

10.50.1702

2009.100.1702.0

981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2

May 18, 2010

10.50.1617

2009.100.1617.0

2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011

June 14, 2011

10.50.1600

2009.100.1600.1

SQL Server 2008 R2 RTM

April 21, 2010

10.50.1352

2009.100.1352.12

Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP)

November 12, 2009

10.50.1092

2009.100.1092.20

Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)

June 30, 2009

Microsoft SQL Server 2008 Builds

Build

File version

KB / Description

Release Date

10.00.5861

2007.100.5861.0

2958696 Cumulative update package 17 (CU17) for SQL Server 2008 Service Pack 3

May 19, 2014

10.00.5852

2007.100.5852.0

2936421 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 3

March 17, 2014

10.00.5850

2007.100.5850.0

2923520 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 3

January 20, 2014

10.00.5848

2007.100.5848.0

2893410 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 3

November 18, 2013

10.00.5846

2007.100.5846.0

2880350 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 3

September 16, 2013

10.00.5844

2007.100.5844.0

2863205 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 3

July 16, 2013

10.00.5841

2007.100.5841.0

2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (updated)

June 13, 2013

10.00.5840

2007.100.5840.0

2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (replaced)

May 20, 2013

10.00.5835

2007.100.5835.0

2814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3

March 18, 2013

10.00.5829

2007.100.5829.0

2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3

January 23, 2013

10.00.5828

2007.100.5828.0

2771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3

November 19, 2012

10.00.5826

2007.100.5826.0

2716435 Microsoft Security Bulletin MS12-070

October 9, 2012

10.00.5794

2007.100.5794.0

2738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3

September 21, 2012

10.00.5788

2007.100.5788.0

2715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3

July 16, 2012

10.00.5785

2007.100.5785.0

2696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3

May 19, 2012

10.00.5775

2007.100.5775.0

2673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3

March 20, 2012

10.00.5770

2007.100.5770.0

2648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3

January 16, 2012

10.00.5768

2007.100.5768.0

2633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3

November 22, 2011

10.00.5766

2007.100.5766.0

2617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3

October 18, 2011

10.00.5512

2007.100.5512.0

Microsoft Security Bulletin MS12-070

October 9, 2012

10.00.5500

2007.100.5500.0

SQL Server 2008 Service Pack 3 (SP3)

October 6, 2011

10.00.5416

2007.100.5416.0

SQL Server 2008 Service Pack 3 CTP

August 22, 2011

10.00.4371

2007.100.4371.0

Microsoft Security Bulletin MS12-070

October 9, 2012

10.00.4333

2007.100.4333.0

2715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2

July 16, 2012

10.00.4332

2007.100.4332.0

2696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2

May 20, 2012

10.00.4330

2007.100.4330.0

2673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2

March 19, 2012

10.00.4326

2007.100.4326.0

2648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2

January 30, 2012

10.00.4323

2007.100.4323.0

2617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2

November 21, 2011

10.00.4321

2007.100.4321.0

2582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2

September 20, 2011

10.00.4316

2007.100.4316.0

2555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2

July 18, 2011

10.00.4285

2007.100.4285.0

2527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2

May 16, 2011

10.00.4279

2007.100.4279.0

2498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2

March 11, 2011

10.00.4272

2007.100.4272.0

2467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2

February 10, 2011

10.00.4266

2007.100.4266.0

2289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2

November 15, 2010

10.00.4067

2007.100.4067.0

Microsoft Security Bulletin MS12-070

October 9, 2012

10.00.4064

2007.100.4064.0

2494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011

June 14, 2011

10.00.4000

2007.100.4000.0

SQL Server 2008 Service Pack 2 (SP2)

September 29, 2010

10.00.3798

2007.100.3798.0

SQL Server 2008 Service Pack 2 CTP

July 7, 2010

10.00.2850

2007.100.2850.0

2582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1

September 19, 2011

10.00.2847

2007.100.2847.0

2555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1

July 18, 2011

10.00.2821

2007.100.2821.0

2527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1

May 16, 2011

10.00.2816

2007.100.2816.0

2497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1

March 22, 2011

10.00.2808

2007.100.2808.0

2467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1

February 10, 2011

10.00.2804

2007.100.2804.0

2413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1

November 15, 2010

10.00.2799

2007.100.2799.0

2279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1

September 21, 2010

10.00.2789

2007.100.2789.0

2083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1

July 21, 2010

10.00.2787

2007.100.2787.0

2231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8

July 30, 2010

10.00.2775

2007.100.2775.0

981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1

May 17, 2010

10.00.2766

2007.100.2766.0

979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1

March 26, 2010

10.00.2757

2007.100.2757.0

977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1

January 18, 2010

10.00.2746

2007.100.2746.0

975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1

November 16, 2009

10.00.2740

2007.100.2740.0

976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"

November 24, 2009

10.00.2734

2007.100.2734.0

973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1

September 22, 2009

10.00.2723

2007.100.2723.0

971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1

July 21, 2009

10.00.2714

2007.100.2714.0

970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1

May 18, 2009

10.00.2712

2007.100.2712.0

'. Cannot insert duplicate key in object ''"" target="_blank" rel="nofollow" >970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'"

July 21, 2009

10.00.2710

2007.100.2710.0

969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1

April 16, 2009

10.00.2573

2007.100.2573.0

2494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011

June 14, 2011

10.00.2531

2007.100.2531.0

SQL Server 2008 Service Pack 1 (SP1)

April 7, 2009

10.00.2520

2007.100.2520.0

SQL Server 2008 Service Pack 1 - CTP

February 23, 2009

10.00.1835

2007.100.1835.0

979064 Cumulative update package 10 (CU10) for SQL Server 2008

March 15, 2010

10.00.1828

2007.100.1828.0

977444 Cumulative update package 9 (CU9) for SQL Server 2008

January 18, 2010

10.00.1823

2007.100.1823.0

975976 Cumulative update package 8 (CU8) for SQL Server 2008

November 16, 2009

10.00.1818

2007.100.1818.0

973601 Cumulative update package 7 (CU7) for SQL Server 2008

September 21, 2009

10.00.1812

2007.100.1812.0

971490 Cumulative update package 6 (CU6) for SQL Server 2008

July 21, 2009

10.00.1806

2007.100.1806.0

969531 Cumulative update package 5 (CU5) for SQL Server 2008

May 18, 2009

10.00.1798

2007.100.1798.0

963036 Cumulative update package 4 (CU4) for SQL Server 2008

March 17, 2009

10.00.1787

2007.100.1787.0

960484 Cumulative update package 3 (CU3) for SQL Server 2008

January 19, 2009

10.00.1779

2007.100.1779.0

958186 Cumulative update package 2 (CU2) for SQL Server 2008

November 19, 2008

10.00.1771

2007.100.1771.0

958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008

October 29, 2008

10.00.1763

2007.100.1763.0

956717 Cumulative update package 1 (CU1) for SQL Server 2008

October 28, 2008

10.00.1750

2007.100.1750.0

956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008

August 25, 2008

10.00.1600

2007.100.1600.22

SQL Server 2008 RTM

August 7, 2008

10.00.1442

2007.100.1442.32

Microsoft SQL Server 2008 RC0

June 5, 2008

10.00.1300

2007.100.1300.13

Microsoft SQL Server 2008 CTP, February 2008

February 19, 2008

10.00.1075

2007.100.1075.23

Microsoft SQL Server 2008 CTP, November 2007

November 18, 2007

10.00.1049

2007.100.1049.14

SQL Server 2008 CTP, July 2007

July 31, 2007

10.00.1019

2007.100.1019.17

SQL Server 2008 CTP, June 2007

May 21, 2007




Microsoft SQL Server 2005 Builds

Build

File version

KB / Description

Release Date

9.00.5324

2005.90.5324.0

2716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE

October 9, 2012

9.00.5296

2005.90.5296.0

2615425 FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated

October 24, 2011

9.00.5295

2005.90.5295.0

2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

May 21, 2012

9.00.5294

2005.90.5294.0

2572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005

August 10, 2011

9.00.5292

2005.90.5292.0

2494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011

June 14, 2011

9.00.5266

2005.90.5266.0

2507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4

March 22, 2011

9.00.5259

2005.90.5259.0

2489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4

February 22, 2011

9.00.5254

2005.90.5254.0

2464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4

December 24, 2010

9.00.5069

2005.90.5069.0

Microsoft Security Bulletin MS12-070

October 9, 2012

9.00.5057

2005.90.5057.0

2494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011

June 14, 2011

9.00.5000

2005.90.5000.0

SQL Server 2005 Service Pack 4 (SP4)

December 17, 2010

9.00.4912

2005.90.4912.0

SQL Server 2005 Service Pack 4 (SP4) - Customer Technology Preview (CTP)

November 3, 2010

9.00.4342

2005.90.4342.0

2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

May 21, 2012

9.00.4340

2005.90.4340.0

2494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011

June 14, 2011

9.00.4325

2005.90.4325.0

2507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3

March 22, 2011

9.00.4317

2005.90.4317.0

2489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3

February 21, 2011

9.00.4315

2005.90.4315.0

2438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3

December 23, 2010

9.00.4311

2005.90.4311.0

2345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3

October 18, 2010

9.00.4309

2005.90.4309.0

2258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3

August 16, 2010

9.00.4305

2005.90.4305.0

983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3

June 23, 2010

9.00.4294

2005.90.4294.0

980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3

April 19, 2010

9.00.4285

2005.90.4285.0

978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3

February 16, 2010

9.00.4273

2005.90.4273.0

976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3

December 21, 2009

9.00.4268

2005.90.4268.0

977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: "Cannot create the subscription because the subscription already exists in the subscription database"

December 21, 2009

9.00.4266

2005.90.4266.0

974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3

October 19, 2009

9.00.4262

2005.90.4262.0

970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009

October 13, 2009

9.00.4230

2005.90.4230.0

972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3

August 17, 2009

9.00.4226

2005.90.4226.0

970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3

June 16, 2009

9.00.4224

2005.90.4224.0

971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"

June 16, 2009

9.00.4220

2005.90.4220.0

967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3

April 20, 2009

9.00.4216

2005.90.4216.0

967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005

April 20, 2009

9.00.4211

2005.90.4211.0

961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3

February 17, 2009

9.00.4207

2005.90.4207.0

959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3

December 20, 2008

9.00.4060

2005.90.4060.0

2494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011

June 14, 2011

9.00.4053

2005.90.4053.0

970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009

October 13, 2009

9.00.4035

2005.90.4035.0

SQL Server 2005 Service Pack 3 (SP3)

December 15, 2008

9.00.4028

2005.90.4028.0

SQL Server 2005 Service Pack 3 (SP3) - CTP

October 27, 2008

9.00.3356

2005.90.3356.0

976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2

December 21, 2009

9.00.3355

2005.90.3355.0

974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2

October 19, 2009

9.00.3353

2005.90.3353.0

970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009

October 13, 2009

9.00.3330

2005.90.3330.0

972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2

August 18, 2009

9.00.3328

2005.90.3328.0

970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2

June 16, 2009

9.00.3325

2005.90.3325.0

967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2

April 20, 2009

9.00.3320

2005.90.3320.0

969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"

April 1, 2009

9.00.3318

2005.90.3318.0

967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider

April 20, 2009

9.00.3315

2005.90.3315.0

962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2

February 17, 2009

9.00.3310

2005.90.3310.0

960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009

February 10, 2009

9.00.3301

2005.90.3301.0

958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2

December 16, 2008

9.00.3294

2005.90.3294.0

956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2

October 20, 2008

9.00.3282

2005.90.3282.0

953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2

June 16, 2008

9.00.3260

2005.90.3260.0

' returned message 'No transaction is active'"" target="_blank" rel="nofollow" >954950 FIX: Error message when you run a distributed query in SQL Server 2005: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'"

July 14, 2008

9.00.3259

2005.90.3259.0

954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session

August 14, 2008

9.00.3259

2005.90.3259.0

954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

July 14, 2008

9.00.3257

2005.90.3257.0

951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2

June 18, 2008

9.00.3246

2005.90.3246.0

952233 FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance

May 23, 2008

9.00.3244

2005.90.3244.0

952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005

June 3, 2008

9.00.3240

2005.90.3240.0

951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005

May 21, 2008

9.00.3239

2005.90.3239.0

949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2

April 17, 2008

9.00.3232

2005.90.3232.0

949959 FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article 'ArticleName' - Reason: 'Invalid input parameter values. Check the status values for detail.'"

March 19, 2008

9.00.3231

2005.90.3231.0

949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler"

March 18, 2008

9.00.3231

2005.90.3231.0

949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction"

March 14, 2008

9.00.3230

2005.90.3230.0

949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page"

March 7, 2008

9.00.3228

2005.90.3228.0

946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2

February 19, 2008

9.00.3224

2005.90.3224.0

947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005

February 4, 2008

9.00.3221

2005.90.3221.0

942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005

January 31, 2008

9.00.3221

2005.90.3221.0

945443 FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query

January 11, 2008

9.00.3221

2005.90.3221.0

945916 FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"

January 10, 2008

9.00.3221

2005.90.3221.0

945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005

January 9, 2008

9.00.3215

2005.90.3215.0

943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2

December 18, 2007

9.00.3208

2005.90.3208.0

944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005

November 21, 2007

9.00.3206

2005.90.3206.0

944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005

December 11, 2007

9.00.3200

2005.90.3200.0

941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2

October 17, 2007

9.00.3194

2005.90.3194.0

940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005

September 24, 2007

9.00.3186

2005.90.3186.0

940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005

August 29, 2007

9.00.3186

2005.90.3186.0

940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005

August 24, 2007

9.00.3186

2005.90.3186.0

940269 FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"

August 23, 2007

9.00.3186

2005.90.3186.0

940945 FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005

August 22, 2007

9.00.3186

2005.90.3186.0

940937 FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'"

August 21, 2007

9.00.3186

2005.90.3186.0

' exceeded retry count"" target="_blank" rel="nofollow" >940379 FIX: Error message when you use the UNLOAD and REWIND options to back up a database to a tape device in SQL Server 2005: "Operation on device '<TapeDevice>' exceeded retry count"

August 20, 2007

9.00.3186

2005.90.3186.0

940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005

August 20, 2007

9.00.3186

2005.90.3186.0

937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:"Insufficient memory to continue the execution of the program"

August 20, 2007

9.00.3186

2005.90.3186.0

940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005

August 20, 2007

9.00.3186

2005.90.3186.0

938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005

August 17, 2007

9.00.3186

2005.90.3186.0

, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'"" target="_blank" rel="nofollow" >940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'"

August 17, 2007

9.00.3186

2005.90.3186.0

returned message"" target="_blank" rel="nofollow" >940221 FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

August 17, 2007

9.00.3186

2005.90.3186.0

940942 FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch"

August 17, 2007

9.00.3186

2005.90.3186.0

940384 FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installed

August 13, 2007

9.00.3186

2005.90.3186.0

940281 FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005

August 13, 2007

9.00.3186

2005.90.3186.0

940545 FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005

August 10, 2007

9.00.3186

2005.90.3186.0

940210 FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: "A system assertion check has failed"

August 8, 2007

9.00.3186

2005.90.3186.0

939537 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 2

August 23, 2007

9.00.3182

2005.90.3182.0

940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005

August 3, 2007

9.00.3179

2005.90.3179.0

938243 FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: "The execution of a full-text query failed. The content index is corrupt."

July 30, 2007

9.00.3178

2005.90.3178.0

938086 FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005

August 22, 2007

9.00.3177

2005.90.3177.0

939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

August 22, 2007

9.00.3177

2005.90.3177.0

939562 FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan"

August 20, 2007

9.00.3177

2005.90.3177.0

, Line 42 String or binary data would be truncated"" target="_blank" rel="nofollow" >939563 FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: "MSmerge_del_<GUID>, Line 42 String or binary data would be truncated"

August 9, 2007

9.00.3175

2005.90.3175.0

936534 FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable""

August 20, 2007

9.00.3175

2005.90.3175.0

938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005

August 1, 2007

9.00.3175

2005.90.3175.0

936488 The service pack update or hotfix installation stops unexpectedly when you try to install either Microsoft SQL Server 2005 Service Pack 2 or a hotfix for SQL Server 2005 SP2

July 10, 2007

9.00.3175

2005.90.3175.0

938825 FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication

June 29, 2007

9.00.3175

2005.90.3175.0

936305 Cumulative update package 2 (CU2 build 3175) for SQL Server 2005 Service Pack 2 is available

June 28, 2007

9.00.3171

2005.90.3171.0

937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

July 16, 2007

9.00.3169

2005.90.3169.0

' reported an error the provider ran out of memory"" target="_blank" rel="nofollow" >937033 FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory"

June 19, 2007

9.00.3169

2005.90.3169.0

937041 FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005

May 25, 2007

9.00.3166

2005.90.3166.0

936185 FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high

June 11, 2007

9.00.3166

2005.90.3166.0

934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005

July 16, 2007

9.00.3161

2005.90.3161.0

935789 FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join

September 24, 2007

9.00.3161

2005.90.3161.0

934706 FIX: Error message when you perform a piecemeal restore operation after you enable vardecimal database compression in SQL Server 2005 Service Pack 2: "Piecemeal restore is not supported when an upgrade is involved"

June 4, 2007

9.00.3161

2005.90.3161.0

933724 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005

May 9, 2007

9.00.3161

2005.90.3161.0

935356 Cumulative update package (CU1 build 3161) for SQL Server 2005 Service Pack 2 is available

April 16, 2007

9.00.3159

2005.90.3159.0

934459 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3150 through 3158

April 3, 2007

9.00.3156

2005.90.3156.0

934226 FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)"

April 25, 2007

9.00.3155

2005.90.3155.0

933808 FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: "The XML data type is damaged"

June 13, 2007

9.00.3155

2005.90.3155.0

933499 FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query"

June 12, 2007

9.00.3155

2005.90.3155.0

933766 FIX: Failed assertion message in the Errorlog file when you perform various operations in SQL Server 2005: "Failed Assertion = 'fFalse' Attempt to access expired blob handle (3)"

May 15, 2007

9.00.3155

2005.90.3155.0

933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005

April 25, 2007

9.00.3154

2005.90.3154.0

934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005

April 25, 2007

9.00.3154

2005.90.3154.0

934109 FIX: The Distribution Agent generates an access violation when you configure a transactional replication publication to run an additional script after the snapshot is applied at the subscriber in SQL Server 2005

April 25, 2007

9.00.3154

2005.90.3154.0

934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database

April 25, 2007

9.00.3153

2005.90.3153.0

933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005

April 16, 2007

9.00.3152

2005.90.3152.0

933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

March 7, 2007

9.00.3080

2005.90.3080.0

970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009

October 13, 2009

9.00.3077

2005.90.3077.0

960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009

February 10, 2009

9.00.3073

2005.90.3073.0

954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008

September 9, 2008

9.00.3068

2005.90.3068.0

941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege

August 5, 2008

9.00.3054

2005.90.3054.0

934458 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053

January 2, 2008

9.00.3050

2005.90.3050.0

933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended

March 7, 2007

9.00.3042

2005.90.3042.0

SQL Server 2005 Service Pack 2 (SP2)

February 19, 2007

9.00.3033

2005.90.3033.0

SQL Server 2005 Service Pack 2 (SP2) - CTP December 2006

December 19, 2006

9.00.3027

2005.90.3027.0

SQL Server 2005 Service Pack 2 (SP2) - CTP November 2006

November 6, 2006

9.00.3026

2005.90.3026.0

929376 FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load

February 14, 2007

9.00.2239

2005.90.2239.0

940961 FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005

September 24, 2007

9.00.2237

2005.90.2237.0

940719 FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

September 24, 2007

9.00.2236

2005.90.2236.0

940287 FIX: Error message when you use Service Broker in SQL Server 2005: "An error occurred while receiving data: '64(The specified network name is no longer available.)'"

July 29, 2007

9.00.2236

2005.90.2236.0

940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005

July 26, 2007

9.00.2234

2005.90.2234.0

937343 FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb database

June 20, 2007

9.00.2233

2005.90.2233.0

937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error"

June 18, 2007

9.00.2233

2005.90.2233.0

933499 FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query"

June 12, 2007

9.00.2233

2005.90.2233.0

937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database

June 5, 2007

9.00.2232

2005.90.2232.0

937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005

June 19, 2007

9.00.2231

2005.90.2231.0

934812 FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005

November 6, 2007

9.00.2230

2005.90.2230.0

936179 FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

September 20, 2007

9.00.2229

2005.90.2229.0

935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk

June 11, 2007

9.00.2227

2005.90.2227.0

933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005

June 26, 2007

9.00.2226

2005.90.2226.0

934065 FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: "The merge process failed to execute a query because the query timed out"

June 22, 2007

9.00.2226

2005.90.2226.0

933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005

June 22, 2007

9.00.2223

2005.90.2223.0

932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1

June 18, 2007

9.00.2221

2005.90.2221.0

931593 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds

July 11, 2007

9.00.2219

2005.90.2219.0

932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005

April 25, 2007

9.00.2218

2005.90.2218.0

931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped

April 25, 2007

9.00.2216

2005.90.2216.0

931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has an x64-based version of SQL Server 2005 installed

May 15, 2007

9.00.2214

2005.90.2214.0

930505 FIX: Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: "Could not find stored procedure"

February 19, 2007

9.00.2214

2005.90.2214.0

929240 FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005

February 13, 2007

9.00.2211

2005.90.2211.0

930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005

February 20, 2007

9.00.2211

2005.90.2211.0

930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005

February 14, 2007

9.00.2209

2005.90.2209.0

929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390

February 7, 2007

9.00.2208

2005.90.2208.0

929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005

January 9, 2007

9.00.2207

2005.90.2207.0

928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005

December 19, 2006

9.00.2207

2005.90.2207.0

928372 FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: "A severe error occurred on the current command"

December 19, 2006

9.00.2207

2005.90.2207.0

928789 FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue"

January 2, 2007

9.00.2206

2005.90.2206.0

928083 FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005

February 1, 2007

9.00.2206

2005.90.2206.0

928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005

January 12, 2007

9.00.2206

2005.90.2206.0

926493 FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: Msg 3456, Level 16, State 1, Line 1. Could not redo log record"

January 2, 2007

9.00.2206

2005.90.2206.0

928539 FIX: An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005

December 13, 2006

9.00.2202

2005.90.2202.0

927643 FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005

February 16, 2007

9.00.2201

2005.90.2201.0

927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication

January 10, 2007

9.00.2198

2005.90.2198.0

926613 FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005

February 21, 2007

9.00.2198

2005.90.2198.0

926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services

February 20, 2007

9.00.2198

2005.90.2198.0

924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005

February 2, 2007

9.00.2198

2005.90.2198.0

924264 FIX: The metadata of the Description object of a Key Performance Indicator appears in the default language after you define a translation for the Description object in SQL Server 2005 Business Intelligence Development Studio

December 13, 2006

9.00.2198

2005.90.2198.0

926612 FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005

January 4, 2007

9.00.2198

2005.90.2198.0

926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: "Query processor could not produce a query plan because of the hints defined in this query"

November 16, 2006

9.00.2198

2005.90.2198.0

926611 FIX: SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005

November 28, 2006

9.00.2198

2005.90.2198.0

924808 FIX: You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005

December 13, 2006

9.00.2198

2005.90.2198.0

925277 FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005

January 2, 2007

9.00.2196

2005.90.2196.0

926285 Fix: Error message when you convert a column from the varbinary(max) data type to the XML data type in SQL Server 2005: "Msg 6322, Level 16, State 1, Line 2 Too many attributes or namespace definitions"

November 10, 2006

9.00.2196

2005.90.2196.0

926335 FIX: Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1”

December 5, 2006

9.00.2195

2005.90.2195.0

926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source

December 19, 2006

9.00.2194

2005.90.2194.0

925744 FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"

October 20, 2006

9.00.2192

2005.90.2192.0

924954 FIX: Error message when you use a table-valued function (TVF) together with the CROSS APPLY operator in a query in SQL Server 2005: "There is insufficient system memory to run this query"

September 29, 2006

9.00.2192

2005.90.2192.0

925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: "Incorrect syntax near 'X'"

October 5, 2006

9.00.2191

2005.90.2191.0

925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber

December 6, 2006

9.00.2190

2005.90.2190.0

925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: "Invalid cursor state (0)"

October 16, 2006

9.00.2189

2005.90.2189.0

925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005

September 22, 2006

9.00.2187

2005.90.2187.0

923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease

September 22, 2006

9.00.2181

2005.90.2181.0

923605 FIX: A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors

February 19, 2007

9.00.2181

2005.90.2181.0

923624 FIX: Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: "insufficient system memory to run this query"

October 4, 2006

9.00.2176

2005.90.2176.0

922594 FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered"

February 12, 2007

9.00.2176

2005.90.2176.0

923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005

September 6, 2006

9.00.2175

2005.90.2175.0

921395 FIX: The color and the background image may not appear when you try to display a report in HTML format in Report Manager in SQL Server 2005 Reporting Services

August 8, 2006

9.00.2175

2005.90.2175.0

917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor

August 14, 2006

9.00.2175

2005.90.2175.0

922578 FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log

August 30, 2006

9.00.2175

2005.90.2175.0

922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database

December 14, 2006

9.00.2175

2005.90.2175.0

921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005

December 18, 2006

9.00.2174

2005.90.2174.0

922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1

July 25, 2006

9.00.2167

2005.90.2167.0

920974 FIX: SQL Server 2005 treats an identity column in a view as an ordinary int column when the compatibility level of the database is set to 80

August 9, 2006

9.00.2164

2005.90.2164.0

919243 FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005

February 8, 2007

9.00.2164

2005.90.2164.0

920346 FIX: SQL Server 2005 may overestimate the cardinality of the JOIN operator when a SQL Server 2005 query contains a join predicate that is a multicolumn predicate

September 19, 2006

9.00.2164

2005.90.2164.0

920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative

September 19, 2006

9.00.2164

2005.90.2164.0

919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: "Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402"

October 26, 2006

9.00.2164

2005.90.2164.0

921003 FIX: You may receive an error message when you manually define a Back Up Database task in SQL Server 2005 to back up the transaction log

August 29, 2006

9.00.2164

2005.90.2164.0

920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization

September 26, 2006

9.00.2164

2005.90.2164.0

918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object

September 6, 2006

9.00.2164

2005.90.2164.0

919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005

July 26, 2006

9.00.2164

2005.90.2164.0

919775 FIX: The BULK INSERT statement may not return any errors when you try to import data from a text file to a table by using the BULK INSERT statement in Microsoft SQL Server 2005

August 9, 2006

9.00.2156

2005.90.2156.0

919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1

July 26, 2006

9.00.2153

2005.90.2153.0

918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is available

September 14, 2006

9.00.2153

2005.90.2153.0

919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005

May 23, 2006

9.00.2050

2005.90.2050.0

932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047

July 11, 2007

9.00.2047

2005.90.2047.0

SQL Server 2005 Service Pack 1 (SP1)

April 18, 2006

9.00.2040

2005.90.2040.0

SQL Server 2005 Service Pack 1 (SP1) CTP March 2006

March 12, 2006

9.00.2029

2005.90.2029.0

SLQ Server 2005 Service Pack 1 (SP1) Beta

 

9.00.1561

2005.90.1561.0

932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds

July 11, 2007

9.00.1558

2005.90.1558.0

926493 FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record"

January 4, 2007

9.00.1554

2005.90.1554.0

926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random order

June 26, 2007

9.00.1551

2005.90.1551.0

has been cancelled"" target="_blank" rel="nofollow" >922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package <PackageName> has been cancelled"

January 22, 2007

9.00.1551

2005.90.1551.0

922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database

November 22, 2006

9.00.1550

2005.90.1550.0

917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005

July 26, 2006

9.00.1550

2005.90.1550.0

921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005

November 22, 2006

9.00.1547

2005.90.1547.0

918276 FIX: You notice additional random trailing character in values when you retrieve the values from a fixed-size character column or a fixed-size binary column of a table in SQL Server 2005

November 20, 2006

9.00.1545

2005.90.1545.0

917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor

August 14, 2006

9.00.1541

2005.90.1541.0

917888 FIX: Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: "Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources"

November 22, 2006

9.00.1541

2005.90.1541.0

917971 FIX: You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groups

November 22, 2006

9.00.1539

2005.90.1539.0

917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement

August 11, 2006

9.00.1538

2005.90.1538.0

917824 FIX: The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schema

July 26, 2006

9.00.1536

2005.90.1536.0

917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005

July 26, 2006

9.00.1534

2005.90.1534.0

916706 FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005

May 15, 2007

9.00.1533

2005.90.1533.0

916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005

July 26, 2006

9.00.1532

2005.90.1532.0

916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005

January 9, 2007

9.00.1531

2005.90.1531.0

915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005

July 26, 2006

9.00.1528

2005.90.1528.0

915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005

January 15, 2007

9.00.1528

2005.90.1528.0

915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005

January 4, 2007

9.00.1528

2005.90.1528.0

915307 FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005

January 11, 2007

9.00.1528

2005.90.1528.0

915306 FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication

January 8, 2007

9.00.1528

2005.90.1528.0

915112 FIX: Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: "The request failed to run because the batch is aborted"

July 26, 2006

9.00.1519

2005.90.1519.0

913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005

January 20, 2007

9.00.1518

2005.90.1518.0

913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005

September 22, 2006

9.00.1518

2005.90.1518.0

912472 FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005

July 26, 2006

9.00.1518

2005.90.1518.0

913371 FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005

July 26, 2006

9.00.1514

2005.90.1514.0

912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005

July 26, 2006

9.00.1503

2005.90.1503.0

911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005

July 26, 2006

9.00.1502

2005.90.1502.0

915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005

July 26, 2006

9.00.1500

2005.90.1500.0

910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: "A severe error occurred on the current command"

June 1, 2006

9.00.1406

2005.90.1406.0

932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399

July 11, 2007

9.00.1399

2005.90.1399.0

SQL Server 2005 RTM

November 7, 2005




Microsoft SQL Server 2000 Builds

Build

File version

KB / Description

Release Date

8.00.2305

2000.80.2305.0

983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012

August 14, 2012

8.00.2301

2000.80.2301.0

983809 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 QFE: April 10, 2012

April 10, 2012

8.00.2283

2000.80.2283.0

971524 FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004

June 15, 2009

8.00.2282

2000.80.2282.0

960083 MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009

February 10, 2009

8.00.2279

2000.80.2279.0

959678 FIX: When you run the SPSBackup.exe utility to back up a SQL Server 2000 database that is configured as a back-end database for a Windows SharePoint Services server, the backup operation fails

April 8, 2009

8.00.2273

2000.80.2273.0

948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000 July 8, 2008

August 5, 2008

8.00.2271

2000.80.2271.0

946584 FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current database

March 12, 2008

8.00.2265

2000.80.2265.0

944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 "merge replication" publisher

December 19, 2007

8.00.2253

2000.80.2253.0

939317 FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has multiple processors

October 9, 2007

8.00.2249

2000.80.2249.0

936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000

May 25, 2007

8.00.2248

2000.80.2248.0

935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000

June 14, 2007

8.00.2246

2000.80.2246.0

935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000

June 18, 2007

8.00.2245

2000.80.2245.0

933573 FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000

April 24, 2007

8.00.2244

2000.80.2244.0

934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer

May 10, 2007

8.00.2242

2000.80.2242.0

929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor

March 28, 2007

8.00.2238

2000.80.2238.0

931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4

February 21, 2007

8.00.2236

2000.80.2236.0

930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement

February 2, 2007

8.00.2234

2000.80.2234.0

929440 FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: "644" or "2511"

February 22, 2007

8.00.2232

2000.80.2232.0

928568 FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file

January 15, 2007

8.00.2231

2000.80.2231.0

928079 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000

June 19, 2007

8.00.2229

2000.80.2229.0

927186 FIX: Error message when you create a merge replication for tables that have computed columns in SQL Server 2000 Service Pack 4: "The process could not log conflict information"

July 24, 2007

8.00.2226

2000.80.2226.0

925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000

November 20, 2006

8.00.2226

2000.80.2226.0

925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000

November 13, 2006

8.00.2223

2000.80.2223.0

925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000

July 20, 2007

8.00.2223

2000.80.2223.0

925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: "The process could not enumerate changes at the 'Subscriber'"

October 31, 2006

8.00.2218

2000.80.2218.0

925297 FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000

June 19, 2007

8.00.2217

2000.80.2217.0

924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000

October 25, 2007

8.00.2215

2000.80.2215.0

923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher

January 12, 2007

8.00.2215

2000.80.2215.0

924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000

October 5, 2006

8.00.2215

2000.80.2215.0

923563 FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: "Implicit conversion from datatype 'text' to 'nvarchar' is not allowed"

October 30, 2006

8.00.2215

2000.80.2215.0

923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000

December 28, 2006

8.00.2209

2000.80.2209.0

923797 The Knowledge Base (KB) Article You Requested Is Currently Not Available

 

8.00.2207

2000.80.2207.0

923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs

August 28, 2006

8.00.2201

2000.80.2201.0

920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000

August 21, 2006

8.00.2199

2000.80.2199.0

919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication

July 26, 2006

8.00.2197

2000.80.2197.0

919133 FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000

August 2, 2006

8.00.2197

2000.80.2197.0

919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000

August 8, 2006

8.00.2197

2000.80.2197.0

919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: "Failed to read trace data"

October 18, 2006

8.00.2196

2000.80.2196.0

919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000

August 14, 2006

8.00.2194

2000.80.2194.0

917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding

February 21, 2007

8.00.2194

2000.80.2194.0

917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000

September 22, 2006

8.00.2192

2000.80.2192.0

917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4

August 4, 2006

8.00.2191

2000.80.2191.0

916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'"

July 26, 2006

8.00.2191

2000.80.2191.0

916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer

October 3, 2006

8.00.2189

2000.80.2189.0

916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000

July 26, 2006

8.00.2189

2000.80.2189.0

913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4

July 19, 2006

8.00.2187

2000.80.2187.0

915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000

June 18, 2007

8.00.2187

2000.80.2187.0

916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187

October 16, 2006

8.00.2187

2000.80.2187.0

914384 FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000

July 26, 2006

8.00.2187

2000.80.2187.0

915065 FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: "An error in updating your system has occurred"

December 11, 2006

8.00.2180

2000.80.2180.0

913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000

February 19, 2007

8.00.2180

2000.80.2180.0

913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor

July 26, 2006

8.00.2175

2000.80.2175.0

911678 FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000

July 26, 2006

8.00.2172

2000.80.2172.0

910707 FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000

July 26, 2006

8.00.2171

2000.80.2171.0

909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected

July 26, 2006

8.00.2168

2000.80.2168.0

907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1

November 21, 2006

8.00.2166

2000.80.2166.0

909734 FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4

July 26, 2006

8.00.2162

2000.80.2162.0

904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162

September 15, 2006

8.00.2159

2000.80.2159.0

907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000

July 26, 2006

8.00.2156

2000.80.2156.0

906790 FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit

July 25, 2006

8.00.2151

2000.80.2151.0

903742 FIX: You receive an "Error: 8526, Severity: 16, State: 2" error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4

July 25, 2006

8.00.2151

2000.80.2151.0

904244 FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4

June 13, 2007

8.00.2148

2000.80.2148.0

899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000

July 25, 2006

8.00.2148

2000.80.2148.0

899431 FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4

July 25, 2006

8.00.2148

2000.80.2148.0

900390 FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents

June 1, 2006

8.00.2148

2000.80.2148.0

900404 FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000

June 1, 2006

8.00.2148

2000.80.2148.0

901212 FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 SP4

July 25, 2006

8.00.2148

2000.80.2148.0

902150 FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer

June 1, 2006

8.00.2148

2000.80.2148.0

902955 FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4

July 25, 2006

8.00.2147

2000.80.2147.0

899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors

June 1, 2006

8.00.2145

2000.80.2145.0

826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly

October 25, 2005

8.00.2145

2000.80.2145.0

836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins

June 7, 2006

8.00.2066

2000.80.2066.0

Microsoft Security Bulletin MS12-060

August 14, 2012

8.00.2065

2000.80.2065.0

983808 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 GDR: April 10, 2012

April 10, 2012

8.00.2055

2000.80.2055.0

959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution

February 10, 2009

8.00.2040

2000.80.2040.0

899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4

August 15, 2006

8.00.2039

2000.80.2039.0

SQL Server 2000 Service Pack 4 (SP4)

May 6, 2005

8.00.2026

2000.80.2026.0

SQL Server 2000 Service Pack 4 (SP4) Beta

 

8.00.1547

2000.80.1547.0

899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors

June 1, 2006

8.00.1077

2000.80.1077.0

983814 MS12-070: Description of the security update for SQL Server 2000 Reporting Services Service Pack 2

October 9, 2012

8.00.1037

2000.80.1037.0

930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement

February 2, 2007

8.00.1036

2000.80.1036.0

929410 FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0"

January 11, 2007

8.00.1035

2000.80.1035.0

917593 FIX: The "Audit Logout" event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000

September 22, 2006

8.00.1034

2000.80.1034.0

915328 FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000

August 9, 2006

8.00.1029

2000.80.1029.0

902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: "Internal SQL Server error"

June 1, 2006

8.00.1027

2000.80.1027.0

900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000

July 25, 2006

8.00.1025

2000.80.1025.0

899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3

June 1, 2006

8.00.1025

2000.80.1025.0

899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000

July 25, 2006

8.00.1024

2000.80.1024.0

898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"

July 25, 2006

8.00.1021

2000.80.1021.0

887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000

July 25, 2006

8.00.1020

2000.80.1020.0

896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3

July 25, 2006

8.00.1019

2000.80.1019.0

897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000

June 1, 2006

8.00.1017

2000.80.1017.0

896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000

June 1, 2006

8.00.1014

2000.80.1014.0

895123 FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000

June 1, 2006

8.00.1014

2000.80.1014.0

895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000

July 25, 2006

8.00.1013

2000.80.1013.0

891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000

June 1, 2006

8.00.1009

2000.80.1009.0

894257 FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000

June 1, 2006

8.00.1007

2000.80.1007.0

893312 FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000

June 1, 2006

8.00.1003

2000.80.1003.0

892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000

June 1, 2006

8.00.1001

2000.80.1001.0

892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation

June 1, 2006

8.00.1000

2000.80.1000.0

891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000

June 1, 2006

8.00.997

2000.80.997.0

891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log

July 18, 2006

8.00.996

2000.80.996.0

891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation

June 1, 2006

8.00.996

2000.80.996.0

891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations

June 1, 2006

8.00.994

2000.80.994.0

890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3

June 1, 2006

8.00.994

2000.80.994.0

890768 FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000

June 1, 2006

8.00.994

2000.80.994.0

890767 FIX: You receive a "Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1" error message when the sum of the length of the published column names in a merge publication exceeds 4,000 characters in SQL Server 2000

June 1, 2006

8.00.993

2000.80.993.0

890925 FIX: The @@ERROR system function may return an incorrect value when you execute a Transact-SQL statement that uses a parallel execution plan in SQL Server 2000 32-bit or in SQL Server 2000 64-bit

June 1, 2006

8.00.993

2000.80.993.0

888444 FIX: You receive a 17883 error in SQL Server 2000 Service Pack 3 or in SQL Server 2000 Service Pack 3a when a worker thread becomes stuck in a registry call

June 1, 2006

8.00.993

2000.80.993.0

890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: "Could not perform the requested operation because the minimum query memory is not available"

May 15, 2006

8.00.991

2000.80.991.0

889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected

June 1, 2006

8.00.990

2000.80.990.0

890200 FIX: SQL Server 2000 stops listening for new TCP/IP Socket connections unexpectedly after error message 17882 is written to the SQL Server 2000 error log

June 1, 2006

8.00.988

2000.80.988.0

889166 FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000

June 1, 2006

8.00.985

2000.80.985.0

889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000

June 1, 2006

8.00.980

2000.80.980.0

887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3

June 1, 2006

8.00.977

2000.80.977.0

888007 You receive a "The product does not have a prerequisite update installed" error message when you try to install a SQL Server 2000 post-Service Pack 3 hotfix

August 31, 2005

8.00.973

2000.80.973.0

884554 FIX: A SPID stops responding with a NETWORKIO (0x800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet

June 1, 2006

8.00.972

2000.80.972.0

885290 FIX: An assertion error occurs when you insert data in the same row in a table by using multiple connections to an instance of SQL Server

June 1, 2006

8.00.970

2000.80.970.0

872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000

June 1, 2006

8.00.967

2000.80.967.0

878501 FIX: You may receive an error message when you run a SET IDENTITY_INSERT ON statement on a table and then try to insert a row into the table in SQL Server 2000

June 1, 2006

8.00.962

2000.80.962.0

883415 FIX: A user-defined function returns results that are not correct for a query

June 1, 2006

8.00.961

2000.80.961.0

873446 FIX: An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMP

June 1, 2006

8.00.959

2000.80.959.0

878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement

June 1, 2006

8.00.957

2000.80.957.0

870994 FIX: An access violation exception may occur when you run a query that uses index names in the WITH INDEX option to specify an index hint

June 1, 2006

8.00.955

2000.80.955.0

867798 FIX: The @date_received parameter of the xp_readmail extended stored procedure incorrectly returns the date and the time that an e-mail message is submitted by the sender in SQL Server 2000

January 8, 2007

8.00.954

2000.80.954.0

843282 FIX: The Osql.exe utility does not run a Transact-SQL script completely if you start the program from a remote session by using a background service and then log off the console session

January 5, 2007

8.00.952

2000.80.952.0

867878 FIX: The Log Reader Agent may cause 17883 error messages

June 1, 2006

8.00.952

2000.80.952.0

867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribers

June 1, 2006

8.00.952

2000.80.952.0

867880 FIX: Merge Agent may fail with an "Invalid character value for cast specification" error message

June 1, 2006

8.00.949

2000.80.949.0

843266 FIX: Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3)

June 2, 2006

8.00.948

2000.80.948.0

843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server

June 1, 2006

8.00.944

2000.80.944.0

839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2

June 5, 2006

8.00.937

2000.80.937.0

841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures

June 1, 2006

8.00.936

2000.80.936.0

841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances

June 1, 2006

8.00.935

2000.80.935.0

841401 FIX: You may notice incorrect values for the "Active Transactions" counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer

June 1, 2006

8.00.934

2000.80.934.0

841404 FIX: You may receive a "The query processor could not produce a query plan" error message in SQL Server when you run a query that includes multiple subqueries that use self-joins

June 1, 2006

8.00.933

2000.80.933.0

840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3

June 2, 2006

8.00.929

2000.80.929.0

839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly

June 1, 2006

8.00.928

2000.80.928.0

839589 FIX: The thread priority is raised for some threads in a parallel query

June 1, 2006

8.00.927

2000.80.927.0

839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters

June 1, 2006

8.00.926

2000.80.926.0

839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000

June 1, 2006

8.00.923

2000.80.923.0

838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later

June 1, 2006

8.00.922

2000.80.922.0

837970 FIX: You may receive an "Invalid object name..." error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000

October 25, 2005

8.00.919

2000.80.919.0

837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000

October 25, 2005

8.00.916

2000.80.916.0

317989 FIX: Sqlakw32.dll May Corrupt SQL Statements

September 27, 2005

8.00.915

2000.80.915.0

837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows

October 25, 2005

8.00.913

2000.80.913.0

836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins

June 7, 2006

8.00.911

2000.80.911.0

837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000

October 25, 2005

8.00.910

2000.80.910.0

834798 FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start

October 25, 2005

8.00.908

2000.80.908.0

834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED

October 25, 2005

8.00.904

2000.80.904.0

834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication

April 22, 2005

8.00.892

2000.80.892.0

833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devices

October 25, 2005

8.00.891

2000.80.891.0

836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer

April 1, 2005

8.00.879

2000.80.879.0

832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000

October 25, 2005

8.00.878

2000.80.878.0

831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server

October 25, 2005

8.00.876

2000.80.876.0

830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be Truncated

October 25, 2005

8.00.876

2000.80.876.0

831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000

October 25, 2005

8.00.876

2000.80.876.0

831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000

October 25, 2005

8.00.873

2000.80.873.0

830887 FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfix

October 25, 2005

8.00.871

2000.80.871.0

830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file

October 25, 2005

8.00.871

2000.80.871.0

830860 FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache

October 25, 2005

8.00.870

2000.80.870.0

830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values

October 25, 2005

8.00.869

2000.80.869.0

830588 FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler

October 25, 2005

8.00.866

2000.80.866.0

830366 FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031

January 16, 2006

8.00.865

2000.80.865.0

830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed column

October 25, 2005

8.00.865

2000.80.865.0

828945 FIX: You cannot insert explicit values in an IDENTITY column of a SQL Server table by using the SQLBulkOperations function or the SQLSetPos ODBC function in SQL Server 2000

October 25, 2005

8.00.863

2000.80.863.0

829205 FIX: Query performance may be slow and may be inconsistent when you run a query while another query that contains an IN operator with many values is compiled

October 25, 2005

8.00.863

2000.80.863.0

829444 FIX: A floating point exception occurs during the optimization of a query

October 25, 2005

8.00.859

2000.80.859.0

821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859

March 31, 2005

8.00.858

2000.80.858.0

828637 FIX: Users Can Control the Compensating Change Process in Merge Replication

October 25, 2005

8.00.857

2000.80.857.0

828017 The Knowledge Base (KB) Article You Requested Is Currently Not Available

 

8.00.857

2000.80.857.0

827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level

November 23, 2005

8.00.857

2000.80.857.0

828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager

October 25, 2005

8.00.856

2000.80.856.0

828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter Criteria

October 25, 2005

8.00.854

2000.80.854.0

828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many Objects

October 25, 2005

8.00.852

2000.80.852.0

830466 FIX: You may receive an "Internal SQL Server error" error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000

April 1, 2005

8.00.852

2000.80.852.0

827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity

October 25, 2005

8.00.851

2000.80.851.0

826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS Command

October 25, 2005

8.00.850

2000.80.850.0

826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset Cursor

October 25, 2005

8.00.850

2000.80.850.0

826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries

October 25, 2005

8.00.850

2000.80.850.0

826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly

October 25, 2005

8.00.848

2000.80.848.0

826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special User

October 25, 2005

8.00.847

2000.80.847.0

826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems

October 25, 2005

8.00.845

2000.80.845.0

826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server Collation

October 5, 2005

8.00.845

2000.80.845.0

825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to True

October 25, 2005

8.00.844

2000.80.844.0

826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clients

October 17, 2006

8.00.842

2000.80.842.0

825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table

October 25, 2005

8.00.841

2000.80.841.0

825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause

October 25, 2005

8.00.840

2000.80.840.0

319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors

September 27, 2005

8.00.840

2000.80.840.0

319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors

September 27, 2005

8.00.839

2000.80.839.0

823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR Clauses

October 25, 2005

8.00.839

2000.80.839.0

824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecute

October 25, 2005

8.00.837

2000.80.837.0

820788 FIX: Delayed domain authentication may cause SQL Server to stop responding

October 25, 2005

8.00.837

2000.80.837.0

821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock

October 25, 2005

8.00.837

2000.80.837.0

821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3

October 25, 2005

8.00.837

2000.80.837.0

821740 FIX: MS DTC Transaction Commit Operation Blocks Itself

October 25, 2005

8.00.837

2000.80.837.0

823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly

October 25, 2005

8.00.819

2000.80.819.0

826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login

October 25, 2005

8.00.818

2000.80.818.0

821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3

January 9, 2006

8.00.818

2000.80.818.0

821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit

March 16, 2005

8.00.818

2000.80.818.0

818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions

February 10, 2005

8.00.818

2000.80.818.0

826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login

October 25, 2005

8.00.818

2000.80.818.0

821280 MS03-031: Security Patch for SQL Server 2000 64-bit

March 14, 2006

8.00.816

2000.80.816.0

818766 FIX: Intense SQL Server activity results in spinloop wait

October 25, 2005

8.00.814

2000.80.814.0

819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers

October 25, 2005

8.00.811

2000.80.811.0

819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000

April 3, 2006

8.00.811

2000.80.811.0

819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers

October 25, 2005

8.00.811

2000.80.811.0

818897 FIX: Invalid TDS Sent to SQL Server Results in Access Violation

October 25, 2005

8.00.807

2000.80.807.0

818899 FIX: Error Message 3628 May Occur When You Run a Complex Query

October 25, 2005

8.00.804

2000.80.804.0

818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex Query

October 25, 2005

8.00.801

2000.80.801.0

818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package

January 26, 2006

8.00.800

2000.80.800.0

818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows Service

September 27, 2005

8.00.800

2000.80.800.0

818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical Indexes

September 27, 2005

8.00.800

2000.80.800.0

818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow

September 27, 2005

8.00.798

2000.80.798.0

817464 FIX: Using Sp_executesql in Merge Agent Operations

September 27, 2005

8.00.794

2000.80.794.0

817464 FIX: Using Sp_executesql in Merge Agent Operations

September 27, 2005

8.00.794

2000.80.794.0

813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column

September 27, 2005

8.00.794

2000.80.794.0

816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query

September 27, 2005

8.00.794

2000.80.794.0

817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins

February 11, 2005

8.00.791

2000.80.791.0

815249 FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server

September 27, 2005

8.00.790

2000.80.790.0

817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table

September 27, 2005

8.00.789

2000.80.789.0

816840 FIX: Error 17883 May Display Message Text That Is Not Correct

September 27, 2005

8.00.788

2000.80.788.0

816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000

September 27, 2005

8.00.781

2000.80.781.0

815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All Files

September 27, 2005

8.00.780

2000.80.780.0

816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN Collation

September 27, 2005

8.00.780

2000.80.780.0

816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement

September 27, 2005

8.00.780

2000.80.780.0

810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a

October 10, 2006

8.00.779

2000.80.779.0

814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3

September 27, 2005

8.00.776

2000.80.776.0

Unidentified

 

8.00.775

2000.80.775.0

815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR

September 27, 2005

8.00.769

2000.80.769.0

814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error

September 27, 2005

8.00.769

2000.80.769.0

814893 FIX: Error Message: "Insufficient key column information for updating" Occurs in SQL Server 2000 SP3

September 27, 2005

8.00.765

2000.80.765.0

810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined

September 27, 2005

8.00.765

2000.80.765.0

810688 FIX: Merge Agent Can Resend Changes for Filtered Publications

September 27, 2005

8.00.765

2000.80.765.0

811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence

September 27, 2005

8.00.765

2000.80.765.0

813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service

September 27, 2005

8.00.763

2000.80.763.0

814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3

September 27, 2005

8.00.762

2000.80.762.0

814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3

September 27, 2005

8.00.760

2000.80.760.0

SQL Server 2000 Service Pack 3 (SP3 / SP3a)

August 27, 2003

8.00.743

2000.80.743.0

818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2

October 18, 2005

8.00.743

2000.80.743.0

818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2

October 25, 2005

8.00.741

2000.80.741.0

818096 FIX: Many Extent Lock Time-outs May Occur During Extent Allocation

February 10, 2005

8.00.736

2000.80.736.0

816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object

September 27, 2005

8.00.735

2000.80.735.0

814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error

September 27, 2005

8.00.733

2000.80.733.0

813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query Performance

September 27, 2005

8.00.730

2000.80.730.0

813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service

September 27, 2005

8.00.728

2000.80.728.0

814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention Period

September 27, 2005

8.00.725

2000.80.725.0

812995 FIX: A Query with an Aggregate Function May Fail with a 3628 Error

September 27, 2005

8.00.725

2000.80.725.0

813494 FIX: Distribution Agent Fails with "Violation of Primary Key Constraint" Error Message

September 27, 2005

8.00.723

2000.80.723.0

812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile Time

September 27, 2005

8.00.721

2000.80.721.0

812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names

September 27, 2005

8.00.721

2000.80.721.0

812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock Escalation

September 27, 2005

8.00.718

2000.80.718.0

811703 FIX: Unexpected results from partial aggregations based on conversions

September 27, 2005

8.00.715

2000.80.715.0

810688 FIX: Merge Agent Can Resend Changes for Filtered Publications

September 27, 2005

8.00.715

2000.80.715.0

811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence

September 27, 2005

8.00.714

2000.80.714.0

811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp file

October 18, 2005

8.00.713

2000.80.713.0

811205 FIX: An error message occurs when you perform a database or a file SHRINK operation

September 27, 2005

8.00.710

2000.80.710.0

811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK Operation

September 27, 2005

8.00.705

2000.80.705.0

810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistent

September 27, 2005

8.00.703

2000.80.703.0

810526 FIX: Cursors That Have a Long Lifetime May Cause Memory Fragmentation

September 27, 2005

8.00.702

2000.80.702.0

328551 FIX: Concurrency enhancements for the tempdb database

July 19, 2006

8.00.701

2000.80.701.0

810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 Error

September 27, 2005

8.00.701

2000.80.701.0

810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined

September 27, 2005

8.00.700

2000.80.700.0

810072 FIX: Merge Replication Reconciler Stack Overflow

September 27, 2005

8.00.696

2000.80.696.0

810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a Connection

September 27, 2005

8.00.696

2000.80.696.0

810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations

September 27, 2005

8.00.695

2000.80.695.0

331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock Escalation

September 27, 2005

8.00.695

2000.80.695.0

331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already Exists

February 10, 2005

8.00.695

2000.80.695.0

331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received Order

February 10, 2005

8.00.693

2000.80.693.0

330212 FIX: Parallel logical operation returns results that are not consistent

September 27, 2005

8.00.690

2000.80.690.0

311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an Assertion

October 12, 2005

8.00.689

2000.80.689.0

329499 FIX: Replication Removed from Database After Restore WITH RECOVERY

October 11, 2005

8.00.688

2000.80.688.0

329487 FIX: Transaction Log Restore Fails with Message 3456

October 11, 2005

8.00.686

2000.80.686.0

316333 SQL Server 2000 Security Update for Service Pack 2

November 24, 2006

8.00.682

2000.80.682.0

319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED

October 18, 2005

8.00.679

2000.80.679.0

316333 SQL Server 2000 Security Update for Service Pack 2

November 24, 2006

8.00.678

2000.80.678.0

328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004

September 27, 2005

8.00.667

2000.80.667.0

2000 SP2+8/14 fix

 

8.00.665

2000.80.665.0

2000 SP2+8/8 fix

 

8.00.661

2000.80.661.0

326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occur

September 27, 2005

8.00.655

2000.80.655.0

2000 SP2+7/24 fix

 

8.00.652

2000.80.652.0

810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations

September 27, 2005

8.00.650

2000.80.650.0

322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked Buffers

November 5, 2003

8.00.644

2000.80.644.0

324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and Subqueries

September 27, 2005

8.00.636

2000.80.636.0

Microsoft Security Bulletin MS02-039

June 24, 2002

8.00.608

2000.80.608.0

319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers

June 21, 2004

8.00.604

2000.80.604.0

2000 SP2+3/29 fix

 

8.00.599

2000.80.599.0

319869 FIX: Improved SQL Manager Robustness for Odd Length Buffer

September 27, 2005

8.00.594

2000.80.594.0

319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors

September 27, 2005

8.00.584

2000.80.584.0

318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins

February 4, 2008

8.00.578

2000.80.578.0

317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source

September 27, 2005

8.00.578

2000.80.578.0

318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AV

September 27, 2005

8.00.568

2000.80.568.0

317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network Library

October 30, 2002

8.00.561

2000.80.561.0

2000 SP2+1/29 fix

 

8.00.558

2000.80.558.0

314003 FIX: Query That Uses DESC Index May Result in Access Violation

September 26, 2005

8.00.558

2000.80.558.0

315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA

September 27, 2005

8.00.552

2000.80.552.0

313002 The Knowledge Base (KB) Article You Requested Is Currently Not Available

 

8.00.552

2000.80.552.0

313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate

September 26, 2005

8.00.534

2000.80.534.0

2000 SP2.01

 

8.00.532

2000.80.532.0

SQL Server 2000 Service Pack 2 (SP2)

February 4, 2003

8.00.475

2000.80.475.0

2000 SP1+1/29 fix

 

8.00.474

2000.80.474.0

315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA

September 27, 2005

8.00.473

2000.80.473.0

314003 FIX: Query That Uses DESC Index May Result in Access Violation

September 26, 2005

8.00.471

2000.80.471.0

313302 FIX: Shared Table Lock Is Not Released After Lock Escalation

September 26, 2005

8.00.469

2000.80.469.0

313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate

September 26, 2005

8.00.452

2000.80.452.0

308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding

September 26, 2005

8.00.444

2000.80.444.0

307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory

September 26, 2005

8.00.444

2000.80.444.0

307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop Responding

October 7, 2005

8.00.443

2000.80.443.0

307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000

September 26, 2005

8.00.428

2000.80.428.0

304850 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers

August 5, 2004

8.00.384

2000.80.384.0

SQL Server 2000 Service Pack 1 (SP1)

June 11, 2001

8.00.296

2000.80.296.0

299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have

August 9, 2004

8.00.287

2000.80.287.0

297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH

October 7, 2005

8.00.251

2000.80.251.0

300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order

October 17, 2003

8.00.250

2000.80.250.0

291683 The Knowledge Base (KB) Article You Requested Is Currently Not Available

 

8.00.249

2000.80.249.0

288122 FIX: Lock Monitor Uses Excessive CPU

September 12, 2003

8.00.239

2000.80.239.0

285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access Violation

October 9, 2003

8.00.233

2000.80.233.0

282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time

October 9, 2003

8.00.231

2000.80.231.0

282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down

October 9, 2003

8.00.226

2000.80.226.0

278239 FIX: Extreme Memory Usage When Adding Many Security Roles

November 21, 2006

8.00.225

2000.80.225.0

281663 "Access Denied" Error Message When You Try to Use a Network Drive to Modify Windows 2000 Permissions

October 30, 2006

8.00.223

2000.80.223.0

280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures

June 29, 2004

8.00.222

2000.80.222.0

281769 FIX: Exception Access Violation Encountered During Query Normalization

October 7, 2005

8.00.218

2000.80.218.0

279183 FIX: Scripting Object with Several Extended Properties May Cause Exception

October 9, 2003

8.00.217

2000.80.217.0

279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown

October 9, 2003

8.00.211

2000.80.211.0

276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan

November 5, 2003

8.00.210

2000.80.210.0

275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slowly

October 9, 2003

8.00.205

2000.80.205.0

274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025

October 7, 2005

8.00.204

2000.80.204.0

274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins

October 9, 2003

8.00.194

2000.80.194.0

SQL Server 2000 RTM (no SP)

 

8.00.190

2000.80.190.0

SQL Server 2000 Gold

 

8.00.100

2000.80.100.0

SQL Server 2000 Beta 2

 

8.00.078

2000.80.078.0

SQL Server 2000 EAP5

 

8.00.047

2000.80.047.0

SQL Server 2000 EAP4

 




Microsoft SQL Server 7.0 Builds

Build

KB / Description

Release Date

7.00.1152

948113 MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008

May 9, 2012

7.00.1149

867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0

June 1, 2006

7.00.1143

830233 New Connection Events Are Not Recorded in SQL Server Traces

October 25, 2005

7.00.1143

829015 FIX: An attention signal that is sent from a SQL Server client application because of a query time-out may cause the SQL Server service to quit unexpectedly

October 25, 2005

7.00.1097

822756 A Complex UPDATE Statement That Uses an Index Spool Operation May Cause an Assertion

October 25, 2005

7.00.1094

821279 MS03-031: Security patch for SQL Server 7.0 Service Pack 4

May 11, 2006

7.00.1094

815495 MS03-031: Cumulative security patch for SQL Server

May 10, 2006

7.00.1092

820788 FIX: Delayed domain authentication may cause SQL Server to stop responding

October 25, 2005

7.00.1087

814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation

September 27, 2005

7.00.1079

329499 FIX: Replication Removed from Database After Restore WITH RECOVERY

October 11, 2005

7.00.1078

327068 INF: SQL Server 7.0 Security Update for Service Pack 4

September 27, 2005

7.00.1077

316333 SQL Server 2000 Security Update for Service Pack 2

November 24, 2006

7.00.1063

SQL Server 7.0 Service Pack 4 (SP4)

 

7.00.1033

324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactions

October 12, 2005

7.00.1026

319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED

October 18, 2005

7.00.1004

304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers

August 5, 2004

7.00.996

299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have

August 9, 2004

7.00.978

285870 FIX: Update With Self Join May Update Incorrect Number Of Rows

October 28, 2003

7.00.977

284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3

April 25, 2002

7.00.970

283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled

October 15, 2002

7.00.970

282243 FIX: Incorrect Results with Join of Column Converted to Binary

October 29, 2003

7.00.961

SQL Server 7.0 Service Pack 3 (SP3)

 

7.00.921

283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled

October 15, 2002

7.00.919

282243 FIX: Incorrect Results with Join of Column Converted to Binary

October 29, 2003

7.00.918

280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures

June 29, 2004

7.00.917

279180 FIX: Bcp.exe with Long Query String Can Result in Assertion Failure

September 26, 2005

7.00.910

275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221

October 31, 2003

7.00.905

274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624

July 15, 2004

7.00.889

243741 FIX: Replication Initialize Method Causes Handle Leak on Failure

October 5, 2005

7.00.879

281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349

March 14, 2006

7.00.857

260346 FIX: Transactional Publications with a Filter on Numeric Columns Fail to Replicate Data

March 14, 2006

7.00.843

266766 FIX: Temporary Stored Procedures in SA Owned Databases May Bypass Permission Checks When You Run Stored Procedures

March 14, 2006

7.00.842

SQL Server 7.0 Service Pack 2 (SP2)

 

7.00.839

SQL Server 7.0 Service Pack 2 (SP2) Unidentified

 

7.00.835

SQL Server 7.0 Service Pack 2 (SP2) Beta

 

7.00.776

258087 FIX: Non-Admin User That Executes Batch While Server Shuts Down May Encounter Retail Assertion

March 14, 2006

7.00.770

252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table

March 14, 2006

7.00.745

253738 FIX: SQL Server Components that Access the Registry in a Cluster Environment May Cause a Memory Leak

October 7, 2005

7.00.722

239458 FIX: Replication: Problems Mapping Characters to DB2 OLEDB Subscribers

October 5, 2005

7.00.699

SQL Server 7.0 Service Pack 1 (SP1)

 

7.00.689

SQL Server 7.0 Service Pack 1 (SP1) Beta

 

7.00.677

SQL Server 7.0 MSDE from Office 2000 disc

 

7.00.662

232707 FIX: Query with Complex View Hierarchy May Be Slow to Compile

October 5, 2005

7.00.658

244763 FIX: Access Violation Under High Cursor Stress

March 14, 2006

7.00.657

229875 FIX: Unable to Perform Automated Installation of SQL 7.0 Using File Images

October 5, 2005

7.00.643

220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special Characters

October 5, 2005

7.00.623

SQL Server 7.0 RTM (Gold, no SP)

November 27, 1998

7.00.583

SQL Server 7.0 RC1

 

7.00.517

SQL Server 7.0 Beta 3

 

 

怎查看SQL Server2000的版本号

select serverproperty('Edition') select serverproperty('ProductLevel') serverproperty函数返回有关服务器实例的属性信息,详细操作可以查看SQL Server2000的联机帮助 2.如何查看SQL Server2000是否打补丁,及补丁的版本有两种方法可以实现:一种是查看MS-SQL的关于信息;一种是利用MS-SQL的语句来实现(Select @@Version)或者(SELECT SERVERPROPERTY('ProductVersion')) Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 8.00.194 -——————SQL Server 2000 RTM(未安装补丁) 8.00.384 -——————(SP1) 8.00.534 -——————(SP2) 8.00.760 -——————(SP3) 8.00.2039 -——————(SP4) 另外通过Copyright (c) 1988-2000 Microsoft Corporation中的日期也可以看出SQL Server2000是否打补丁,但在这里体现不出补丁的版本方法一:打开企业管理器-SQL SERVRE 组-(local)window NT -属性产品:有personal的是个人版的,有Enterprise的是企业版的产品版本:8.00.2039(sp4);8.00.760(sp3)方法二:第一步:在查询分析器select @@versionprint @@versionMicrosoftSQLServer 2000 - 8.00.2039 (Intel X86)May 3 2005 23:18:38Copyright (c) 1988-2003 Microsoft CorporationPersonal Edition onWindowsNT 5.1 (Build 2600: Service Pack 2)方法三:C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe点击鼠标右键查看版本也能得到,不过信息比较简单而已。8.00.2039就代表安装的SQL Server的版本了。安装了SP4,对应号是8.00.2039安装了SP3,对应号是8.00.760
 

在SQL中怎查看版本号?

有两种方法:

第一步:使用SQL语句查询
方法一:
在ISQL中输入:
Select @@Version;
go

或者SQL查询分析器中输入(其实如果不想输入,只要打开帮助的关于就可以了:))
Select @@Version;
然后按执行;

也可以使用:"print @@version;"然后按执行;
返回SQL的版本信息如下:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

其实在C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
点击鼠标右键查看版本也能得到,不过信息比较简单而已。8.00.2039就代表安装的SQL Server的版本了。对应以下的表格,可以查出来具体对应的补丁版本。8.00.2039表示安装了SP4,8.00.760表示安装了SP3。

 

posted @ 2018-06-24 15:50  何鸿涛  阅读(5501)  评论(0编辑  收藏  举报