카테고리 없음2014. 5. 13. 11:12


INCREASING MAXIMUM NUMBER OF FILES ON A NETAPP FLEXVOL

Use the “maxfiles” command to both query and increase the number of inodes in a FlexVol:

toaster> maxfiles svault01
Volume svault01: maximum number of files is currently 31876689 (30927298 used).
toaster> maxfiles svault01 40000000

Note that an increased maxfiles value can never be decreased, and increases in maxfiles has capacity and other implications. In ONTAP’s words:

Increasing the maximum number of files consumes disk space, and the number can never be decreased. Configuring a large number of inodes can also result in less available memory after an upgrade, which means you might not be able to run WAFL_check.


inode 수를 증가시킨후 또한 WAFL_check을 실행하지 못할 수 있으며, 업그레이드 후 Low 메모리가 발생할 수 있습니다.


* inode 수 증가 고려사항

Considerations for changing the maximum number of files allowed on a FlexVol volume

FlexVol volumes have a maximum number of files that they can contain. You can change the maximum number of files for a volume, but before doing so you should understand how this change affects the volume.

The number of files a volume can contain is determined by how many inodes it has. An inode is a data structure that contains information about files. Volumes have both private and public inodes. Public inodes are used for files that are visible to the user; private inodes are used for files that are used internally by Data ONTAP. You can change only the maximum number of public inodes for a volume. You cannot affect the number of private inodes.

Data ONTAP automatically sets the maximum number of public inodes for a newly created volume based on the size of the volume: 1 inode per 32 KB of volume size. When the size of a volume is increased, either directly by an administrator or automatically by Data ONTAP through the autosize feature, Data ONTAP also increases (if necessary) the maximum number of public inodes so there is at least 1 inode per 32 KB of volume size, until the volume reaches approximately 1 TB in size. Growing the volume greater than 1 TB in size does not automatically result in more inodes, because Data ONTAP does not automatically create more than 33,554,409 inodes. If you need more files than the default number for any size volume, you can use the volume modify command to increase the maximum number of inodes for the volume.

You can also decrease the maximum number of public inodes. This does not change the amount of space currently allocated to inodes, but it does lower the maximum amount of space the public inode file can consume. However, after space has been allocated for inodes, it is never returned to the volume. Therefore, lowering the maximum number of inodes below the number of inodes currently allocated does not return the space used by the allocated but unused inodes to the volume.


Posted by 영혼도둑
카테고리 없음2013. 12. 4. 12:45



http://sqlserverbuilds.blogspot.kr/


Quick summary:

 RTM (Gold, no SP)SP1SP2SP3SP4
 SQL Server 2014
     codename Hekaton
     
 SQL Server 2012
     codename Denali
11.00.2100.6011.00.3000   
 SQL Server 2008 R2
     codename Kilimanjaro
10.50.1600.110.50.250010.50.4000  
 SQL Server 2008
     codename Katmai
10.00.1600.2210.00.253110.00.400010.00.5500 
 SQL Server 2005
     codename Yukon
9.00.1399.069.00.20479.00.30429.00.40359.00.5000
 SQL Server 2000
     codename Shiloh
8.00.1948.00.3848.00.5328.00.7608.00.2039
 SQL Server 7.0
     codename Sphinx
7.00.6237.00.6997.00.8427.00.9617.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.

Microsoft SQL Server 2014 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
12.00.15242014.120.1524.0Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)October 15, 2013*newDownloadable
11.00.91202013.110.9120.0Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1)June 25, 2013

Microsoft SQL Server 2012 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
11.00.90002011.110.9000.5Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3)November 27, 2012
11.00.33932011.110.3393.02894115 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1November 18, 2013Downloadable
11.00.33812011.110.3381.02874879 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 1September 16, 2013Downloadable
11.00.33732011.110.3373.02861107 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 1July 16, 2013Downloadable
11.00.33682011.110.3368.02833645 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 1May 31, 2013Downloadable
11.00.33502011.110.3350.02832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1April 17, 2013Downloadable
11.00.33492011.110.3349.02812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1March 18, 2013Downloadable
11.00.33392011.110.3339.02790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1January 25, 2013Downloadable
11.00.33352011.110.3335.02800050 FIX: Component installation process fails after you install SQL Server 2012 SP1January 14, 2013Downloadable
11.00.33212011.110.3321.02765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1November 20, 2012Downloadable
11.00.31282011.110.3128.02793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1January 3, 2013Downloadable
11.00.30002011.110.3000.0SQL Server 2012 Service Pack 1 (SP1)November 6, 2012Downloadable
11.00.28452011.110.2845.0SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4)September 20, 2012
11.00.28092011.110.2809.24SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3)July 5, 2012
11.00.24202011.110.2420.02891666 Cumulative update package 10 (CU10) for SQL Server 2012October 21, 2013*newDownloadable
11.00.24192011.110.2419.02867319 Cumulative update package 9 (CU9) for SQL Server 2012August 21, 2013Downloadable
11.00.24102011.110.2410.02844205 Cumulative update package 8 (CU8) for SQL Server 2012June 18, 2013Downloadable
11.00.24052011.110.2405.02823247 Cumulative update package 7 (CU7) for SQL Server 2012April 15, 2013Downloadable
11.00.24012011.110.2401.02728897 Cumulative update package 6 (CU6) for SQL Server 2012February 18, 2013Downloadable
11.00.23952011.110.2395.02777772 Cumulative update package 5 (CU5) for SQL Server 2012December 18, 2012Downloadable
11.00.23832011.110.2383.02758687 Cumulative update package 4 (CU4) for SQL Server 2012October 18, 2012Downloadable
11.00.23762011.110.2376.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
11.00.23322011.110.2332.02723749 Cumulative update package 3 (CU3) for SQL Server 2012August 29, 2012Downloadable
11.00.23252011.110.2325.02703275 Cumulative update package 2 (CU2) for SQL Server 2012June 18, 2012Downloadable
11.00.23162011.110.2316.02679368 Cumulative update package 1 (CU1) for SQL Server 2012April 12, 2012Downloadable
11.00.22182011.110.2218.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
11.00.22142011.110.2214.02685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business IntelligenceApril 6, 2012Downloadable
11.00.21002011.110.2100.60SQL Server 2012 RTMMarch 6, 2012Downloadable (MSDN/TechNet subscribers only)
11.00.19132011.110.1913.37Microsoft SQL Server 2012 Release Candidate 1 (RC1)December 16, 2011Downloadable
11.00.17502011.110.1750.32Microsoft SQL Server 2012 Release Candidate 0 (RC0)November 17, 2011Downloadable
11.00.14402010.110.1440.19Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 3 (CTP3)July 11, 2011Downloadable
11.00.11032010.110.1103.9Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 1 (CTP1)November 8, 2010

Microsoft SQL Server 2008 R2 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
10.50.42952009.100.4295.02887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2October 29, 2013Downloadable
10.50.42902009.100.4290.02871401 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 2August 30, 2013Downloadable
10.50.42862009.100.4286.02844090 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 2June 17, 2013Downloadable
10.50.42852009.100.4285.02830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (updated)June 13, 2013Downloadable
10.50.42792009.100.4279.02830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (replaced)April 15, 2013
10.50.42762009.100.4276.02797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2February 18, 2013Downloadable
10.50.42702009.100.4270.02777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2December 17, 2012Downloadable
10.50.42662009.100.4266.02754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2October 15, 2012Downloadable
10.50.42632009.100.4263.02740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2August 29, 2012Downloadable
10.50.42602009.100.4260.02720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2August 1, 2012Downloadable
10.50.40002009.100.4000.0SQL Server 2008 R2 Service Pack 2 (SP2)July 26, 2012Downloadable
10.50.37202009.100.3720.0SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP)May 13, 2012
10.50.28762009.100.2876.02855792 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 1June 17, 2013Downloadable
10.50.28752009.100.2875.02828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (updated)June 13, 2013Downloadable
10.50.28742009.100.2874.02828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (replaced)April 15, 2013Downloadable
10.50.28612009.100.2861.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.50.28692009.100.2869.02812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1February 18, 2013Downloadable
10.50.28682009.100.2868.02783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1December 17, 2012Downloadable
10.50.28662009.100.2866.02756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1November 6, 2012Downloadable
10.50.28612009.100.2861.02716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012October 9, 2012Downloadable
10.50.28222009.100.2822.02723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1August 29, 2012Downloadable
10.50.28172009.100.2817.02703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1June 18, 2012Downloadable
10.50.28112009.100.2811.02679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1April 16, 2012Downloadable
10.50.28072009.100.2807.02675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2March 12, 2012Downloadable
10.50.28062009.100.2806.02659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1February 22, 2012Downloadable
10.50.27992009.100.2799.02633357 FIX: "Non-yielding Scheduler" error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2February 22, 2012Downloadable
10.50.27962009.100.2796.02633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1December 20, 2011Downloadable
10.50.27892009.100.2789.02591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1October 17, 2011Downloadable
10.50.27762009.100.2776.02606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2October 18, 2011Downloadable
10.50.27722009.100.2772.02567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1August 15, 2011Downloadable
10.50.27692009.100.2769.02544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1July 18, 2011Downloadable
10.50.25502009.100.2550.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.50.25002009.100.2500.0SQL Server 2008 R2 Service Pack 1 (SP1)July 11, 2011Downloadable
10.50.18172009.100.1817.02703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2June 18, 2012Downloadable
10.50.18152009.100.1815.02679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2April 17, 2012Downloadable
10.50.18102009.100.1810.02659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2February 21, 2012Downloadable
10.50.18092009.100.1809.02633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2January 9, 2012Downloadable
10.50.18072009.100.1807.02591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2October 19, 2011Downloadable
10.50.18042009.100.1804.02567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2August 16, 2011Downloadable
10.50.18002009.100.1800.02574699 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 systemOctober 18, 2011Downloadable
10.50.17972009.100.1797.02534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2June 20, 2011Downloadable
10.50.17902009.100.1790.02494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011June 17, 2011Downloadable
10.50.17772009.100.1777.02507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2June 16, 2011Downloadable
10.50.17692009.100.1769.02520808 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 usedApril 18, 2011Downloadable
10.50.17652009.100.1765.02489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2February 21, 2011Downloadable
10.50.17532009.100.1753.02438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2December 23, 2010Downloadable
10.50.17462009.100.1746.02345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2October 18, 2010Downloadable
10.50.17342009.100.1734.02261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2August 20, 2010Downloadable
10.50.17202009.100.1720.02072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2June 25, 2010Downloadable
10.50.17022009.100.1702.0981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2May 18, 2010Downloadable
10.50.16172009.100.1617.02494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011June 14, 2011Downloadable
10.50.16002009.100.1600.1SQL Server 2008 R2 RTMApril 21, 2010Downloadable (MSDN/TechNet subscribers only)
10.50.13522009.100.1352.12Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP)November 12, 2009Downloadable
10.50.10922009.100.1092.20Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)June 30, 2009Downloadable

Microsoft SQL Server 2008 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
10.00.58482007.100.5848.02893410 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 3November 18, 2013Downloadable
10.00.58462007.100.5846.02880350 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 3September 16, 2013Downloadable
10.00.58442007.100.5844.02863205 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 3July 16, 2013Downloadable
10.00.58412007.100.5841.02834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (updated)June 13, 2013Downloadable
10.00.58402007.100.5840.02834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (replaced)May 20, 2013Downloadable
10.00.58352007.100.5835.02814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3March 18, 2013Downloadable
10.00.58292007.100.5829.02799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3January 23, 2013Downloadable
10.00.58282007.100.5828.02771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3November 19, 2012Downloadable
10.00.58262007.100.5826.02716435 Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.00.57942007.100.5794.02738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3September 21, 2012Downloadable
10.00.57882007.100.5788.02715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3July 16, 2012Downloadable
10.00.57852007.100.5785.02696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3May 19, 2012Downloadable
10.00.57752007.100.5775.02673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3March 20, 2012Downloadable
10.00.57702007.100.5770.02648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3January 16, 2012Downloadable
10.00.57682007.100.5768.02633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3November 22, 2011Downloadable
10.00.57662007.100.5766.02617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3October 18, 2011Downloadable
10.00.55122007.100.5512.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.00.55002007.100.5500.0SQL Server 2008 Service Pack 3 (SP3)October 6, 2011Downloadable
10.00.54162007.100.5416.0SQL Server 2008 Service Pack 3 CTPAugust 22, 2011
10.00.43712007.100.4371.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.00.43332007.100.4333.02715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2July 16, 2012Downloadable
10.00.43322007.100.4332.02696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2May 20, 2012Downloadable
10.00.43302007.100.4330.02673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2March 19, 2012Downloadable
10.00.43262007.100.4326.02648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2January 30, 2012Downloadable
10.00.43232007.100.4323.02617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2November 21, 2011Downloadable
10.00.43212007.100.4321.02582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2September 20, 2011Downloadable
10.00.43162007.100.4316.02555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2July 18, 2011Downloadable
10.00.42852007.100.4285.02527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2May 16, 2011Downloadable
10.00.42792007.100.4279.02498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2March 11, 2011Downloadable
10.00.42722007.100.4272.02467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2February 10, 2011Downloadable
10.00.42662007.100.4266.02289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2November 15, 2010Downloadable
10.00.40672007.100.4067.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
10.00.40642007.100.4064.02494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011June 14, 2011Downloadable
10.00.40002007.100.4000.0SQL Server 2008 Service Pack 2 (SP2)September 29, 2010Downloadable
10.00.37982007.100.3798.0SQL Server 2008 Service Pack 2 CTPJuly 7, 2010
10.00.28502007.100.2850.02582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1September 19, 2011Downloadable
10.00.28472007.100.2847.02555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1July 18, 2011Downloadable
10.00.28212007.100.2821.02527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1May 16, 2011Downloadable
10.00.28162007.100.2816.02497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1March 22, 2011Downloadable
10.00.28082007.100.2808.02467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1February 10, 2011Downloadable
10.00.28042007.100.2804.02413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1November 15, 2010Downloadable
10.00.27992007.100.2799.02279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1September 21, 2010Downloadable
10.00.27892007.100.2789.02083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1July 21, 2010Downloadable
10.00.27872007.100.2787.02231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8July 30, 2010Downloadable
10.00.27752007.100.2775.0981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1May 17, 2010Downloadable
10.00.27662007.100.2766.0979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1March 26, 2010Downloadable
10.00.27572007.100.2757.0977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1January 18, 2010Downloadable
10.00.27462007.100.2746.0975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1November 16, 2009Downloadable
10.00.27402007.100.2740.0976761 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, 2009Downloadable
10.00.27342007.100.2734.0973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1September 22, 2009Downloadable
10.00.27232007.100.2723.0971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1July 21, 2009Downloadable
10.00.27142007.100.2714.0970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1May 18, 2009Downloadable
10.00.27122007.100.2712.0970507 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.27102007.100.2710.0969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1April 16, 2009Downloadable
10.00.25732007.100.2573.02494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011June 14, 2011Downloadable
10.00.25312007.100.2531.0SQL Server 2008 Service Pack 1 (SP1)April 7, 2009Downloadable
10.00.25202007.100.2520.0SQL Server 2008 Service Pack 1 - CTPFebruary 23, 2009
10.00.18352007.100.1835.0979064 Cumulative update package 10 (CU10) for SQL Server 2008March 15, 2010Downloadable
10.00.18282007.100.1828.0977444 Cumulative update package 9 (CU9) for SQL Server 2008January 18, 2010Downloadable
10.00.18232007.100.1823.0975976 Cumulative update package 8 (CU8) for SQL Server 2008November 16, 2009Downloadable
10.00.18182007.100.1818.0973601 Cumulative update package 7 (CU7) for SQL Server 2008September 21, 2009Downloadable
10.00.18122007.100.1812.0971490 Cumulative update package 6 (CU6) for SQL Server 2008July 21, 2009Downloadable
10.00.18062007.100.1806.0969531 Cumulative update package 5 (CU5) for SQL Server 2008May 18, 2009Downloadable
10.00.17982007.100.1798.0963036 Cumulative update package 4 (CU4) for SQL Server 2008March 17, 2009Downloadable
10.00.17872007.100.1787.0960484 Cumulative update package 3 (CU3) for SQL Server 2008January 19, 2009Downloadable
10.00.17792007.100.1779.0958186 Cumulative update package 2 (CU2) for SQL Server 2008November 19, 2008Downloadable
10.00.17712007.100.1771.0958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008October 29, 2008Downloadable
10.00.17632007.100.1763.0956717 Cumulative update package 1 (CU1) for SQL Server 2008October 28, 2008Downloadable
10.00.17502007.100.1750.0956718 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 2008August 25, 2008Downloadable
10.00.16002007.100.1600.22SQL Server 2008 RTMAugust 7, 2008Downloadable (MSDN/TechNet subscribers only)
10.00.14422007.100.1442.32Microsoft SQL Server 2008 RC0June 5, 2008
10.00.13002007.100.1300.13Microsoft SQL Server 2008 CTP, February 2008February 19, 2008
10.00.10752007.100.1075.23Microsoft SQL Server 2008 CTP, November 2007November 18, 2007
10.00.10492007.100.1049.14SQL Server 2008 CTP, July 2007July 31, 2007
10.00.10192007.100.1019.17SQL Server 2008 CTP, June 2007May 21, 2007



Microsoft SQL Server 2005 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
9.00.53242005.90.5324.02716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFEOctober 9, 2012Downloadable
9.00.52962005.90.5296.02615425 FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updatedOctober 24, 2011Downloadable
9.00.52952005.90.5295.02598903 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 R2May 21, 2012Downloadable
9.00.52942005.90.5294.02572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005August 10, 2011Downloadable
9.00.52922005.90.5292.02494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011June 14, 2011Downloadable
9.00.52662005.90.5266.02507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4March 22, 2011Downloadable
9.00.52592005.90.5259.02489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4February 22, 2011Downloadable
9.00.52542005.90.5254.02464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4December 24, 2010Downloadable
9.00.50692005.90.5069.0Microsoft Security Bulletin MS12-070October 9, 2012Downloadable
9.00.50572005.90.5057.02494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011June 14, 2011Downloadable
9.00.50002005.90.5000.0SQL Server 2005 Service Pack 4 (SP4)December 17, 2010Downloadable
9.00.49122005.90.4912.0SQL Server 2005 Service Pack 4 (SP4) - Customer Technology Preview (CTP)November 3, 2010Downloadable
9.00.43422005.90.4342.02598903 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 R2May 21, 2012Downloadable
9.00.43402005.90.4340.02494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011June 14, 2011Downloadable
9.00.43252005.90.4325.02507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3March 22, 2011Downloadable
9.00.43172005.90.4317.02489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3February 21, 2011Downloadable
9.00.43152005.90.4315.02438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3December 23, 2010Downloadable
9.00.43112005.90.4311.02345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3October 18, 2010Downloadable
9.00.43092005.90.4309.02258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3August 16, 2010Downloadable
9.00.43052005.90.4305.0983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3June 23, 2010Downloadable
9.00.42942005.90.4294.0980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3April 19, 2010Downloadable
9.00.42852005.90.4285.0978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3February 16, 2010Downloadable
9.00.42732005.90.4273.0976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3December 21, 2009Downloadable
9.00.42682005.90.4268.0977151 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, 2009Downloadable
9.00.42662005.90.4266.0974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3October 19, 2009Downloadable
9.00.42622005.90.4262.0970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009October 13, 2009Downloadable
9.00.42302005.90.4230.0972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3August 17, 2009Downloadable
9.00.42262005.90.4226.0970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3June 16, 2009Downloadable
9.00.42242005.90.4224.0971409 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.42202005.90.4220.0967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3April 20, 2009Downloadable
9.00.42162005.90.4216.0967101 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 2005April 20, 2009Downloadable
9.00.42112005.90.4211.0961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3February 17, 2009Downloadable
9.00.42072005.90.4207.0959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3December 20, 2008Downloadable
9.00.40602005.90.4060.02494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011June 14, 2011Downloadable
9.00.40532005.90.4053.0970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009October 13, 2009Downloadable
9.00.40352005.90.4035.0SQL Server 2005 Service Pack 3 (SP3)December 15, 2008Downloadable
9.00.40282005.90.4028.0SQL Server 2005 Service Pack 3 (SP3) - CTPOctober 27, 2008
9.00.33562005.90.3356.0976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2December 21, 2009Downloadable
9.00.33552005.90.3355.0974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2October 19, 2009Downloadable
9.00.33532005.90.3353.0970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009October 13, 2009Downloadable
9.00.33302005.90.3330.0972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2August 18, 2009Downloadable
9.00.33282005.90.3328.0970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2June 16, 2009Downloadable
9.00.33252005.90.3325.0967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2April 20, 2009Downloadable
9.00.33202005.90.3320.0969142 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, 2009Downloadable
9.00.33182005.90.3318.0967199 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 providerApril 20, 2009Downloadable
9.00.33152005.90.3315.0962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2February 17, 2009Downloadable
9.00.33102005.90.3310.0960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009February 10, 2009Downloadable
9.00.33012005.90.3301.0958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2December 16, 2008Downloadable
9.00.32942005.90.3294.0956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2October 20, 2008Downloadable
9.00.32822005.90.3282.0953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2June 16, 2008Downloadable
9.00.32602005.90.3260.0954950 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.32592005.90.3259.0954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the sessionAugust 14, 2008
9.00.32592005.90.3259.0954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005July 14, 2008
9.00.32572005.90.3257.0951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2June 18, 2008Downloadable
9.00.32462005.90.3246.0952233 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 instanceMay 23, 2008
9.00.32442005.90.3244.0952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005June 3, 2008
9.00.32402005.90.3240.0951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005May 21, 2008
9.00.32392005.90.3239.0949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2April 17, 2008Downloadable
9.00.32322005.90.3232.0949959 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.32312005.90.3231.0949595 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.32312005.90.3231.0949687 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.32302005.90.3230.0949199 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.32282005.90.3228.0946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2February 19, 2008Downloadable
9.00.32242005.90.3224.0947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005February 4, 2008
9.00.32212005.90.3221.0942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005January 31, 2008
9.00.32212005.90.3221.0945443 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 queryJanuary 11, 2008
9.00.32212005.90.3221.0945916 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.32212005.90.3221.0945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005January 9, 2008
9.00.32152005.90.3215.0943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2December 18, 2007Downloadable
9.00.32082005.90.3208.0944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005November 21, 2007
9.00.32062005.90.3206.0944677 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 2005December 11, 2007
9.00.32002005.90.3200.0941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2October 17, 2007Downloadable
9.00.31942005.90.3194.0940933 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 2005September 24, 2007
9.00.31862005.90.3186.0940943 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 2005August 29, 2007
9.00.31862005.90.3186.0940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005August 24, 2007
9.00.31862005.90.3186.0940269 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.31862005.90.3186.0940945 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 2005August 22, 2007
9.00.31862005.90.3186.0940937 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.31862005.90.3186.0940379 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.31862005.90.3186.0940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005August 20, 2007
9.00.31862005.90.3186.0937100 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.31862005.90.3186.0940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005August 20, 2007
9.00.31862005.90.3186.0938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005August 17, 2007
9.00.31862005.90.3186.0940935 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.31862005.90.3186.0940221 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.31862005.90.3186.0940942 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.31862005.90.3186.0940384 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 installedAugust 13, 2007
9.00.31862005.90.3186.0940281 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 2005August 13, 2007
9.00.31862005.90.3186.0940545 FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005August 10, 2007
9.00.31862005.90.3186.0940210 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.31862005.90.3186.0939537 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 2August 23, 2007Downloadable
9.00.31822005.90.3182.0940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005August 3, 2007
9.00.31792005.90.3179.0938243 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.31782005.90.3178.0938086 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 2005August 22, 2007
9.00.31772005.90.3177.0939285 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.31772005.90.3177.0939562 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.31772005.90.3177.0939563 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.31752005.90.3175.0936534 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.31752005.90.3175.0938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005August 1, 2007
9.00.31752005.90.3175.0936488 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 SP2July 10, 2007
9.00.31752005.90.3175.0938825 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 replicationJune 29, 2007
9.00.31752005.90.3175.0936305 Cumulative update package 2 (CU2 build 3175) for SQL Server 2005 Service Pack 2 is availableJune 28, 2007Downloadable
9.00.31712005.90.3171.0937745 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 connectionsJuly 16, 2007
9.00.31692005.90.3169.0937033 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.31692005.90.3169.0937041 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 2005May 25, 2007
9.00.31662005.90.3166.0936185 FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is highJune 11, 2007
9.00.31662005.90.3166.0934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005July 16, 2007
9.00.31612005.90.3161.0935789 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 joinSeptember 24, 2007
9.00.31612005.90.3161.0934706 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.31612005.90.3161.0933724 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005May 9, 2007
9.00.31612005.90.3161.0935356 Cumulative update package (CU1 build 3161) for SQL Server 2005 Service Pack 2 is availableApril 16, 2007Downloadable
9.00.31592005.90.3159.0934459 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 3158April 3, 2007Downloadable
9.00.31562005.90.3156.0934226 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.31552005.90.3155.0933808 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.31552005.90.3155.0933499 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.31552005.90.3155.0933766 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.31552005.90.3155.0933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005April 25, 2007
9.00.31542005.90.3154.0934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005April 25, 2007
9.00.31542005.90.3154.0934109 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 2005April 25, 2007
9.00.31542005.90.3154.0934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution databaseApril 25, 2007
9.00.31532005.90.3153.0933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005April 16, 2007
9.00.31522005.90.3152.0933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is availableMarch 7, 2007Downloadable
9.00.30802005.90.3080.0970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009October 13, 2009Downloadable
9.00.30772005.90.3077.0960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009February 10, 2009Downloadable
9.00.30732005.90.3073.0954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008September 9, 2008Downloadable
9.00.30682005.90.3068.0941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilegeAugust 5, 2008Downloadable
9.00.30542005.90.3054.0934458 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 3053January 2, 2008Downloadable
9.00.30502005.90.3050.0933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intendedMarch 7, 2007Downloadable
9.00.30422005.90.3042.0SQL Server 2005 Service Pack 2 (SP2)February 19, 2007Downloadable
9.00.30332005.90.3033.0SQL Server 2005 Service Pack 2 (SP2) - CTP December 2006December 19, 2006
9.00.30272005.90.3027.0SQL Server 2005 Service Pack 2 (SP2) - CTP November 2006November 6, 2006
9.00.30262005.90.3026.0929376 FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy loadFebruary 14, 2007
9.00.22392005.90.2239.0940961 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 2005September 24, 2007
9.00.22372005.90.2237.0940719 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 2005September 24, 2007
9.00.22362005.90.2236.0940287 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.22362005.90.2236.0940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005July 26, 2007
9.00.22342005.90.2234.0937343 FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb databaseJune 20, 2007
9.00.22332005.90.2233.0937545 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.22332005.90.2233.0933499 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.22332005.90.2233.0937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 databaseJune 5, 2007
9.00.22322005.90.2232.0937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005June 19, 2007
9.00.22312005.90.2231.0934812 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 2005November 6, 2007
9.00.22302005.90.2230.0936179 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.22292005.90.2229.0935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulkJune 11, 2007
9.00.22272005.90.2227.0933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005June 26, 2007
9.00.22262005.90.2226.0934065 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.22262005.90.2226.0933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005June 22, 2007
9.00.22232005.90.2223.0932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1June 18, 2007
9.00.22212005.90.2221.0931593 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 buildsJuly 11, 2007
9.00.22192005.90.2219.0932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005April 25, 2007
9.00.22182005.90.2218.0931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stoppedApril 25, 2007
9.00.22162005.90.2216.0931821 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 installedMay 15, 2007
9.00.22142005.90.2214.0930505 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.22142005.90.2214.0929240 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 2005February 13, 2007
9.00.22112005.90.2211.0930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005February 20, 2007
9.00.22112005.90.2211.0930283 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 2005February 14, 2007
9.00.22092005.90.2209.0929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390February 7, 2007
9.00.22082005.90.2208.0929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005January 9, 2007
9.00.22072005.90.2207.0928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005December 19, 2006
9.00.22072005.90.2207.0928372 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.22072005.90.2207.0928789 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.22062005.90.2206.0928083 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 2005February 1, 2007
9.00.22062005.90.2206.0928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005January 12, 2007
9.00.22062005.90.2206.0926493 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.22062005.90.2206.0928539 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 2005December 13, 2006
9.00.22022005.90.2202.0927643 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 2005February 16, 2007
9.00.22012005.90.2201.0927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publicationJanuary 10, 2007
9.00.21982005.90.2198.0926613 FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005February 21, 2007
9.00.21982005.90.2198.0926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting ServicesFebruary 20, 2007
9.00.21982005.90.2198.0924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005February 2, 2007
9.00.21982005.90.2198.0924264 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 StudioDecember 13, 2006
9.00.21982005.90.2198.0926612 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 2005January 4, 2007
9.00.21982005.90.2198.0926773 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.21982005.90.2198.0926611 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 2005November 28, 2006
9.00.21982005.90.2198.0924808 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 2005December 13, 2006
9.00.21982005.90.2198.0925277 FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005January 2, 2007
9.00.21962005.90.2196.0926285 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.21962005.90.2196.0926335 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.21952005.90.2195.0926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data sourceDecember 19, 2006
9.00.21942005.90.2194.0925744 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.21922005.90.2192.0924954 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.21922005.90.2192.0925335 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.21912005.90.2191.0925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriberDecember 6, 2006
9.00.21902005.90.2190.0925227 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.21892005.90.2189.0925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005September 22, 2006
9.00.21872005.90.2187.0923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decreaseSeptember 22, 2006
9.00.21812005.90.2181.0923605 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 processorsFebruary 19, 2007
9.00.21812005.90.2181.0923624 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.21762005.90.2176.0922594 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.21762005.90.2176.0923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005September 6, 2006
9.00.21752005.90.2175.0921395 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 ServicesAugust 8, 2006
9.00.21752005.90.2175.0917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursorAugust 14, 2006
9.00.21752005.90.2175.0922578 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 logAugust 30, 2006
9.00.21752005.90.2175.0922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 databaseDecember 14, 2006
9.00.21752005.90.2175.0921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005December 18, 2006
9.00.21742005.90.2174.0922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1July 25, 2006
9.00.21672005.90.2167.0920974 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 80August 9, 2006
9.00.21642005.90.2164.0919243 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 2005February 8, 2007
9.00.21642005.90.2164.0920346 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 predicateSeptember 19, 2006
9.00.21642005.90.2164.0920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternativeSeptember 19, 2006
9.00.21642005.90.2164.0919929 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.21642005.90.2164.0921003 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 logAugust 29, 2006
9.00.21642005.90.2164.0920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterizationSeptember 26, 2006
9.00.21642005.90.2164.0918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large objectSeptember 6, 2006
9.00.21642005.90.2164.0919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005July 26, 2006
9.00.21642005.90.2164.0919775 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 2005August 9, 2006
9.00.21562005.90.2156.0919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1July 26, 2006
9.00.21532005.90.2153.0918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is availableSeptember 14, 2006Downloadable
9.00.21532005.90.2153.0919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005May 23, 2006Downloadable
9.00.20502005.90.2050.0932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047July 11, 2007
9.00.20472005.90.2047.0SQL Server 2005 Service Pack 1 (SP1)April 18, 2006Downloadable
9.00.20402005.90.2040.0SQL Server 2005 Service Pack 1 (SP1) CTP March 2006March 12, 2006
9.00.20292005.90.2029.0SLQ Server 2005 Service Pack 1 (SP1) Beta
9.00.15612005.90.1561.0932556 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 buildsJuly 11, 2007
9.00.15582005.90.1558.0926493 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.15542005.90.1554.0926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random orderJune 26, 2007
9.00.15512005.90.1551.0922527 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.15512005.90.1551.0922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server databaseNovember 22, 2006
9.00.15502005.90.1550.0917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005July 26, 2006
9.00.15502005.90.1550.0921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005November 22, 2006
9.00.15472005.90.1547.0918276 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 2005November 20, 2006
9.00.15452005.90.1545.0917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursorAugust 14, 2006
9.00.15412005.90.1541.0917888 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.15412005.90.1541.0917971 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 groupsNovember 22, 2006
9.00.15392005.90.1539.0917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statementAugust 11, 2006
9.00.15382005.90.1538.0917824 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 schemaJuly 26, 2006
9.00.15362005.90.1536.0917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005July 26, 2006
9.00.15342005.90.1534.0916706 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 2005May 15, 2007
9.00.15332005.90.1533.0916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005July 26, 2006
9.00.15322005.90.1532.0916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005January 9, 2007
9.00.15312005.90.1531.0915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005July 26, 2006
9.00.15282005.90.1528.0915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005January 15, 2007
9.00.15282005.90.1528.0915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005January 4, 2007
9.00.15282005.90.1528.0915307 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 2005January 11, 2007
9.00.15282005.90.1528.0915306 FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publicationJanuary 8, 2007
9.00.15282005.90.1528.0915112 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.15192005.90.1519.0913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005January 20, 2007
9.00.15182005.90.1518.0913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005September 22, 2006
9.00.15182005.90.1518.0912472 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 2005July 26, 2006
9.00.15182005.90.1518.0913371 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 2005July 26, 2006
9.00.15142005.90.1514.0912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005July 26, 2006
9.00.15032005.90.1503.0911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005July 26, 2006
9.00.15022005.90.1502.0915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005July 26, 2006
9.00.15002005.90.1500.0910416 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.14062005.90.1406.0932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399July 11, 2007Downloadable
9.00.13992005.90.1399.0SQL Server 2005 RTMNovember 7, 2005



Microsoft SQL Server 2000 Builds

BuildFile versionKB / DescriptionDate UpdatedAvailability
8.00.23052000.80.2305.0983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012August 14, 2012Downloadable
8.00.23012000.80.2301.0983809 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 QFE: April 10, 2012April 10, 2012Downloadable
8.00.22832000.80.2283.0971524 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-004June 15, 2009Downloadable
8.00.22822000.80.2282.0960083 MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009February 10, 2009
8.00.22792000.80.2279.0959678 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 failsApril 8, 2009Downloadable
8.00.22732000.80.2273.0948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000 July 8, 2008August 5, 2008
8.00.22712000.80.2271.0946584 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 databaseMarch 12, 2008
8.00.22652000.80.2265.0944985 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" publisherDecember 19, 2007
8.00.22532000.80.2253.0939317 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 processorsOctober 9, 2007
8.00.22492000.80.2249.0936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000May 25, 2007
8.00.22482000.80.2248.0935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000June 14, 2007
8.00.22462000.80.2246.0935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000June 18, 2007
8.00.22452000.80.2245.0933573 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 2000April 24, 2007
8.00.22442000.80.2244.0934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computerMay 10, 2007
8.00.22422000.80.2242.0929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the DistributorMarch 28, 2007
8.00.22382000.80.2238.0931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4February 21, 2007
8.00.22362000.80.2236.0930484 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 statementFebruary 2, 2007
8.00.22342000.80.2234.0929440 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.22322000.80.2232.0928568 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 fileJanuary 15, 2007
8.00.22312000.80.2231.0928079 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 2000June 19, 2007
8.00.22292000.80.2229.0927186 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.22262000.80.2226.0925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000November 20, 2006
8.00.22262000.80.2226.0925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000November 13, 2006
8.00.22232000.80.2223.0925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000July 20, 2007
8.00.22232000.80.2223.0925678 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.22182000.80.2218.0925297 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 2000June 19, 2007
8.00.22172000.80.2217.0924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000October 25, 2007
8.00.22152000.80.2215.0923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisherJanuary 12, 2007
8.00.22152000.80.2215.0924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000October 5, 2006
8.00.22152000.80.2215.0923563 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.22152000.80.2215.0923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000December 28, 2006
8.00.22092000.80.2209.0923797 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.22072000.80.2207.0923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runsAugust 28, 2006
8.00.22012000.80.2201.0920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000August 21, 2006
8.00.21992000.80.2199.0919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publicationJuly 26, 2006
8.00.21972000.80.2197.0919133 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 2000August 2, 2006
8.00.21972000.80.2197.0919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000August 8, 2006
8.00.21972000.80.2197.0919399 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.21962000.80.2196.0919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000August 14, 2006
8.00.21942000.80.2194.0917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops respondingFebruary 21, 2007
8.00.21942000.80.2194.0917972 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 2000September 22, 2006
8.00.21922000.80.2192.0917606 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 4August 4, 2006
8.00.21912000.80.2191.0916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'"July 26, 2006
8.00.21912000.80.2191.0916950 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 computerOctober 3, 2006
8.00.21892000.80.2189.0916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000July 26, 2006
8.00.21892000.80.2189.0913438 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 SP4July 19, 2006
8.00.21872000.80.2187.0915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000June 18, 2007
8.00.21872000.80.2187.0916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187October 16, 2006Downloadable
8.00.21872000.80.2187.0914384 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 2000July 26, 2006
8.00.21872000.80.2187.0915065 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.21802000.80.2180.0913789 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 2000February 19, 2007
8.00.21802000.80.2180.0913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processorJuly 26, 2006
8.00.21752000.80.2175.0911678 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 2000July 26, 2006
8.00.21722000.80.2172.0910707 FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000July 26, 2006
8.00.21712000.80.2171.0909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expectedJuly 26, 2006
8.00.21682000.80.2168.0907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1November 21, 2006
8.00.21662000.80.2166.0909734 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 4July 26, 2006
8.00.21622000.80.2162.0904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162September 15, 2006
8.00.21592000.80.2159.0907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000July 26, 2006
8.00.21562000.80.2156.0906790 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-bitJuly 25, 2006
8.00.21512000.80.2151.0903742 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 SP4July 25, 2006
8.00.21512000.80.2151.0904244 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 4June 13, 2007
8.00.21482000.80.2148.0899430 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 2000July 25, 2006
8.00.21482000.80.2148.0899431 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 4July 25, 2006
8.00.21482000.80.2148.0900390 FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documentsJune 1, 2006
8.00.21482000.80.2148.0900404 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 2000June 1, 2006
8.00.21482000.80.2148.0901212 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 SP4July 25, 2006
8.00.21482000.80.2148.0902150 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 computerJune 1, 2006
8.00.21482000.80.2148.0902955 FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4July 25, 2006
8.00.21472000.80.2147.0899410 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 processorsJune 1, 2006
8.00.21452000.80.2145.0826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowlyOctober 25, 2005
8.00.21452000.80.2145.0836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joinsJune 7, 2006
8.00.20662000.80.2066.0Microsoft Security Bulletin MS12-060August 14, 2012
8.00.20652000.80.2065.0983808 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 GDR: April 10, 2012April 10, 2012
8.00.20552000.80.2055.0959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code executionFebruary 10, 2009
8.00.20402000.80.2040.0899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4August 15, 2006
8.00.20392000.80.2039.0SQL Server 2000 Service Pack 4 (SP4)May 6, 2005Downloadable
8.00.20262000.80.2026.0SQL Server 2000 Service Pack 4 (SP4) Beta
8.00.15472000.80.1547.0899410 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 processorsJune 1, 2006
8.00.10772000.80.1077.0983814 MS12-070: Description of the security update for SQL Server 2000 Reporting Services Service Pack 2October 9, 2012
8.00.10372000.80.1037.0930484 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 statementFebruary 2, 2007
8.00.10362000.80.1036.0929410 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.10352000.80.1035.0917593 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 2000September 22, 2006
8.00.10342000.80.1034.0915328 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 2000August 9, 2006
8.00.10292000.80.1029.0902852 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.10272000.80.1027.0900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000July 25, 2006
8.00.10252000.80.1025.0899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3June 1, 2006
8.00.10252000.80.1025.0899430 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 2000July 25, 2006
8.00.10242000.80.1024.0898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"July 25, 2006
8.00.10212000.80.1021.0887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000July 25, 2006
8.00.10202000.80.1020.0896985 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 SP3July 25, 2006
8.00.10192000.80.1019.0897572 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 2000June 1, 2006
8.00.10172000.80.1017.0896425 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 2000June 1, 2006
8.00.10142000.80.1014.0895123 FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000June 1, 2006
8.00.10142000.80.1014.0895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000July 25, 2006
8.00.10132000.80.1013.0891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000June 1, 2006
8.00.10092000.80.1009.0894257 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 2000June 1, 2006
8.00.10072000.80.1007.0893312 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 2000June 1, 2006
8.00.10032000.80.1003.0892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000June 1, 2006
8.00.10012000.80.1001.0892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operationJune 1, 2006
8.00.10002000.80.1000.0891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000June 1, 2006
8.00.9972000.80.997.0891311 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 logJuly 18, 2006
8.00.9962000.80.996.0891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operationJune 1, 2006
8.00.9962000.80.996.0891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operationsJune 1, 2006
8.00.9942000.80.994.0890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3June 1, 2006
8.00.9942000.80.994.0890768 FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000June 1, 2006
8.00.9942000.80.994.0890767 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 2000June 1, 2006
8.00.9932000.80.993.0890925 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-bitJune 1, 2006
8.00.9932000.80.993.0888444 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 callJune 1, 2006
8.00.9932000.80.993.0890742 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.9912000.80.991.0889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnectedJune 1, 2006
8.00.9902000.80.990.0890200 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 logJune 1, 2006
8.00.9882000.80.988.0889166 FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000June 1, 2006
8.00.9852000.80.985.0889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000June 1, 2006
8.00.9802000.80.980.0887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3June 1, 2006
8.00.9772000.80.977.0888007 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 hotfixAugust 31, 2005
8.00.9732000.80.973.0884554 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 packetJune 1, 2006
8.00.9722000.80.972.0885290 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 ServerJune 1, 2006
8.00.9702000.80.970.0872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000June 1, 2006
8.00.9672000.80.967.0878501 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 2000June 1, 2006
8.00.9622000.80.962.0883415 FIX: A user-defined function returns results that are not correct for a queryJune 1, 2006
8.00.9612000.80.961.0873446 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 SMPJune 1, 2006
8.00.9592000.80.959.0878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statementJune 1, 2006
8.00.9572000.80.957.0870994 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 hintJune 1, 2006
8.00.9552000.80.955.0867798 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 2000January 8, 2007
8.00.9542000.80.954.0843282 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 sessionJanuary 5, 2007
8.00.9522000.80.952.0867878 FIX: The Log Reader Agent may cause 17883 error messagesJune 1, 2006
8.00.9522000.80.952.0867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribersJune 1, 2006
8.00.9522000.80.952.0867880 FIX: Merge Agent may fail with an "Invalid character value for cast specification" error messageJune 1, 2006
8.00.9492000.80.949.0843266 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.9482000.80.948.0843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL ServerJune 1, 2006
8.00.9442000.80.944.0839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2June 5, 2006
8.00.9372000.80.937.0841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failuresJune 1, 2006
8.00.9362000.80.936.0841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstancesJune 1, 2006
8.00.9352000.80.935.0841401 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 computerJune 1, 2006
8.00.9342000.80.934.0841404 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-joinsJune 1, 2006
8.00.9332000.80.933.0840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3June 2, 2006
8.00.9292000.80.929.0839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedlyJune 1, 2006
8.00.9282000.80.928.0839589 FIX: The thread priority is raised for some threads in a parallel queryJune 1, 2006
8.00.9272000.80.927.0839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 charactersJune 1, 2006
8.00.9262000.80.926.0839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000June 1, 2006
8.00.9232000.80.923.0838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or laterJune 1, 2006
8.00.9222000.80.922.0837970 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 2000October 25, 2005
8.00.9192000.80.919.0837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000October 25, 2005
8.00.9162000.80.916.0317989 FIX: Sqlakw32.dll May Corrupt SQL StatementsSeptember 27, 2005
8.00.9152000.80.915.0837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rowsOctober 25, 2005
8.00.9132000.80.913.0836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joinsJune 7, 2006
8.00.9112000.80.911.0837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000October 25, 2005
8.00.9102000.80.910.0834798 FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to startOctober 25, 2005
8.00.9082000.80.908.0834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTEDOctober 25, 2005
8.00.9042000.80.904.0834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publicationApril 22, 2005
8.00.8922000.80.892.0833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devicesOctober 25, 2005
8.00.8912000.80.891.0836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computerApril 1, 2005
8.00.8792000.80.879.0832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000October 25, 2005
8.00.8782000.80.878.0831950 FIX: You receive error message 3456 when you try to apply a transaction log to a serverOctober 25, 2005
8.00.8762000.80.876.0830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be TruncatedOctober 25, 2005
8.00.8762000.80.876.0831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000October 25, 2005
8.00.8762000.80.876.0831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000October 25, 2005
8.00.8732000.80.873.0830887 FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfixOctober 25, 2005
8.00.8712000.80.871.0830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a fileOctober 25, 2005
8.00.8712000.80.871.0830860 FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cacheOctober 25, 2005
8.00.8702000.80.870.0830262 FIX: Unconditional Update May Not Hold Key Locks on New Key ValuesOctober 25, 2005
8.00.8692000.80.869.0830588 FIX: Access violation when you trace keyset-driven cursors by using SQL ProfilerOctober 25, 2005
8.00.8662000.80.866.0830366 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-031January 16, 2006
8.00.8652000.80.865.0830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed columnOctober 25, 2005
8.00.8652000.80.865.0828945 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 2000October 25, 2005
8.00.8632000.80.863.0829205 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 compiledOctober 25, 2005
8.00.8632000.80.863.0829444 FIX: A floating point exception occurs during the optimization of a queryOctober 25, 2005
8.00.8592000.80.859.0821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859March 31, 2005
8.00.8582000.80.858.0828637 FIX: Users Can Control the Compensating Change Process in Merge ReplicationOctober 25, 2005
8.00.8572000.80.857.0828017 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.8572000.80.857.0827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation levelNovember 23, 2005
8.00.8572000.80.857.0828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise ManagerOctober 25, 2005
8.00.8562000.80.856.0828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter CriteriaOctober 25, 2005
8.00.8542000.80.854.0828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many ObjectsOctober 25, 2005
8.00.8522000.80.852.0830466 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 2000April 1, 2005
8.00.8522000.80.852.0827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential IntegrityOctober 25, 2005
8.00.8512000.80.851.0826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS CommandOctober 25, 2005
8.00.8502000.80.850.0826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset CursorOctober 25, 2005
8.00.8502000.80.850.0826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueriesOctober 25, 2005
8.00.8502000.80.850.0826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowlyOctober 25, 2005
8.00.8482000.80.848.0826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special UserOctober 25, 2005
8.00.8472000.80.847.0826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O ProblemsOctober 25, 2005
8.00.8452000.80.845.0826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server CollationOctober 5, 2005
8.00.8452000.80.845.0825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to TrueOctober 25, 2005
8.00.8442000.80.844.0826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clientsOctober 17, 2006
8.00.8422000.80.842.0825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server tableOctober 25, 2005
8.00.8412000.80.841.0825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clauseOctober 25, 2005
8.00.8402000.80.840.0319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.8402000.80.840.0319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.8392000.80.839.0823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR ClausesOctober 25, 2005
8.00.8392000.80.839.0824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecuteOctober 25, 2005
8.00.8372000.80.837.0820788 FIX: Delayed domain authentication may cause SQL Server to stop respondingOctober 25, 2005
8.00.8372000.80.837.0821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlockOctober 25, 2005
8.00.8372000.80.837.0821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3October 25, 2005
8.00.8372000.80.837.0821740 FIX: MS DTC Transaction Commit Operation Blocks ItselfOctober 25, 2005
8.00.8372000.80.837.0823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowlyOctober 25, 2005
8.00.8192000.80.819.0826161 FIX: You are prompted for password confirmation after you change a standard SQL Server loginOctober 25, 2005
8.00.8182000.80.818.0821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3January 9, 2006
8.00.8182000.80.818.0821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bitMarch 16, 2005
8.00.8182000.80.818.0818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator PermissionsFebruary 10, 2005
8.00.8182000.80.818.0826161 FIX: You are prompted for password confirmation after you change a standard SQL Server loginOctober 25, 2005
8.00.8182000.80.818.0821280 MS03-031: Security Patch for SQL Server 2000 64-bitMarch 14, 2006
8.00.8162000.80.816.0818766 FIX: Intense SQL Server activity results in spinloop waitOctober 25, 2005
8.00.8142000.80.814.0819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous SubscribersOctober 25, 2005
8.00.8112000.80.811.0819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000April 3, 2006
8.00.8112000.80.811.0819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous SubscribersOctober 25, 2005
8.00.8112000.80.811.0818897 FIX: Invalid TDS Sent to SQL Server Results in Access ViolationOctober 25, 2005
8.00.8072000.80.807.0818899 FIX: Error Message 3628 May Occur When You Run a Complex QueryOctober 25, 2005
8.00.8042000.80.804.0818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex QueryOctober 25, 2005
8.00.8012000.80.801.0818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS packageJanuary 26, 2006
8.00.8002000.80.800.0818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows ServiceSeptember 27, 2005
8.00.8002000.80.800.0818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical IndexesSeptember 27, 2005
8.00.8002000.80.800.0818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack OverflowSeptember 27, 2005
8.00.7982000.80.798.0817464 FIX: Using Sp_executesql in Merge Agent OperationsSeptember 27, 2005
8.00.7942000.80.794.0817464 FIX: Using Sp_executesql in Merge Agent OperationsSeptember 27, 2005
8.00.7942000.80.794.0813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a columnSeptember 27, 2005
8.00.7942000.80.794.0816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex QuerySeptember 27, 2005
8.00.7942000.80.794.0817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joinsFebruary 11, 2005
8.00.7912000.80.791.0815249 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 ServerSeptember 27, 2005
8.00.7902000.80.790.0817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server tableSeptember 27, 2005
8.00.7892000.80.789.0816840 FIX: Error 17883 May Display Message Text That Is Not CorrectSeptember 27, 2005
8.00.7882000.80.788.0816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000September 27, 2005
8.00.7812000.80.781.0815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All FilesSeptember 27, 2005
8.00.7802000.80.780.0816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN CollationSeptember 27, 2005
8.00.7802000.80.780.0816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX StatementSeptember 27, 2005
8.00.7802000.80.780.0810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3aOctober 10, 2006
8.00.7792000.80.779.0814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3September 27, 2005
8.00.7762000.80.776.0Unidentified
8.00.7752000.80.775.0815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERRORSeptember 27, 2005
8.00.7692000.80.769.0814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 errorSeptember 27, 2005
8.00.7692000.80.769.0814893 FIX: Error Message: "Insufficient key column information for updating" Occurs in SQL Server 2000 SP3September 27, 2005
8.00.7652000.80.765.0810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not DefinedSeptember 27, 2005
8.00.7652000.80.765.0810688 FIX: Merge Agent Can Resend Changes for Filtered PublicationsSeptember 27, 2005
8.00.7652000.80.765.0811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergenceSeptember 27, 2005
8.00.7652000.80.765.0813769 FIX: You May Experience Slow Performance When You Debug a SQL Server ServiceSeptember 27, 2005
8.00.7632000.80.763.0814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3September 27, 2005
8.00.7622000.80.762.0814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3September 27, 2005
8.00.7602000.80.760.0SQL Server 2000 Service Pack 3 (SP3 / SP3a)August 27, 2003Downloadable
8.00.7432000.80.743.0818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2October 18, 2005
8.00.7432000.80.743.0818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2October 25, 2005
8.00.7412000.80.741.0818096 FIX: Many Extent Lock Time-outs May Occur During Extent AllocationFebruary 10, 2005
8.00.7362000.80.736.0816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM objectSeptember 27, 2005
8.00.7352000.80.735.0814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 errorSeptember 27, 2005
8.00.7332000.80.733.0813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query PerformanceSeptember 27, 2005
8.00.7302000.80.730.0813769 FIX: You May Experience Slow Performance When You Debug a SQL Server ServiceSeptember 27, 2005
8.00.7282000.80.728.0814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention PeriodSeptember 27, 2005
8.00.7252000.80.725.0812995 FIX: A Query with an Aggregate Function May Fail with a 3628 ErrorSeptember 27, 2005
8.00.7252000.80.725.0813494 FIX: Distribution Agent Fails with "Violation of Primary Key Constraint" Error MessageSeptember 27, 2005
8.00.7232000.80.723.0812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile TimeSeptember 27, 2005
8.00.7212000.80.721.0812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1NamesSeptember 27, 2005
8.00.7212000.80.721.0812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock EscalationSeptember 27, 2005
8.00.7182000.80.718.0811703 FIX: Unexpected results from partial aggregations based on conversionsSeptember 27, 2005
8.00.7152000.80.715.0810688 FIX: Merge Agent Can Resend Changes for Filtered PublicationsSeptember 27, 2005
8.00.7152000.80.715.0811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergenceSeptember 27, 2005
8.00.7142000.80.714.0811478 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 fileOctober 18, 2005
8.00.7132000.80.713.0811205 FIX: An error message occurs when you perform a database or a file SHRINK operationSeptember 27, 2005
8.00.7102000.80.710.0811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK OperationSeptember 27, 2005
8.00.7052000.80.705.0810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistentSeptember 27, 2005
8.00.7032000.80.703.0810526 FIX: Cursors That Have a Long Lifetime May Cause Memory FragmentationSeptember 27, 2005
8.00.7022000.80.702.0328551 FIX: Concurrency enhancements for the tempdb databaseJuly 19, 2006
8.00.7012000.80.701.0810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 ErrorSeptember 27, 2005
8.00.7012000.80.701.0810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not DefinedSeptember 27, 2005
8.00.7002000.80.700.0810072 FIX: Merge Replication Reconciler Stack OverflowSeptember 27, 2005
8.00.6962000.80.696.0810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a ConnectionSeptember 27, 2005
8.00.6962000.80.696.0810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access ViolationsSeptember 27, 2005
8.00.6952000.80.695.0331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock EscalationSeptember 27, 2005
8.00.6952000.80.695.0331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already ExistsFebruary 10, 2005
8.00.6952000.80.695.0331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received OrderFebruary 10, 2005
8.00.6932000.80.693.0330212 FIX: Parallel logical operation returns results that are not consistentSeptember 27, 2005
8.00.6902000.80.690.0311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an AssertionOctober 12, 2005
8.00.6892000.80.689.0329499 FIX: Replication Removed from Database After Restore WITH RECOVERYOctober 11, 2005
8.00.6882000.80.688.0329487 FIX: Transaction Log Restore Fails with Message 3456October 11, 2005
8.00.6862000.80.686.0316333 SQL Server 2000 Security Update for Service Pack 2November 24, 2006
8.00.6822000.80.682.0319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTEDOctober 18, 2005
8.00.6792000.80.679.0316333 SQL Server 2000 Security Update for Service Pack 2November 24, 2006
8.00.6782000.80.678.0328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004September 27, 2005
8.00.6672000.80.667.02000 SP2+8/14 fix
8.00.6652000.80.665.02000 SP2+8/8 fix
8.00.6612000.80.661.0326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occurSeptember 27, 2005
8.00.6552000.80.655.02000 SP2+7/24 fix
8.00.6522000.80.652.0810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access ViolationsSeptember 27, 2005
8.00.6502000.80.650.0322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked BuffersNovember 5, 2003
8.00.6442000.80.644.0324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and SubqueriesSeptember 27, 2005
8.00.6362000.80.636.0Microsoft Security Bulletin MS02-039June 24, 2002
8.00.6082000.80.608.0319507 FIX: SQL Extended Procedure Functions Contain Unchecked BuffersJune 21, 2004
8.00.6042000.80.604.02000 SP2+3/29 fix
8.00.5992000.80.599.0319869 FIX: Improved SQL Manager Robustness for Odd Length BufferSeptember 27, 2005
8.00.5942000.80.594.0319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map ErrorsSeptember 27, 2005
8.00.5842000.80.584.0318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joinsFebruary 4, 2008
8.00.5782000.80.578.0317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data SourceSeptember 27, 2005
8.00.5782000.80.578.0318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AVSeptember 27, 2005
8.00.5682000.80.568.0317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network LibraryOctober 30, 2002
8.00.5612000.80.561.02000 SP2+1/29 fix
8.00.5582000.80.558.0314003 FIX: Query That Uses DESC Index May Result in Access ViolationSeptember 26, 2005
8.00.5582000.80.558.0315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OASeptember 27, 2005
8.00.5522000.80.552.0313002 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.5522000.80.552.0313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to TerminateSeptember 26, 2005
8.00.5342000.80.534.02000 SP2.01
8.00.5322000.80.532.0SQL Server 2000 Service Pack 2 (SP2)February 4, 2003Downloadable
8.00.4752000.80.475.02000 SP1+1/29 fix
8.00.4742000.80.474.0315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OASeptember 27, 2005
8.00.4732000.80.473.0314003 FIX: Query That Uses DESC Index May Result in Access ViolationSeptember 26, 2005
8.00.4712000.80.471.0313302 FIX: Shared Table Lock Is Not Released After Lock EscalationSeptember 26, 2005
8.00.4692000.80.469.0313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to TerminateSeptember 26, 2005
8.00.4522000.80.452.0308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop RespondingSeptember 26, 2005
8.00.4442000.80.444.0307540 FIX: SQLPutData May Result in Leak of Buffer Pool MemorySeptember 26, 2005
8.00.4442000.80.444.0307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop RespondingOctober 7, 2005
8.00.4432000.80.443.0307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000September 26, 2005
8.00.4282000.80.428.0304850 FIX: SQL Server Text Formatting Functions Contain Unchecked BuffersAugust 5, 2004
8.00.3842000.80.384.0SQL Server 2000 Service Pack 1 (SP1)June 11, 2001Downloadable
8.00.2962000.80.296.0299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally HaveAugust 9, 2004
8.00.2872000.80.287.0297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCHOctober 7, 2005
8.00.2512000.80.251.0300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort OrderOctober 17, 2003
8.00.2502000.80.250.0291683 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.2492000.80.249.0288122 FIX: Lock Monitor Uses Excessive CPUSeptember 12, 2003
8.00.2392000.80.239.0285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access ViolationOctober 9, 2003
8.00.2332000.80.233.0282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long TimeOctober 9, 2003
8.00.2312000.80.231.0282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut DownOctober 9, 2003
8.00.2262000.80.226.0278239 FIX: Extreme Memory Usage When Adding Many Security RolesNovember 21, 2006
8.00.2252000.80.225.0281663 "Access Denied" Error Message When You Try to Use a Network Drive to Modify Windows 2000 PermissionsOctober 30, 2006
8.00.2232000.80.223.0280380 FIX: Buffer Overflow Exploit Possible with Extended Stored ProceduresJune 29, 2004
8.00.2222000.80.222.0281769 FIX: Exception Access Violation Encountered During Query NormalizationOctober 7, 2005
8.00.2182000.80.218.0279183 FIX: Scripting Object with Several Extended Properties May Cause ExceptionOctober 9, 2003
8.00.2172000.80.217.0279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server ShutdownOctober 9, 2003
8.00.2112000.80.211.0276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution PlanNovember 5, 2003
8.00.2102000.80.210.0275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run SlowlyOctober 9, 2003
8.00.2052000.80.205.0274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025October 7, 2005
8.00.2042000.80.204.0274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-JoinsOctober 9, 2003
8.00.1942000.80.194.0SQL Server 2000 RTM (no SP)
8.00.1902000.80.190.0SQL Server 2000 Gold
8.00.1002000.80.100.0SQL Server 2000 Beta 2
8.00.0782000.80.078.0SQL Server 2000 EAP5
8.00.0472000.80.047.0SQL Server 2000 EAP4



Microsoft SQL Server 7.0 Builds

BuildKB / DescriptionDate UpdatedAvailability
7.00.1152948113 MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008May 9, 2012Downloadable
7.00.1149867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0June 1, 2006
7.00.1143830233 New Connection Events Are Not Recorded in SQL Server TracesOctober 25, 2005
7.00.1143829015 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 unexpectedlyOctober 25, 2005
7.00.1097822756 A Complex UPDATE Statement That Uses an Index Spool Operation May Cause an AssertionOctober 25, 2005
7.00.1094821279 MS03-031: Security patch for SQL Server 7.0 Service Pack 4May 11, 2006Downloadable
7.00.1094815495 MS03-031: Cumulative security patch for SQL ServerMay 10, 2006Downloadable
7.00.1092820788 FIX: Delayed domain authentication may cause SQL Server to stop respondingOctober 25, 2005
7.00.1087814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort OperationSeptember 27, 2005
7.00.1079329499 FIX: Replication Removed from Database After Restore WITH RECOVERYOctober 11, 2005
7.00.1078327068 INF: SQL Server 7.0 Security Update for Service Pack 4September 27, 2005Downloadable
7.00.1077316333 SQL Server 2000 Security Update for Service Pack 2November 24, 2006
7.00.1063SQL Server 7.0 Service Pack 4 (SP4)Downloadable
7.00.1033324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactionsOctober 12, 2005
7.00.1026319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTEDOctober 18, 2005
7.00.1004304851 FIX: SQL Server Text Formatting Functions Contain Unchecked BuffersAugust 5, 2004
7.00.996299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally HaveAugust 9, 2004
7.00.978285870 FIX: Update With Self Join May Update Incorrect Number Of RowsOctober 28, 2003
7.00.977284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3April 25, 2002
7.00.970283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is DisabledOctober 15, 2002
7.00.970282243 FIX: Incorrect Results with Join of Column Converted to BinaryOctober 29, 2003
7.00.961SQL Server 7.0 Service Pack 3 (SP3)Downloadable
7.00.921283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is DisabledOctober 15, 2002
7.00.919282243 FIX: Incorrect Results with Join of Column Converted to BinaryOctober 29, 2003
7.00.918280380 FIX: Buffer Overflow Exploit Possible with Extended Stored ProceduresJune 29, 2004
7.00.917279180 FIX: Bcp.exe with Long Query String Can Result in Assertion FailureSeptember 26, 2005
7.00.910275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221October 31, 2003
7.00.905274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624July 15, 2004
7.00.889243741 FIX: Replication Initialize Method Causes Handle Leak on FailureOctober 5, 2005
7.00.879281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349March 14, 2006
7.00.857260346 FIX: Transactional Publications with a Filter on Numeric Columns Fail to Replicate DataMarch 14, 2006
7.00.843266766 FIX: Temporary Stored Procedures in SA Owned Databases May Bypass Permission Checks When You Run Stored ProceduresMarch 14, 2006
7.00.842SQL Server 7.0 Service Pack 2 (SP2)
7.00.839SQL Server 7.0 Service Pack 2 (SP2) Unidentified
7.00.835SQL Server 7.0 Service Pack 2 (SP2) Beta
7.00.776258087 FIX: Non-Admin User That Executes Batch While Server Shuts Down May Encounter Retail AssertionMarch 14, 2006
7.00.770252905 FIX: Slow Compile Time on Complex Joins with Unfiltered TableMarch 14, 2006
7.00.745253738 FIX: SQL Server Components that Access the Registry in a Cluster Environment May Cause a Memory LeakOctober 7, 2005
7.00.722239458 FIX: Replication: Problems Mapping Characters to DB2 OLEDB SubscribersOctober 5, 2005
7.00.699SQL Server 7.0 Service Pack 1 (SP1)
7.00.689SQL Server 7.0 Service Pack 1 (SP1) Beta
7.00.677SQL Server 7.0 MSDE from Office 2000 disc
7.00.662232707 FIX: Query with Complex View Hierarchy May Be Slow to CompileOctober 5, 2005
7.00.658244763 FIX: Access Violation Under High Cursor StressMarch 14, 2006
7.00.657229875 FIX: Unable to Perform Automated Installation of SQL 7.0 Using File ImagesOctober 5, 2005
7.00.643220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special CharactersOctober 5, 2005
7.00.623SQL Server 7.0 RTM (Gold, no SP)
7.00.5837.0 RC1
7.00.5177.0 Beta 3

 

Posted by 영혼도둑
카테고리 없음2013. 11. 11. 16:14



http://www.slashroot.in/how-do-linux-nfs-performance-tuning-and-optimization


1. rsize, wsize 변경

2. MTU 사이즈 조절

3. timeo, retrans 값 조절

3. NFDS 개수 조절

   /etc/sysconfig/nfs   <-- centos

   /etc/init.d/nfs-kernel-server   <-- ubuntu

  RPCNFSDCOUNT = 8 (default 8)


    # echo 65536 > /proc/sys/net/core/rmem_default
     # echo 65536 > /proc/sys/net/core/rmem_max
     /etc/sysctrl.conf
    net.core.rmem_max=219136
    net.core.wmem_max=219136

5. NIC autonegotiation OFF

6. sync VS async 
  -> async 시 데이타 corrupt 발생 가능성 있음
 *  참고 
 


Posted by 영혼도둑
카테고리 없음2013. 2. 15. 18:02



한글파일명으로 저장된 파일을 찾을 이슈가 있었다..



# find .  -not -exec ./ascii-only.sh {} \; -print


./xxxx/_유료.flv

./xxxx/_1_무료.flv

./xxxx/_2_무료.flv


# cat ./ascii-only.sh 


#!/usr/local/bin/gosh

 ;; - * - mode : scheme; coding : utf-8 - * -

;;

;; nihongo.scm -

;;

;; Copyright (C) 2009 by mzp

;; Author : MIZUNO Hiroki / mzpppp at gmail dot com

;; http://howdyworld.org

;;

;; Timestamp : 2009/02/19 21:53:57

;;

;; This program is free software; you can redistribute it and / or

;; modify it under MIT Lincence.

;;

(use srfi-1)

(use srfi-14)

(define (ascii-only? xs)

  (every

   (cut char-set-contains?

        char-set:ascii

        <>)

  (string->list xs)))


(define (main args)

  (if (every ascii-only? (cdr args))

      (exit 0)

      (exit 1)))


* gosh 설치

http://practical-scheme.net/gauche/download.html






Posted by 영혼도둑
Study/Linux2012. 9. 19. 17:48



sendmail 로 메일 보낼때


CNAME 으로 위임된 도메인으로 보낼경우

CNAME으로 위임된 도메인으로 메일이 날아감


방지하기 위해서

sendmail.cf에서 아래를 True로 수정


define(`confDONT_EXPAND_CNAMES'.`True')


버전에 따라서는


DontExpandCnames=True


Posted by 영혼도둑
Study/Mssql2012. 6. 27. 08:49

[제목]

Index 생성 관련 lock 관련 Guide 요청

[요약]

--문제

Index 생성 관련 lock 관련 Guide 요청

[진행 사항]

Step 1 ) A(Source) Table 에서 B Table Data 복사 (SELECT INTO or INSERT SELECT )

Step 2 ) B TablePK를 포함한 Index 생성

Step 3 ) A Table에 대해서 아래 Query를 이용해서 Access 여부 확인

Step 4 ) Step 3에서 A Table Access가 없는 경우 A TableA_Org Rename

Step 5 ) B Table A Table으로 Rename

SELECT * FROM

(

SELECT R.session_id, SUBSTRING(S.text, (R.statement_start_offset/2)+1,

((CASE R.statement_end_offset

WHEN -1 THEN DATALENGTH(S.text)

ELSE R.statement_end_offset

END - R.statement_start_offset)/2) + 1)

AS SQL

FROM sys.dm_exec_requests AS R

cross apply sys.dm_exec_sql_text(r.sql_handle) AS S

WHERE R.session_id > 50 AND R.session_id <> @@SPID

) AS S

WHERE S.SQL like '%table_name%'


Posted by 영혼도둑
Study/JavaScript2008. 10. 29. 16:38


function makeRGB(){
    colors = new Array(14)
        colors[0]="0"
        colors[1]="1"
        colors[2]="2"
        colors[3]="3"
        colors[4]="4"
        colors[5]="5"
        colors[5]="6"
        colors[6]="7"
        colors[7]="8"
        colors[8]="9"
        colors[9]="a"
        colors[10]="b"
        colors[11]="c"
        colors[12]="d"
        colors[13]="e"
        colors[14]="f"

        digit = new Array(5)
        color=""
        for (i=0;i<6;i++){
            digit[i]=colors[Math.round(Math.random()*14)]
            color = color+digit[i]
        }
        return color
}
Posted by 영혼도둑
Personal2008. 10. 14. 11:35

역시 용석님.. ^-----^

원래는 애플의 web app 가이드 따라서 만드는 것 같고요. 저희가 좋아하는 코드 까보기 편법으로는...
https://addons.mozilla.org/en-US/firefox/addon/59

이거 설치하시고요

Tools -> User Agent Switcher -> Options -> Options

에서 새 에이전트 추가하기를

이름은 iPhone
에이전트는

Mozilla/5.0 (iPhone; U; CPU like Mac OS X; en) AppleWebKit/420.1 (KHTML, like Gecko) Version/3.0 Mobile/3B48b Safari/419.3

로하고 나머지 비우고  생성해서 에이전트 변경 후 웹페이지로 보면보이네요




목소리 좋습니다~~~
Posted by 영혼도둑
Study/Mssql2008. 9. 26. 11:16

sp_configure

sp_configure 'show advanced options',1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
sp_configure 'show advanced options',0
RECONFIGURE
GO


Posted by 영혼도둑
Study/Mssql2008. 9. 26. 07:19
http://laigo.tistory.com/62

오늘 hotfix 적용하면서 발생한 문제 해결법
Posted by 영혼도둑