SQL Server Q&A

Symptoms
This article contains a list of the Microsoft SQL Server 2000 hotfixes. You can use this list to determine which hotfixes are included in a specific hotfix build. Unless otherwise specified, all the hotfixes in earlier builds are included in later builds. The list includes all the public hotfixes that have been released since the release of Microsoft SQL Server 2000 Service Pack 4 (SP4).
Important notes: Before you apply any hotfix in this list, you must have SQL Server 2000 SP4 installed. To determine which version of SQL Server you have, see the following article in the Microsoft Knowledge Base:
321185?(http://support.microsoft.com/kb/321185/) How to identify your SQL Server version and editionTo obtain SQL Server 2000 SP4, visit the following Microsoft Download Center Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5(http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5)For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591?(http://support.microsoft.com/kb/119591/) How to obtain Microsoft support files from online servicesMicrosoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.Hotfixes that are not part of a security release or a public roll-up package can only be obtained by contacting Microsoft Product Support Services.
For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support(http://support.microsoft.com/contactus/?ws=support)Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.This list does not contain the hotfixes for Microsoft Data Access Components (MDAC) or for Microsoft SQL Server 2000 Analysis Services.This article also describes a list of the SQL Server 2000 SP3-based hotfixes that are not included in SQL Server 2000 SP4. The reason is that the ship date of these hotfixes is later than the ship date of SQL Server 2000 SP4. These hotfixes are first included in this build.
Resolution
The following list includes all public SQL Server 2000 hotfixes that have been released since the release of SQL Server 2000 SP4.
SQL Server 2000 build 8.00.2040
899761?(http://support.microsoft.com/kb/899761/) FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 Service Pack 4SQL Server 2000 build 8.00.2040 includes the same hotfix that SQL Server 2000 build 8.00.2141 includes. SQL Server 2000 build 8.00.2040 isa general distribution release (GDR) update. The hotfix that is included inSQL Server 2000 build 8.00.2040 is the first hotfix that was released after SQL Server 2000 SP4.
For more information about a GDR, click the following article number to view the article in the Microsoft Knowledge Base:
935897?(http://support.microsoft.com/kb/935897/) An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
SQL Server 2000 build 8.00.2145
836651?(http://support.microsoft.com/kb/836651/) FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins
898626?(http://support.microsoft.com/kb/898626/) FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000
899430?(http://support.microsoft.com/kb/899430/) FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000
899431?(http://support.microsoft.com/kb/899431/) FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4
900390?(http://support.microsoft.com/kb/900390/) FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents
900404?(http://support.microsoft.com/kb/900404/) FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000
900470?(http://support.microsoft.com/kb/900470/) FIX: You may receive an error message when you perform transactional replication in SQL Server 2000
900629?(http://support.microsoft.com/kb/900629/) FIX: You receive a “Failed to open a table” error message when you try to open a trace table by using SQL Profiler after you upgrade to SQL Server 2000 Service Pack 4
901200?(http://support.microsoft.com/kb/901200/) FIX: You may receive a “Server: Msg 7358, Level 16, State 1, Line 1” error message after you run a linked server query in SQL Server 2000 Service Pack 4
901212?(http://support.microsoft.com/kb/901212/) FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 Service Pack 4
902955?(http://support.microsoft.com/kb/902955/) FIX: You receive a “Getting registry information” message when you run the Sqldiag.exe utility after you install SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2146
909100?(http://support.microsoft.com/kb/909100/) FIX: The performance of the statement that raises an error differs from the performance of the statement that does not raise an error when you trace exception events in SQL Server 2000 on an IA-64 computer
SQL Server 2000 build 8.00.2148
895123?(http://support.microsoft.com/kb/895123/) FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000
899410?(http://support.microsoft.com/kb/899410/) FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors
902150?(http://support.microsoft.com/kb/902150/) FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer
903086?(http://support.microsoft.com/kb/903086/) FIX: The batch job stops running, and job output is truncated when you run a Transact-SQL script as a SQL Server Agent job in SQL Server 2000
SQL Server 2000 build 8.00.2151
903742?(http://support.microsoft.com/kb/903742/) FIX: You receive an “Error: 8526, Severity: 16, State: 2” error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 Service Pack 4
905417?(http://support.microsoft.com/kb/905417/) FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: “SQL Server 2000 DTS Designer components are required to edit DTS packages”
904244?(http://support.microsoft.com/kb/904244/) FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2156
906790?(http://support.microsoft.com/kb/906790/) FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit
906890?(http://support.microsoft.com/kb/906890/) FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000
909379?(http://support.microsoft.com/kb/909379/) FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000
909380?(http://support.microsoft.com/kb/909380/) FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000
SQL Server 2000 build 8.00.2159
887700?(http://support.microsoft.com/kb/887700/) FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017?(http://support.microsoft.com/kb/891017/) FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201?(http://support.microsoft.com/kb/891201/) FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268?(http://support.microsoft.com/kb/891268/) FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891585?(http://support.microsoft.com/kb/891585/) FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
892205?(http://support.microsoft.com/kb/892205/) FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892392?(http://support.microsoft.com/kb/892392/) FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column
892551?(http://support.microsoft.com/kb/892551/) FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000
892840?(http://support.microsoft.com/kb/892840/) FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
892923?(http://support.microsoft.com/kb/892923/) FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935?(http://support.microsoft.com/kb/892935/) FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940?(http://support.microsoft.com/kb/892940/) FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators
893172?(http://support.microsoft.com/kb/893172/) FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000
894257?(http://support.microsoft.com/kb/894257/) FIX: You receive an “Incorrect syntax near ‘)’” error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000
896985?(http://support.microsoft.com/kb/896985/) FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 Service Pack 3
897572?(http://support.microsoft.com/kb/897572/) FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000
897578?(http://support.microsoft.com/kb/897578/) FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager
900625?(http://support.microsoft.com/kb/900625/) FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
907250?(http://support.microsoft.com/kb/907250/) FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000
892310?(http://support.microsoft.com/kb/892310/) FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000
SQL Server 2000 build 8.00.2162
887700?(http://support.microsoft.com/kb/887700/) FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017?(http://support.microsoft.com/kb/891017/) FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201?(http://support.microsoft.com/kb/891201/) FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268?(http://support.microsoft.com/kb/891268/) FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891585?(http://support.microsoft.com/kb/891585/) FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
891866?(http://support.microsoft.com/kb/891866/) FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000
892205?(http://support.microsoft.com/kb/892205/) FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892310?(http://support.microsoft.com/kb/892310/) FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000
892392?(http://support.microsoft.com/kb/892392/) FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column
892551?(http://support.microsoft.com/kb/892551/) FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000
892840?(http://support.microsoft.com/kb/892840/) FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
892923?(http://support.microsoft.com/kb/892923/) FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935?(http://support.microsoft.com/kb/892935/) FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940?(http://support.microsoft.com/kb/892940/) FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators
892985?(http://support.microsoft.com/kb/892985/) FIX: You may experience unexpected delays in query execution and unexpected time-out situations, and you may receive error message 17883 when you use the BULK INSERT command in SQL Server 2000
893172?(http://support.microsoft.com/kb/893172/) FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000
894254?(http://support.microsoft.com/kb/894254/) FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000
894257?(http://support.microsoft.com/kb/894257/) FIX: You receive an “Incorrect syntax near ‘)’” error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000
895187?(http://support.microsoft.com/kb/895187/) FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000
896425?(http://support.microsoft.com/kb/896425/) FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000
896980?(http://support.microsoft.com/kb/896980/) FIX: The query plan may take longer than expected to compile, and you may receive error message 701, error message 8623, or error message 8651 in SQL Server 2000
896985?(http://support.microsoft.com/kb/896985/) FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 Service Pack 3
897572?(http://support.microsoft.com/kb/897572/) FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000
897578?(http://support.microsoft.com/kb/897578/) FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager
898115?(http://support.microsoft.com/kb/898115/) FIX: The subquery in a CASE function is evaluated even if the condition in the WHEN expression is false in SQL Server 2000
898709?(http://support.microsoft.com/kb/898709/) FIX: Error message when you use SQL Server 2000: “Time out occurred while waiting for buffer latch type 3″
900335?(http://support.microsoft.com/kb/900335/) FIX: The SQL Server 2000 automatic database recovery operation may not succeed if an index contains a FLOAT data type or a REAL data type, and this data type contains a NaN value
900416?(http://support.microsoft.com/kb/900416/) FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000
900625?(http://support.microsoft.com/kb/900625/) FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
902851?(http://support.microsoft.com/kb/902851/) FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation
902852?(http://support.microsoft.com/kb/902852/) FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: “Internal SQL Server error”
905765?(http://support.microsoft.com/kb/905765/) FIX: A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000
SQL Server 2000 build 8.00.2164
909089?(http://support.microsoft.com/kb/909089/) FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000
SQL Server 2000 build 8.00.2166
909734?(http://support.microsoft.com/kb/909734/) FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2171
908156?(http://support.microsoft.com/kb/908156/) FIX: You receive an error message when MS DTC for SQL Server 2000 reuses a server process identifier (SPID) to enlist in a distributed transaction
909369?(http://support.microsoft.com/kb/909369/) FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected
910392?(http://support.microsoft.com/kb/910392/) FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000
910895?(http://support.microsoft.com/kb/910895/) FIX: You may receive an error message when you set the database collation to Thai_CI_AS and you try to run a Transact-SQL update query in SQL Server 2000
SQL Server 2000 build 8.00.2172
910707?(http://support.microsoft.com/kb/910707/) FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000
910710?(http://support.microsoft.com/kb/910710/) FIX: You receive an error message when a Visual Basic application opens a dynamic cursor on a GROUP BY query in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2175
911569?(http://support.microsoft.com/kb/911569/) FIX: You may receive an access violation error message when you run a linked server query that includes a subquery
911677?(http://support.microsoft.com/kb/911677/) FIX: A query may run more slowly against SQL Server 2000 post-Service Pack 3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-Service Pack 3 hotfix builds that are earlier than build 8.00.0988
911678?(http://support.microsoft.com/kb/911678/) FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000
SQL Server 2000 build 8.00.2177
912468?(http://support.microsoft.com/kb/912468/) FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services
913049?(http://support.microsoft.com/kb/913049/) FIX: The result set contains data for the whole relational source when you execute a query to retrieve a drillthrough result set in SQL Server 2000 Analysis Services
SQL Server 2000 build 8.00.2180
913684?(http://support.microsoft.com/kb/913684/) FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor
913789?(http://support.microsoft.com/kb/913789/) FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000
SQL Server 2000 build 8.00.2181
914085?(http://support.microsoft.com/kb/914085/) FIX: You may receive an error message when you try to use a Japanese user name or a Korean user name to connect to an Analysis Services server
SQL Server 2000 build 8.00.2184
913991?(http://support.microsoft.com/kb/913991/) FIX: Hotfix files may not be copied to remote nodes when you install a 32-bit hotfix, and hotfix files may not be removed from remote nodes on a computer that is running SQL Server 2000 in an MSCS environment
914298?(http://support.microsoft.com/kb/914298/) FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data
914384?(http://support.microsoft.com/kb/914384/) FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000
SQL Server 2000 build 8.00.2185
914439?(http://support.microsoft.com/kb/914439/) FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000
915340?(http://support.microsoft.com/kb/915340/) FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000
SQL Server 2000 build 8.00.2187
914298?(http://support.microsoft.com/kb/914298/) FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data
SQL Server 2000 build 8.00.2189
913438?(http://support.microsoft.com/kb/913438/) FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 Service Pack 4
915436?(http://support.microsoft.com/kb/915436/) FIX: Error message when you run a complex insert query or a stored procedure in SQL Server 2000: “Internal SQL Server error”
916652?(http://support.microsoft.com/kb/916652/) FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000
916653?(http://support.microsoft.com/kb/916653/) FIX: An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000
SQL Server 2000 build 8.00.2190
916097?(http://support.microsoft.com/kb/916097/) FIX: You may not be able to use Analysis Manager to change server properties for an instance of SQL Server 2000 Analysis Services that is running on an IA-64 server computer after you install Windows Server 2003 S916097 on a client computer
SQL Server 2000 build 8.00.2191
916698?(http://support.microsoft.com/kb/916698/) FIX: Error message when you run SQL Server 2000: “Failed assertion = ‘lockFound == TRUE’”
916950?(http://support.microsoft.com/kb/916950/) FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer
SQL Server 2000 build 8.00.2192
917593?(http://support.microsoft.com/kb/917593/) FIX: The “Audit Logout” event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000
917606?(http://support.microsoft.com/kb/917606/) FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2194
893312?(http://support.microsoft.com/kb/893312/) FIX: You may receive a “SQL Server could not spawn process_loginread thread” error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000
917565?(http://support.microsoft.com/kb/917565/) FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding
917972?(http://support.microsoft.com/kb/917972/) FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000
SQL Server 2000 build 8.00.2196
919165?(http://support.microsoft.com/kb/919165/) FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000
SQL Server 2000 build 8.00.2197
919068?(http://support.microsoft.com/kb/919068/) FIX: The query may return incorrect results, and the execution plan for the query may contain a “Table Spool” operator in SQL Server 2000
919133?(http://support.microsoft.com/kb/919133/) FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000
919399?(http://support.microsoft.com/kb/919399/) FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: “Failed to read trace data”
SQL Server 2000 build 8.00.2199
919221?(http://support.microsoft.com/kb/919221/) FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication
SQL Server 2000 build 8.00.2200
920121?(http://support.microsoft.com/kb/920121/) FIX: Error message when you add a calculated member to a cube in SQL Server 2000 Analysis Services Service Pack 4: “Unable to update the calculated member”
SQL Server 2000 build 8.00.2201
920930?(http://support.microsoft.com/kb/920930/) FIX: Error message when you try to run a query on a linked server in SQL Server 2000
SQL Server 2000 build 8.00.2203
922040?(http://support.microsoft.com/kb/922040/) FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node
SQL Server 2000 build 8.00.2204
921929?(http://support.microsoft.com/kb/921929/) BUG: When you click “Build Query” in the “Execute SQL Task Properties” dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes
SQL Server 2000 build 8.00.2207
923344?(http://support.microsoft.com/kb/923344/) FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs
SQL Server 2000 build 8.00.2209
923327?(http://support.microsoft.com/kb/923327/) FIX: You may receive an access violation error message when you import data by using the “Bulk Insert” command in SQL Server 2000
923563?(http://support.microsoft.com/kb/923563/) FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: “Implicit conversion from datatype ‘text’ to ‘nvarchar’ is not allowed”
923796?(http://support.microsoft.com/kb/923796/) FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher
SQL Server 2000 build 8.00.2215
924662?(http://support.microsoft.com/kb/924662/) FIX: The query performance may be slow when you query data from a view in SQL Server 2000
SQL Server 2000 build 8.00.2216
925000?(http://support.microsoft.com/kb/925000/) FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube
SQL Server 2000 build 8.00.2217
924664?(http://support.microsoft.com/kb/924664/) FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000
SQL Server 2000 build 8.00.2218
925297?(http://support.microsoft.com/kb/925297/) FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000
SQL Server 2000 build 8.00.2220
925745?(http://support.microsoft.com/kb/925745/) FIX: The members of a role that uses dynamic security cannot access the SQL Server 2000 Analysis Services database when you run a query against a cube
SQL Server 2000 build 8.00.2223
925678?(http://support.microsoft.com/kb/925678/) FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: “The process could not enumerate changes at the ‘Subscriber’”
925419?(http://support.microsoft.com/kb/925419/) FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000
SQL Server 2000 build 8.00.2226
925684?(http://support.microsoft.com/kb/925684/) FIX: You may experience one or more symptoms when you run a “CREATE INDEX” statement on an instance of SQL Server 2000
925732?(http://support.microsoft.com/kb/925732/) FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000
SQL Server 2000 build 8.00.2229
927186?(http://support.microsoft.com/kb/927186/) FIX: Error message when you create a merge replication for tables that have computed columns in SQL Server 2000 Service Pack 4: “The process could not log conflict information”
SQL Server 2000 build 8.00.2231
928079?(http://support.microsoft.com/kb/928079/) FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000
SQL Server 2000 build 8.00.2232
928568?(http://support.microsoft.com/kb/928568/) FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file
SQL Server 2000 build 8.00.2234
929131?(http://support.microsoft.com/kb/929131/) FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor
929440?(http://support.microsoft.com/kb/929440/) FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: “644″ or “2511″
SQL Server 2000 build 8.00.2238
929410?(http://support.microsoft.com/kb/929410/) FIX: Error message when you run a full-text query in SQL Server 2000: “Error: 17883, Severity: 1, State: 0″
931932?(http://support.microsoft.com/kb/931932/) FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2239
930484?(http://support.microsoft.com/kb/930484/) FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement
SQL Server 2000 build 8.00.2241
932697?(http://support.microsoft.com/kb/932697/) FIX: A calculated member that uses the DistinctCount function always returns 0 when you query a virtual cube that contains the calculated member after you install SQL Server 2000 Analysis Services Service Pack 4
SQL Server 2000 build 8.00.2244
934203?(http://support.microsoft.com/kb/934203/) FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer
SQL Server 2000 build 8.00.2245
933573?(http://support.microsoft.com/kb/933573/) FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the “Bulk Insert” Transact-SQL command to import data in SQL Server 2000
SQL Server 2000 build 8.00.2246
935465?(http://support.microsoft.com/kb/935465/) An updated version of Sqlvdi.dll is now available for SQL Server 2000
SQL Server 2000 build 8.00.2248
935950?(http://support.microsoft.com/kb/935950/) FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000
SQL Server 2000 build 8.00.2249
936232?(http://support.microsoft.com/kb/936232/) FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000

Symptoms
This article contains information about the bugs that are fixed by Microsoft SQL Server 2000 Service Pack 4 (SP4).
NotesService packs are cumulative. Each new service pack contains all the fixes that are in earlier service packs, together with any new fixes. You do not have to install an earlier service pack before you install the latest one.This list contains previously released hotfixes. Other fixes may be included in the service pack that are not documented.For more information about how to obtain the SQL Server 2000 service packs, click the following article number to view the article in the Microsoft Knowledge Base:
290211?(http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack
Resolution
For more information about the bugs that have been fixed in SQL Server 2000 Service Pack 4, click the following article numbers to view the articles in the Microsoft Knowledge Base:
314128?(http://support.microsoft.com/kb/314128/) FIX: Access violation occurs when an RPC call is made that includes a bit parameter value that is not valid
317989?(http://support.microsoft.com/kb/317989/) FIX: Sqlakw32.dll may corrupt SQL statements
319477?(http://support.microsoft.com/kb/319477/) FIX: Extremely large number of user tables on AWE system may cause BPool::Map errors
328551?(http://support.microsoft.com/kb/328551/) FIX: Concurrency enhancements for the tempdb database
331885?(http://support.microsoft.com/kb/331885/) FIX: Update/Delete statement fails with Error: 1203 during page lock escalation
331965?(http://support.microsoft.com/kb/331965/) FIX: The xp_readmail extended stored procedure overwrites attachment that already exists
331968?(http://support.microsoft.com/kb/331968/) FIX: The xp_readmail and xp_findnextmsg extended stored procedures do not read mail in time received order
332004?(http://support.microsoft.com/kb/332004/) FIX: SQL Server scalability may be limited if AWE is enabled
891719?(http://support.microsoft.com/kb/891719/) FIX: You receive a 17803 error message when you run a SORT or CREATE INDEX operation on a computer that has several GB of physical RAM from SQL Server 2000
810026?(http://support.microsoft.com/kb/810026/) FIX: A DELETE statement with a self-join may fail and you receive a 625 error
810052?(http://support.microsoft.com/kb/810052/) FIX: A memory leak occurs when cursors are opened during a connection
810072?(http://support.microsoft.com/kb/810072/) FIX: Merge replication reconciler stack overflow
810140?(http://support.microsoft.com/kb/810140/) FIX: A cursor DECLARE statement with a binary large object (text/ntext/image) parameter may cause an access violation
810163?(http://support.microsoft.com/kb/810163/) FIX: An access violation occurs if an sp_cursoropen call references a parameter that is not defined
810526?(http://support.microsoft.com/kb/810526/) FIX: Cursors that have a long lifetime may cause memory fragmentation
810688?(http://support.microsoft.com/kb/810688/) FIX: Merge Agent can resend changes for filtered publications
810920?(http://support.microsoft.com/kb/810920/) FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistent
811052?(http://support.microsoft.com/kb/811052/) FIX: Latch time-out message 845 occurs when you perform a database or file SHRINK operation
811188?(http://support.microsoft.com/kb/811188/) FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database by using a custom conflict resolver
811205?(http://support.microsoft.com/kb/811205/) FIX: An error message occurs when you perform a database or a file SHRINK operation
811467?(http://support.microsoft.com/kb/811467/) FIX: A Unicode LIKE predicate with binary collation may return incorrect results
811476?(http://support.microsoft.com/kb/811476/) BUG: Rollback fails with errors 3314 and 9001 if you enlist multiple connections in the same transaction
811611?(http://support.microsoft.com/kb/811611/) FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence
811703?(http://support.microsoft.com/kb/811703/) FIX: Unexpected results from partial aggregations based on conversions
812250?(http://support.microsoft.com/kb/812250/) FIX: Indexed view may cause a handled access violation in CIndex::SetLevel1Names
812393?(http://support.microsoft.com/kb/812393/) FIX: UPDATE or DELETE statement fails with error 1203 during row lock escalation
812798?(http://support.microsoft.com/kb/812798/) FIX: A UNION ALL view may not use index if partitions are removed at compile time
812995?(http://support.microsoft.com/kb/812995/) FIX: A query with an aggregate function may fail with a 3628 error
813146?(http://support.microsoft.com/kb/813146/) FIX: A scan of each partition table may be performed when you run an UPDATE statement on the partitioning column of a partitioned view
813412?(http://support.microsoft.com/kb/813412/) FIX: xp_readmail returns NULL in the attachment column if the attachment’s type is Message Format
813494?(http://support.microsoft.com/kb/813494/) FIX: Distribution Agent fails with “violation of primary key constraint” error message
813524?(http://support.microsoft.com/kb/813524/) FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column
813759?(http://support.microsoft.com/kb/813759/) FIX: A large number of NULL values in join columns result in slow query performance
813769?(http://support.microsoft.com/kb/813769/) FIX: You may experience slow performance when you debug a SQL Server service
813779?(http://support.microsoft.com/kb/813779/) FIX: A DML operation on a large table can cause performance problems
814032?(http://support.microsoft.com/kb/814032/) FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3
814035?(http://support.microsoft.com/kb/814035/) FIX: A full-text population fails after you apply SQL Server 2000 Service Pack 3
814113?(http://support.microsoft.com/kb/814113/) FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3
814460?(http://support.microsoft.com/kb/814460/) FIX: Merge replication with alternate synchronization partners may not succeed after you change the retention period
814509?(http://support.microsoft.com/kb/814509/) FIX: A parallel query with a COUNT aggregate function may return unexpected results
814654?(http://support.microsoft.com/kb/814654/EN-US/) FIX: Error 1203 may be logged in the error log when you disconnect from an instance of SQL Server 2000 after you submit queries or transactions
814665?(http://support.microsoft.com/kb/814665/) FIX: SQL Server assertion: “nret == FALSE” occurs when you insert or update table data in SQL Server 2000
814889?(http://support.microsoft.com/kb/814889/EN-US/) FIX: A DELETE statement with a JOIN might fail and you receive a 625 error
814893?(http://support.microsoft.com/kb/814893/) FIX: Error message: “Insufficient key column information for updating” occurs in SQL Server 2000 SP3
814894?(http://support.microsoft.com/kb/814894/) FIX: The xp_readmail stored procedure only saves the text of an embedded attachment
814916?(http://support.microsoft.com/kb/814916/EN-US/) FIX: Merge Agent for a filtered publication might fail
814919?(http://support.microsoft.com/kb/814919/) FIX: No message appears when a blank password is set for a system administrator login in SQL Server Enterprise Manager
814950?(http://support.microsoft.com/kb/814950/EN-US/) FIX: A computer might transmit nonencrypted data when clients use the Multiprotocol Net-Library with the encryption option enabled
814997?(http://support.microsoft.com/kb/814997/EN-US/) FIX: The header information may not be included when the query parameter has a COMPUTE clause
815056?(http://support.microsoft.com/kb/815056/EN-US/) FIX: The checkpoint process can delay SQL Server database activity and does not yield Scheduler correctly causing Error: 17883 to occur
815057?(http://support.microsoft.com/kb/815057/) FIX: SQL Server 2000 Uninstall option does not remove all files
815114?(http://support.microsoft.com/kb/815114/) FIX: Excessive Optimizer memory consumption may occur for queries that have multiple OUTER JOINS
815115?(http://support.microsoft.com/kb/815115/) FIX: A DTS package that uses global variables ignores error message raised by RAISERROR
815199?(http://support.microsoft.com/kb/815199/) FIX: Profiler does not report CPU column value for RPC:Completed events correctly
815249?(http://support.microsoft.com/kb/815249/EN-US/) FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server
815476?(http://support.microsoft.com/kb/815476/EN-US/) FIX: The spacing may not be correct when you run xp_sendmail and the query parameter contains a COMPUTE clause
815592?(http://support.microsoft.com/kb/815592/) FIX: Incorrect remoting of a predicate as a Sub-SELECT function after SQL Server 2000 Service Pack 3 upgrade
815593?(http://support.microsoft.com/kb/815593/) FIX: Incorrect cardinality estimates for NOT EXISTS predicates after you upgrade to SQL Server 2000 Service Pack 3
816039?(http://support.microsoft.com/kb/816039/) FIX: Code point comparison semantics for SQL_Latin1_General_Cp850_BIN collation
816069?(http://support.microsoft.com/kb/816069/) FIX: A query with a large IN clause can cause concurrency issues
816084?(http://support.microsoft.com/kb/816084/) FIX: sysindexes.statblob column may be corrupted after you run a DBCC DBREINDEX statement
816440?(http://support.microsoft.com/kb/816440/) FIX: Error 8623 is raised when SQL Server compiles a complex query
816503?(http://support.microsoft.com/kb/816503/) FIX: Floating point exception (Error 3628) might occur for queries that need merged histograms
816780?(http://support.microsoft.com/kb/816780/EN-US/) FIX: Merge Agent failures with articles that have indexed views defined
816834?(http://support.microsoft.com/kb/816834/) FIX: Osql.exe may not run batches as fast as other ODBC-based applications
816840?(http://support.microsoft.com/kb/816840/) FIX: Error 17883 may display message text that is not correct
816883?(http://support.microsoft.com/kb/816883/) FIX: SQL Server optimizer may underestimate the cardinality of range queries
816937?(http://support.microsoft.com/kb/816937/EN-US/) FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object
816985?(http://support.microsoft.com/kb/816985/EN-US/) FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000
817081?(http://support.microsoft.com/kb/817081/EN-US/) FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table
817186?(http://support.microsoft.com/kb/817186/EN-US/) FIX: A query that performs join operations between multiple tables may return incorrect results
817262?(http://support.microsoft.com/kb/817262/) FIX: Complex query may not create an execution plan
817263?(http://support.microsoft.com/kb/817263/) FIX: A SELECT statement against a view might not return qualifying rows
817359?(http://support.microsoft.com/kb/817359/) FIX: An access violation may occur when you run an INSERT statement in an nText column
817368?(http://support.microsoft.com/kb/817368/) FIX: An INSERT or UPDATE that results in a page split might fail with Error 818
817464?(http://support.microsoft.com/kb/817464/) FIX: Using Sp_executesql in Merge Agent operations
817709?(http://support.microsoft.com/kb/817709/EN-US/) FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins
817780?(http://support.microsoft.com/kb/817780/EN-US/) FIX: A complex query is not successful on a server that has more than 2 GB of memory
818079?(http://support.microsoft.com/kb/818079/) FIX: SQL Profiler displays incorrect TextData value when you run a nested stored procedure by using a Remote Procedure Call
818095?(http://support.microsoft.com/kb/818095/) FIX: Cursor plans are not removed from the cache when virtual memory depleted
818096?(http://support.microsoft.com/kb/818096/) FIX: Many extent lock time-outs may occur during extent allocation
818097?(http://support.microsoft.com/kb/818097/) FIX: An access violation may occur when you run DBCC DBREINDEX on a table that has hypothetical indexes
818188?(http://support.microsoft.com/kb/818188/) FIX: Query on the sysmembers virtual table may fail with a stack overflow
818335?(http://support.microsoft.com/kb/818335/EN-US/) FIX: A query may run slowly if the query contains a multi-table join and one of the joins is a view
818388?(http://support.microsoft.com/kb/818388/) FIX: A Transact-SQL statement that is embedded in the database name runs with system administrator permissions
818414?(http://support.microsoft.com/kb/818414/) FIX: The Sqldumper.exe file does not generate a userdump file when it runs against a Windows service
818540?(http://support.microsoft.com/kb/818540/EN-US/) FIX: SQL Server Enterprise Manager quits unexpectedly when you modify a DTS package
818729?(http://support.microsoft.com/kb/818729/) FIX: Internal query processor Error 8623 when Microsoft SQL Server tries to compile a plan for a complex query
818766?(http://support.microsoft.com/kb/818766/EN-US/) FIX: Intense SQL Server activity results in spinloop wait
818767?(http://support.microsoft.com/kb/818767/) FIX: Improved CPU usage for database logging when transaction log stalls occur
818768?(http://support.microsoft.com/kb/818768/) FIX: Cannot set SQL Server instance specific network affinity
818769?(http://support.microsoft.com/kb/818769/) FIX: Trace flag -T8002 treats an affinity mask like a process affinity
818772?(http://support.microsoft.com/kb/818772/) FIX: Cannot set the network affinity for an instance of SQL Server 2000 Service Pack 3
818806?(http://support.microsoft.com/kb/818806/EN-US/) FIX: Some Named Pipes features are not disabled after you disable the Named Pipes protocol
818897?(http://support.microsoft.com/kb/818897/) FIX: Invalid TDS sent to SQL Server results in access violation
818899?(http://support.microsoft.com/kb/818899/) FIX: Error message 3628 may occur when you run a complex query
819100?(http://support.microsoft.com/kb/819100/) MDAC Cliconfg.* files are not upgraded after you install SQL Server 2000 SP3a
819248?(http://support.microsoft.com/kb/819248/EN-US/) FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000
819662?(http://support.microsoft.com/kb/819662/) FIX: Distribution Cleanup Agent incorrectly cleans up entries for anonymous Subscribers
819829?(http://support.microsoft.com/kb/819829/EN-US/) FIX: When you run a program or a Web browser script that uses the Command object in the ADO programming interface to run a SQL Server stored procedure, you may receive an “EXECUTE permission denied on object…” error message in SQL Server 2000
819955?(http://support.microsoft.com/kb/819955/) FIX: Using xp_sendmail with a COMPUTE clause causes an access violation
820727?(http://support.microsoft.com/kb/820727/EN-US/) FIX: A long-running cursor fetch may lead to an assertion failure when you try to access a SQL Server 2000 database from an application
820835?(http://support.microsoft.com/kb/820835/) FIX: SQL Server might take a long time to recover after an abrupt or unexpected server shutdown
820837?(http://support.microsoft.com/kb/820837/) FIX: Allocation caching mechanisms enable faster allocation of pages to objects
821280?(http://support.microsoft.com/kb/821280/) MS03-031: Security patch for SQL Server 2000 64-bit
821334?(http://support.microsoft.com/kb/821334/EN-US/) FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859
821337?(http://support.microsoft.com/kb/821337/) FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit
821535?(http://support.microsoft.com/kb/821535/) FIX: Merge replication fails with Error 207 while generating a snapshot
821537?(http://support.microsoft.com/kb/821537/EN-US/) FIX: A deadlock condition may occur when you perform an UPDATE operation or a DELETE operation against a remote OLE DB provider in SQL Server 2000
821548?(http://support.microsoft.com/kb/821548/) FIX: A parallel query may generate an access violation after you install SQL Server 2000 SP3
821688?(http://support.microsoft.com/kb/821688/EN-US/) FIX: A query filter condition that has a LEFT OUTER JOIN clause may cause an incorrect row count estimate in the query execution plan
821740?(http://support.microsoft.com/kb/821740/) FIX: MS DTC transaction commit operation blocks itself
821741?(http://support.microsoft.com/kb/821741/EN-US/) FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock
821806?(http://support.microsoft.com/kb/821806/) FIX: SQL Server may generate an incorrect SQL script for a table constraint when you use the “Generate SQL Script” option in Enterprise Manager
822033?(http://support.microsoft.com/kb/822033/) FIX: A parameterized UNION query inside a stored procedure returns incorrect results
822641?(http://support.microsoft.com/kb/822641/EN-US/) Additional diagnostics added to diagnose long-running or canceled database autogrow operations in SQL Server
822668?(http://support.microsoft.com/kb/822668/EN-US/) FIX: “Connection is busy with results for another command” error message occurs when you run a linked server query
822746?(http://support.microsoft.com/kb/822746/) FIX: Incorrect results from a parallel query that uses a UNION and variables or parameters
822747?(http://support.microsoft.com/kb/822747/) FIX: Error 644 or 8646 may occur during a DELETE or UPDATE against a table that contains a Unicode column with a Latin1_General_BIN collation
822757?(http://support.microsoft.com/kb/822757/) FIX: An Insert Select command with OPENXML and a SQL_VARIANT type can cause Error 2537 to occur
823429?(http://support.microsoft.com/kb/823429/EN-US/) FIX: You receive error message 7410 when you use a distributed query as a query parameter for the xp_sendmail stored procedure or the sp_makewebtask stored procedure in SQL Server 2000
823455?(http://support.microsoft.com/kb/823455/EN-US/) FIX: Visual Basic raises a syntax error when you try to compile a file that was created when you saved a DTS package
823514?(http://support.microsoft.com/kb/823514/EN-US/) FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly
823877?(http://support.microsoft.com/kb/823877/) FIX: An access violation may occur when you run a query that contains 32,000 or more OR clauses
824018?(http://support.microsoft.com/kb/824018/) FIX: Parallel query that uses an indexed bit column may return results that are not correct
824027?(http://support.microsoft.com/kb/824027/) FIX: A cursor with a large object parameter may cause an access violation on CStmtCond::XretExecute
824028?(http://support.microsoft.com/kb/824028/) FIX: An OUTER or SEMI JOIN query that results in hash role reversal followed by a spill may return incorrect results
824227?(http://support.microsoft.com/kb/824227/EN-US/) FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation
824430?(http://support.microsoft.com/kb/824430/EN-US/) FIX: Performance decreases over time when you back up files in SQL Server 2000
825019?(http://support.microsoft.com/kb/825019/EN-US/) FIX: A linked server query fails with the error message “Statement(s) could not be prepared” in SQL Server 2000
825025?(http://support.microsoft.com/kb/825025/) FIX: You cannot synchronize between a replication publisher and a replication republisher
825042?(http://support.microsoft.com/kb/825042/) FIX: SQL Server jobs that are owned by non-sysadmin users may not start
825043?(http://support.microsoft.com/kb/825043/EN-US/) FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table
825045?(http://support.microsoft.com/kb/825045/) FIX: The Merge Agent takes a long time to download new data when it runs on a new anonymous subscription
825197?(http://support.microsoft.com/kb/825197/EN-US/) FIX: You receive error 3624 and the user database is marked suspect after you perform a bulk insert operation in SQL Server 2000
825225?(http://support.microsoft.com/kb/825225/EN-US/) FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause
825854?(http://support.microsoft.com/kb/825854/) FIX: No exclusive locks may be taken if the DisAllowsPageLocks value is set to true
825883?(http://support.microsoft.com/kb/825883/) FIX: The TextData column of the SP:StmtStarting event and the SP:StmtCompleted event displays the dynamic Transact-SQL statement even when the stored procedure is encrypted
825884?(http://support.microsoft.com/kb/825884/EN-US/) FIX: The dynamic query statement appears in the query execution plan of an encrypted stored procedure
826080?(http://support.microsoft.com/kb/826080/EN-US/) FIX: SQL Server 2000 protocol encryption applies to JDBC clients
826161?(http://support.microsoft.com/kb/826161/EN-US/) FIX: You are prompted for password confirmation after you change a standard SQL Server login
826364?(http://support.microsoft.com/kb/826364/) FIX: A query with a LIKE comparison results in a non-optimal query plan when you use a Hungarian SQL Server collation
826376?(http://support.microsoft.com/kb/826376/EN-US/) FIX: An access violation may occur when you remove all elements from the procedure cache for a linked server over an interrupted remote access connection
826433?(http://support.microsoft.com/kb/826433/) PRB: Additional SQL Server diagnostics added to detect unreported I/O problems
826754?(http://support.microsoft.com/kb/826754/) FIX: A deadlock occurs if you run an explicit UPDATE STATISTICS command
826815?(http://support.microsoft.com/kb/826815/EN-US/) FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries
826822?(http://support.microsoft.com/kb/826822/) FIX: A member of the db_accessadmin fixed database role can create an alias for the dbo special user
826860?(http://support.microsoft.com/kb/826860/) FIX: Linked server query may return NULL if it is performed through a keyset cursor
827175?(http://support.microsoft.com/kb/827175/) FIX: Incorrect parameter numbering occurs in custom stored procedures that are generated with the sp_scriptpublicationcustomprocs stored procedure
827178?(http://support.microsoft.com/kb/827178/EN-US/) FIX: You may receive a 644 error message when you run concurrent transactions on a heap
827714?(http://support.microsoft.com/kb/827714/EN-US/) FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level
827954?(http://support.microsoft.com/kb/827954/) FIX: Slow execution times may occur when you run DML statements against tables that have cascading referential integrity
828096?(http://support.microsoft.com/kb/828096/) FIX: Key locks are held until the end of the statement for rows that do not pass filter criteria
828269?(http://support.microsoft.com/kb/828269/EN-US/) FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP3
828308?(http://support.microsoft.com/kb/828308/EN-US/) FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager
828637?(http://support.microsoft.com/kb/828637/) FIX: Users can control the compensating change process in merge replication
828699?(http://support.microsoft.com/kb/828699/) FIX: An access violation occurs when you run DBCC UPDATEUSAGE on a database that has many objects
828945?(http://support.microsoft.com/kb/828945/EN-US/) FIX: You cannot insert explicit values in an IDENTITY column of a SQL Server table by using the SQLBulkOperations function or the SQLSetPos ODBC function in SQL Server 2000
829183?(http://support.microsoft.com/kb/829183/EN-US/) FIX: The xp_sendmail extended stored procedure returns incorrect result set column widths when data in one of the result set columns contain DBCS characters in SQL Server 2000
829205?(http://support.microsoft.com/kb/829205/EN-US/) FIX: Query performance may be slow and may be inconsistent when you run a query while another query that contains an IN operator with many values is compiled
829386?(http://support.microsoft.com/kb/829386/EN-US/) FIX: You cannot install MSDE 2000 if the Server service is not running
829444?(http://support.microsoft.com/kb/829444/EN-US/) FIX: A floating point exception occurs during the optimization of a query
830262?(http://support.microsoft.com/kb/830262/) FIX: Unconditional update may not hold key locks on new key values
830298?(http://support.microsoft.com/kb/830298/EN-US/) FIX: SQL Server 2000 SP3 may generate slower query plans and bad cardinality estimates
830366?(http://support.microsoft.com/kb/830366/EN-US/) FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031
830375?(http://support.microsoft.com/kb/830375/EN-US/) FIX: The global variable @@ERROR may return an incorrect value after a remote procedure call
830382?(http://support.microsoft.com/kb/830382/) FIX: Distributed queries may incorrectly use SQL Server startup account permissions when SQL Server is running in fiber mode
830395?(http://support.microsoft.com/kb/830395/EN-US/) FIX: An access violation occurs during compilation if the table contains statistics for a computed column
830466?(http://support.microsoft.com/kb/830466/EN-US/) FIX: You may receive an “Internal SQL Server error” error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000
830588?(http://support.microsoft.com/kb/830588/EN-US/) FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler
830596?(http://support.microsoft.com/kb/830596/) FIX: You receive an error message when the xp_logininfo extended stored procedure runs
830767?(http://support.microsoft.com/kb/830767/EN-US/) FIX: SQL Query Analyzer may stop responding when you close a query window or open a file
830773?(http://support.microsoft.com/kb/830773/EN-US/) FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000
830860?(http://support.microsoft.com/kb/830860/EN-US/) FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache
830887?(http://support.microsoft.com/kb/830887/EN-US/) FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfix
830912?(http://support.microsoft.com/kb/830912/) FIX: Key names read from an .ini file for a Dynamic Properties task may be truncated
831302?(http://support.microsoft.com/kb/831302/EN-US/) FIX: SQL Server underestimates the cardinality of a query expression and query performance may be slow
831675?(http://support.microsoft.com/kb/831675/EN-US/) FIX: You may receive incorrect results when you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause
831950?(http://support.microsoft.com/kb/831950/EN-US/) FIX: You receive error message 3456 when you try to apply a transaction log to a server
831997?(http://support.microsoft.com/kb/831997/EN-US/) FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
831999?(http://support.microsoft.com/kb/831999/EN-US/) FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
832437?(http://support.microsoft.com/kb/832437/EN-US/) FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000
832977?(http://support.microsoft.com/kb/832977/) FIX: The DBCC PSS command may cause access violations and 17805 errors in SQL Server 2000
833045?(http://support.microsoft.com/kb/833045/EN-US/) FIX: The xp_sendmail extended stored procedure does not run successfully in SQL Server 2000 SP2 or later
833406?(http://support.microsoft.com/kb/833406/EN-US/) FIX: Cardinality estimates for literals that are outside the histogram range are very low
833547?(http://support.microsoft.com/kb/833547/EN-US/) FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 3 (SP3) may cause an assertion error in the Xdes.cpp file
833710?(http://support.microsoft.com/kb/833710/EN-US/) FIX: You receive an error message when you try to restore a database backup that spans multiple devices
834290?(http://support.microsoft.com/kb/834290/EN-US/) FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED
834451?(http://support.microsoft.com/kb/834451/EN-US/) FIX: Restoring transaction log files takes longer than expected in SQL Server 2000
834453?(http://support.microsoft.com/kb/834453/EN-US/) FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication
834688?(http://support.microsoft.com/kb/834688/EN-US/) FIX: You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs
834720?(http://support.microsoft.com/kb/834720/EN-US/) Fix: An error in a remote procedure call does not roll back the local operation
834798?(http://support.microsoft.com/kb/834798/EN-US/) FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start
834923?(http://support.microsoft.com/kb/834923/EN-US/) FIX: The SQL Server cluster resource may be marked as Fail when you try to take it offline
835864?(http://support.microsoft.com/kb/835864/EN-US/) FIX: Intermittent query slowdowns and corresponding high CPU utilization
836096?(http://support.microsoft.com/kb/836096/EN-US/) FIX: You may receive a 625 error message when you run a query that has a query plan that uses a nested loop join strategy
836136?(http://support.microsoft.com/kb/836136/EN-US/) FIX: The compile time for a query that uses at least one outer join may be greater for SQL Server post-SP3 builds
836141?(http://support.microsoft.com/kb/836141/EN-US/) FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer
836839?(http://support.microsoft.com/kb/836839/) FIX: Extended stored procedures in SQL Server 2000 may take longer to run when multiple users run the extended stored procedures at the same time
837231?(http://support.microsoft.com/kb/837231/EN-US/) FIX: Distribution Agent may fail after you add or drop a column for a published article
837401?(http://support.microsoft.com/kb/837401/EN-US/) FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows
837890?(http://support.microsoft.com/kb/837890/EN-US/) FIX: The CPU column in the sysprocesses system table contains a negative value or an abnormal variation for some processes
837957?(http://support.microsoft.com/kb/837957/EN-US/) FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000
837969?(http://support.microsoft.com/kb/837969/EN-US/) FIX: You may receive an access violation in the CRowsetTraceData::FGetNextRow function when you trace server activity with SQL Profiler
837970?(http://support.microsoft.com/kb/837970/) FIX: You may receive an “Invalid object name” error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000
838409?(http://support.microsoft.com/kb/838409/EN-US/) FIX: SQL Server 2000 Service Pack 1 (SP1) and later builds may not generate an execution plan for a query, and you receive error message 8623
838459?(http://support.microsoft.com/kb/838459/EN-US/) FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option
838460?(http://support.microsoft.com/kb/838460/EN-US/) FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later
839096?(http://support.microsoft.com/kb/839096/EN-US/) FIX: An access violation exception may occur when you use PDH APIs to collect performance data for several instances of SQL Server at the same time
839280?(http://support.microsoft.com/kb/839280/EN-US/) FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2
839458?(http://support.microsoft.com/kb/839458/EN-US/) FIX: An access violation exception may occur when you try to perform a Bulk Import operation to insert data in a SQL Server table
839523?(http://support.microsoft.com/kb/839523/EN-US/) FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000
839529?(http://support.microsoft.com/kb/839529/EN-US/) FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly
839589?(http://support.microsoft.com/kb/839589/EN-US/) FIX: The thread priority is raised for some threads in a parallel query
839688?(http://support.microsoft.com/kb/839688/EN-US/) FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters
839884?(http://support.microsoft.com/kb/839884/EN-US/) FIX: A System.ExecutionEngineException exception occurs when you try to access the DTS DynamicPropertiesTaskAssignments collection
840166?(http://support.microsoft.com/kb/840166/EN-US/) FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000
840208?(http://support.microsoft.com/kb/840208/EN-US/) FIX: You receive a “Msg 8649″ error message when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3)
840406?(http://support.microsoft.com/kb/840406/EN-US/) FIX: Queries that join a view may run slowly if the view contains outer joins
840856?(http://support.microsoft.com/kb/840856/EN-US/) FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3
841401?(http://support.microsoft.com/kb/841401/EN-US/) FIX: You may notice incorrect values for the “Active Transactions” counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer
841404?(http://support.microsoft.com/kb/841404/EN-US/) FIX: You may receive a “The query processor could not produce a query plan” error message in SQL Server when you run a query that includes multiple subqueries that use self-joins
841627?(http://support.microsoft.com/kb/841627/EN-US/) FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances
841776?(http://support.microsoft.com/kb/841776/EN-US/) FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures
843263?(http://support.microsoft.com/kb/843263/EN-US/) FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server
843266?(http://support.microsoft.com/kb/843266/EN-US/) 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)
843267?(http://support.microsoft.com/kb/843267/EN-US/) FIX: Dynamic cursor retrieves the same row two times when you update the non-clustered index key to the same value
843282?(http://support.microsoft.com/kb/843282/EN-US/) FIX: The Osql.exe utility does not run a Transact-SQL script completely if you start the program from a remote session by using a background service and then log off the console session
843534?(http://support.microsoft.com/kb/843534/EN-US/) FIX: You may receive a 3628 error in SQL Server 2000 when you query many items that have an IN clause
867798?(http://support.microsoft.com/kb/867798/EN-US/) FIX: The @date_received parameter of the xp_readmail extended stored procedure incorrectly returns the date and the time that an e-mail message is submitted by the sender in SQL Server 2000
867878?(http://support.microsoft.com/kb/867878/EN-US/) FIX: The Log Reader Agent may cause 17883 error messages
867879?(http://support.microsoft.com/kb/867879/EN-US/) FIX: Merge replication non-convergence occurs with SQL Server CE subscribers
867880?(http://support.microsoft.com/kb/867880/EN-US/) FIX: Merge Agent may fail with an “Invalid character value for cast specification” error message
870972?(http://support.microsoft.com/kb/870972/EN-US/) FIX: The performance of a DML operation that fires a trigger may decrease when the trigger execution plan recompiles repeatedly
870994?(http://support.microsoft.com/kb/870994/EN-US/) FIX: An access violation exception may occur when you run a query that uses index names in the WITH INDEX option to specify an index hint
872842?(http://support.microsoft.com/kb/872842/EN-US/) FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000
872843?(http://support.microsoft.com/kb/872843/EN-US/) FIX: The Log Reader Agent may fail and you receive an assertion error message
873446?(http://support.microsoft.com/kb/873446/EN-US/) FIX: An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMP
873482?(http://support.microsoft.com/kb/873482/EN-US/) FIX: The restore process may take longer to complete when SQL Server 2000 restores transaction log files as part of the log shipping process
875445?(http://support.microsoft.com/kb/875445/EN-US/) FIX: An access violation exception may occur when you try to access SQL Server on a computer that is running under low memory conditions
878500?(http://support.microsoft.com/kb/878500/EN-US/) FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement
878501?(http://support.microsoft.com/kb/878501/EN-US/) FIX: You may receive an error message when you run a SET IDENTITY_INSERT ON statement on a table and then try to insert a row into the table in SQL Server 2000
883415?(http://support.microsoft.com/kb/883415/EN-US/) FIX: A user-defined function returns results that are not correct for a query
884554?(http://support.microsoft.com/kb/884554/EN-US/) FIX: A SPID stops responding with a NETWORKIO (0×800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet
884772?(http://support.microsoft.com/kb/884772/EN-US/) FIX: You may receive a 1203 error message when you perform a complex select query in SQL Server 2000 build 856 or a later version
884850?(http://support.microsoft.com/kb/884850/EN-US/) FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur
884853?(http://support.microsoft.com/kb/884853/EN-US/) FIX: Performance is slow when you update a subscribed table on a subscriber that uses queued updating in SQL Server 2000
884854?(http://support.microsoft.com/kb/884854/EN-US/) FIX: You receive the “Could not find stored procedure” error message when you perform transactional replication with queued updating in SQL Server 2000
884855?(http://support.microsoft.com/kb/884855/EN-US/) FIX: You receive an error message when you run a statement on a table that contains a trigger in SQL Server 2000
884856?(http://support.microsoft.com/kb/884856/EN-US/) FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000
884864?(http://support.microsoft.com/kb/884864/EN-US/) FIX: You may receive incorrect results when you run a query in SQL Server 2000
885158?(http://support.microsoft.com/kb/885158/EN-US/) FIX: Section names are truncated to a total length of 254 characters when you use Data Transformation Services to create a Dynamic Properties task and you add an .ini file in SQL Server 2000
885290?(http://support.microsoft.com/kb/885290/EN-US/) FIX: An assertion error occurs when you insert data in the same row in a table by using multiple connections to an instance of SQL Server
885442?(http://support.microsoft.com/kb/885442/) FIX: You receive a “Server: Msg 8624, Level 16, State 1, Line 3 Internal SQL Server error” error message when you compile a delete query that contains sub-queries that use NOT IN clauses in SQL Server 2000
886708?(http://support.microsoft.com/kb/886708/EN-US/) FIX: Inserting lots of text, ntext, or image data over multiple concurrent connections takes a long time in SQL Server 2000
887974?(http://support.microsoft.com/kb/887974/EN-US/) FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3
888008?(http://support.microsoft.com/kb/888008/EN-US/) FIX: Full-text queries that use the NEAR operator may return different results if the NEAR operands are reversed in SQL Server 2000
888429?(http://support.microsoft.com/kb/888429/EN-US/) FIX: LIKE pattern matching may consider half-width and full-width characters to be equal even if width-sensitive collation is specified
888444?(http://support.microsoft.com/kb/888444/EN-US/) FIX: You receive a 17883 error in SQL Server 2000 Service Pack 3 or in SQL Server 2000 Service Pack 3a when a worker thread becomes stuck in a registry call
888998?(http://support.microsoft.com/kb/888998/EN-US/) FIX: A query that joins two tables on smalldatetime data type columns, may produce incorrect results in SQL Server 2000
889166?(http://support.microsoft.com/kb/889166/EN-US/) FIX: You receive a “Msg 3628″ error message when you run an inner join query in SQL Server 2000
889170?(http://support.microsoft.com/kb/889170/EN-US/) FIX: You receive a “Not enough storage is available to complete this operation” error message when you run a Data Transformation Services package in SQL Server 2000
889239?(http://support.microsoft.com/kb/889239/) FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout events in SQL Server 2000
889266?(http://support.microsoft.com/kb/889266/EN-US/) FIX: A database is marked suspect when you open the database in SQL Server 2000
889314?(http://support.microsoft.com/kb/889314/EN-US/) FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected
890200?(http://support.microsoft.com/kb/890200/EN-US/) FIX: SQL Server 2000 stops listening for new TCP/IP Socket connections unexpectedly after error message 17882 is written to the SQL Server 2000 error log
890637?(http://support.microsoft.com/kb/890637/EN-US/) FIX: A 17883 error is written to the SQL Server 2000 error log and the LogWriter component does not yield correctly
890730?(http://support.microsoft.com/kb/890730/EN-US/) FIX: You receive a 17883 error message when you perform large in-memory sort operations in SQL Server 2000
890755?(http://support.microsoft.com/kb/890755/EN-US/) FIX: A “Server: Msg 7105″ error message is repeatedly logged in the error log, assertions may be logged in the error log, and you receive a “Server: Msg 8929″ error message in SQL Server 2000
890767?(http://support.microsoft.com/kb/890767/EN-US/) FIX: You receive a “Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1″ error message when the sum of the length of the published column names in a merge publication exceeds 4,000 characters in SQL Server 2000
890768?(http://support.microsoft.com/kb/890768/EN-US/) FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000
890925?(http://support.microsoft.com/kb/890925/EN-US/) FIX: The @@ERROR system function may return an incorrect value when you execute a Transact-SQL statement that uses a parallel execution plan in SQL Server 2000 32-bit or in SQL Server 2000 64-bit
890942?(http://support.microsoft.com/kb/890942/EN-US/) FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3
891017?(http://support.microsoft.com/kb/891017/EN-US/) FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201?(http://support.microsoft.com/kb/891201/EN-US/) FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268?(http://support.microsoft.com/kb/891268/EN-US/) FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891707?(http://support.microsoft.com/kb/891707/EN-US/) FIX: A decrease in ad-hoc query processing may occur when you submit many ad-hoc queries without using defined parameters in SQL Server 2000
892406?(http://support.microsoft.com/kb/892406/EN-US/) FIX: The setting for the precision and the scale of the data that is returned from a stored procedure output parameter is (38,0) when a null value is returned in SQL Server 2000
892451?(http://support.microsoft.com/kb/892451/EN-US/) BUG: You receive an “EXCEPTION_ACCESS_VIOLATION” error message when you use a RIGHT OUTER JOIN clause in SQL Server 2000
892924?(http://support.microsoft.com/kb/892924/EN-US/) FIX: You receive a 7619 error message when you run a full text query that contains certain Japanese character strings on an instance of SQL Server 2000 that is running on a Windows 2000-based computer

Symptoms
There are a number of different rounding algorithms available in Microsoftproducts. Rounding algorithms range from Arithmetic Rounding in Excel’sWorksheet Round() function to Banker’s Rounding in the CInt(), CLng(), andRound() functions in Visual Basic for Applications. This article describeswhat the various Visual Basic for Applications rounding functions do andprovides samples of using the functions. In addition, the article includessample functions that implement various rounding algorithms.
Resolution
Rounding ExplainedYou need to round when you want to convert a number of greater precisioninto a number of lesser precision. The most common case is when you need toconvert a floating-point number into an integer.
Rounding DownThe simplest form of rounding is truncation. Any digits after the desiredprecision are simply ignored. The VBA Fix() function is an example oftruncation. For example, Fix(3.5) is 3, and Fix(-3.5) is -3.
The Int() function rounds down to the highest integer less than the value.Both Int() and Fix() act the same way with positive numbers – truncating -but give different results for negative numbers: Int(-3.5) gives -4.
The Fix() function is an example of symmetric rounding because it affectsthe magnitude (absolute value) of positive and negative numbers in the sameway. The Int() function is an example of asymmetric rounding because itaffects the magnitude of positive and negative numbers differently.
Excel has similar spreadsheet functions: Int(), Floor(), and RoundDown().Int() works the same way as Int() does in Visual Basic for Applications.Floor() truncates positive values, but does not work with negative numbers.The RoundDown() function works the same way as the VBA Fix() function.
Microsoft SQL Server has a Round() function that can act like the VBA Fix()function. SQL Server also has a Floor() function, which works the same wayas VBA Int() function.
Rounding UpSQL Server and Excel both have a function called Ceiling(), which alwaysrounds fraction values up (more positive) to the next value.
Visual Basic for Applications does not have a corresponding round-upfunction. However, for negative numbers, both Fix() and Int() can be usedto round upward, in different ways.
Fix() rounds towards 0 (up in the absolute sense, but down in terms ofabsolute magnitude). Fix(-3.5) is -3.5.
Int() rounds away from 0 (up in terms of absolute magnitude, but down inthe absolute sense). Int(-3.5) is -4.
Arithmetic RoundingWhen rounding always down or up, the resulting number is not necessarilythe closest to the original number. For example, if you round 1.9 down to1, the difference is a lot larger than if you round it up to 2. It is easyto see that numbers from 1.6 to 2.4 should be rounded to 2.
However, what about 1.5, which is equidistant between 1 and 2? Byconvention, the half-way number is rounded up.
You can implement rounding half-way numbers in a symmetric fashion, suchthat -.5 is rounded down to -1, or in an asymmetric fashion, where -.5 isrounded up to 0.
The following functions provide symmetric arithmetic rounding:
The Excel Round() spreadsheet function.
The SQL Server Round() function can do symmetric arithmetic rounding.
The following function provide asymmetric arithmetic rounding:
The Round() method of the Java Math library.
Visual Basic for Applications does not have any function that doesarithmetic rounding.
Banker’s RoundingWhen you add rounded values together, always rounding .5 in the samedirection results in a bias that grows with the more numbers you addtogether. One way to minimize the bias is with banker’s rounding.
Banker’s rounding rounds .5 up sometimes and down sometimes. The conventionis to round to the nearest even number, so that both 1.5 and 2.5 round to2, and 3.5 and 4.5 both round to 4. Banker’s rounding is symmetric.
In Visual Basic for Applications, the following numeric functions performbanker’s rounding: CByte(), CInt(), CLng(), CCur(), and Round().
There are no Excel spreadsheet functions that perform banker’s rounding.
Random RoundingEven banker’s rounding can bias totals. You can take an extra step toremove bias by rounding .5 up or down in a truly random fashion. This way,even if the data is deliberately biased, bias might be minimized. However,using random rounding with randomly distributed data might result in alarger bias than banker’s rounding. Random rounding could result in twodifferent totals on the same data.
No Microsoft products implement any sort of random rounding procedure.
Alternate RoundingAlternate rounding is rounding between .5 up and .5 down on successivecalls.
No Microsoft products implement an alternate rounding procedure.
The Round() Function is Inconsistently ImplementedThe Round() function is not implemented in a consistent fashion amongdifferent Microsoft products for historical reasons.
The following table relates product to implementation:

ProductImplementation———————————————————————-Visual Basic for Applications 6.0Banker’s RoundingExcel WorksheetSymmetric Arithmetic RoundingSQL ServerEither Symmetric Arithmetic Roundingor Symmetric Round Down (Fix)depending on argumentsJava Math libraryAsymmetric Arithmetic Rounding
The Round() function in Visual Basic 6.0 and Visual Basic for Applications6.0 performs banker’s rounding. It has an optional second argument thatspecifies the number of decimal digits to round to:

Debug.Print Round(2.45, 1) returns 2.4.
Sample DataThe following table shows some sample data and the effects of variousrounding methods on the numbers and totals generated.

Number/Int./Fix/Ceiling/Asym. Arith./Sym. Arith./Banker’s/Random/Alt.———————————————————————-2.6-3-2-2-3-3-3-3-3-2.5-3-2-2-2-3-2-2-3-2.4-3-2-2-2-2-2-2-2-1.6-2-1-1-2-2-2-2-2-1.5-2-1-1-1-2-2-1-1-1.4-2-1-1-1-1-1-1-1-0.6-100-1-1-1-1-1-0.5-1000-10-1-1-0.4-100000000.4001000000.5001110110.6001111111.4112111111.5112222111.6112222222.4223222222.5223332332.622333333
Total of all numbers:

Number/Int./Fix/Ceiling/Asym. Arith./Sym. Arith./Banker’s/Random/Alt.———————————————————————0.0-90930010
Total of all negative numbers:

Number/Int./Fix/Ceiling/Asym. Arith./Sym. Arith./Banker’s/Random/Alt.———————————————————————-13.5-18-9-9-12-15-13-13-14
Total of all positive numbers:

Number/Int./Fix/Ceiling/Asym. Arith./Sym. Arith./Banker’s/Random/Alt.———————————————————————13.599181515131414
The table shows the difference between the various rounding methods. Forrandomly distributed positive and negative numbers, Fix(), symmetricarithmetic rounding, banker’s rounding, and alternating rounding providethe least difference from actual totals, with random rounding not farbehind.
However, if the numbers are either all positive or all negative, banker’srounding, alternating rounding, and random rounding provide the leastdifference from the actual totals.
Sample User-Defined Rounding FunctionsThe sample code in the following Function Listing section provides sampleimplementations for each of the rounding types described.
The functions provided are:

AsymDownAsymmetrically rounds numbers down – similar to Int().Negative numbers get more negative.SymDownSymmetrically rounds numbers down – similar to Fix().Truncates all numbers toward 0.Same as AsymDown for positive numbers.AsymUpAsymmetrically rounds numbers fractions up.Same as SymDown for negative numbers.Similar to Ceiling.SymUpSymmetrically rounds fractions up – that is, away from 0.Same as AsymUp for positive numbers.Same as AsymDown for negative numbers.AsymArithAsymmetric arithmetic rounding – rounds .5 up always.Similar to Java worksheet Round function.SymArithSymmetric arithmetic rounding – rounds .5 away from 0.Same as AsymArith for positive numbers.Similar to Excel Worksheet Round function.BRoundBanker’s rounding.Rounds .5 up or down to achieve an even number.Symmetrical by definition.RandRoundRandom rounding.Rounds .5 up or down in a random fashion.AltRoundAlternating rounding.Alternates between rounding .5 up or down.ATruncDigitsSame as AsyncTrunc but takes different arguments.
All of these functions take two arguments: the number to be rounded and anoptional factor. If the factor is omitted, then the functions return aninteger created by one of the above methods. If the factor is specified,the number is scaled by the factor to create different rounding effects.For example AsymArith(2.55, 10) produces 2.6, that is, it rounds to1/factor = 1/10 = 0.1.
NOTE: A factor of 0 generates a run-time error: 1/factor = 1/0.
The following table shows the effects of various factors:

ExpressionResultComment——————————————————————–AsymArith(2.5)3Rounds up to next integer.BRound(2.18, 20)2.2Rounds to the nearest 5 cents (1/20 dollar).SymDown(25, .1)20Rounds down to an even multiple of 10.
The exception to the above description is ADownDigits, which is a templatefunction that allows you to specify the number of decimal digits instead ofa factor.

ExpressionResult Comment———————————————————————ADownDigits(2.18, 1)2.1Rounds down to next multiple of 10 ^ -1.
Function Listing

Function AsymDown(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleAsymDown = Int(X * Factor) / FactorEnd FunctionFunction SymDown(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleSymDown = Fix(X * Factor) / Factor’Alternately:’SymDown = AsymDown(Abs(X), Factor) * Sgn(X)End FunctionFunction AsymUp(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleDim Temp As DoubleTemp = Int(X * Factor)AsymUp = (Temp + IIf(X = Temp, 0, 1)) / FactorEnd FunctionFunction SymUp(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleDim Temp As DoubleTemp = Fix(X * Factor)SymUp = (Temp + IIf(X = Temp, 0, Sgn(X))) / FactorEnd FunctionFunction AsymArith(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleAsymArith = Int(X * Factor + 0.5) / FactorEnd FunctionFunction SymArith(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleSymArith = Fix(X * Factor + 0.5 * Sgn(X)) / Factor’Alternately:’SymArith = Abs(AsymArith(X, Factor)) * Sgn(X)End FunctionFunction BRound(ByVal X As Double, _Optional ByVal Factor As Double = 1) As Double’For smaller numbers:’BRound = CLng(X * Factor) / FactorDim Temp As Double, FixTemp As DoubleTemp = X * FactorFixTemp = Fix(Temp + 0.5 * Sgn(X))’ Handle rounding of .5 in a special mannerIf Temp – Int(Temp) = 0.5 ThenIf FixTemp / 2 <> Int(FixTemp / 2) Then ‘ Is Temp odd’ Reduce Magnitude by 1 to make evenFixTemp = FixTemp – Sgn(X)End IfEnd IfBRound = FixTemp / FactorEnd FunctionFunction RandRound(ByVal X As Double, _Optional ByVal Factor As Double = 1) As Double’ Should Execute Randomize statement somewhere prior to calling.Dim Temp As Double, FixTemp As DoubleTemp = X * FactorFixTemp = Fix(Temp + 0.5 * Sgn(X))’ Handle rounding of .5 in a special manner.If Temp – Int(Temp) = 0.5 Then’ Reduce Magnitude by 1 in half the cases.FixTemp = FixTemp – Int(Rnd * 2) * Sgn(X)End IfRandRound = FixTemp / FactorEnd FunctionFunction AltRound(ByVal X As Double, _Optional ByVal Factor As Double = 1) As DoubleStatic fReduce As BooleanDim Temp As Double, FixTemp As DoubleTemp = X * FactorFixTemp = Fix(Temp + 0.5 * Sgn(X))’ Handle rounding of .5 in a special manner.If Temp – Int(Temp) = 0.5 Then’ Alternate between rounding .5 down (negative) and up (positive).If (fReduce And Sgn(X) = 1) Or (Not fReduce And Sgn(X) = -1) Then’ Or, replace the previous If statement with the following to’ alternate between rounding .5 to reduce magnitude and increase’ magnitude.’ If fReduce ThenFixTemp = FixTemp – Sgn(X)End IffReduce = Not fReduceEnd IfAltRound = FixTemp / FactorEnd FunctionFunction ADownDigits(ByVal X As Double, _Optional ByVal Digits As Integer = 0) As DoubleADownDigits = AsymDown(X, 10 ^ Digits)End Function
NOTE: With the exception of Excel’s MRound() worksheet function, the built-in rounding functions take arguments in the manner of ADownDigits, wherethe second argument specifies the number of digits instead of a factor.
The rounding implementations presented here use a factor, like MRound(),which is more flexible because you do not have to round to a power of 10.You can write wrapper functions in the manner of ADownDigits.
Floating Point LimitationsAll of the rounding implementations presented here use the double datatype, which can represent approximately 15 decimal digits.
Since not all fractional values can be expressed exactly, you might getunexpected results because the display value does not match the storedvalue.
For example, the number 2.25 might be stored internally as 2.2499999…,which would round down with arithmetic rounding, instead of up as you mightexpect. Also, the more calculations a number is put through, the greaterpossibility that the stored binary value will deviate from the idealdecimal value.
If this is the case, you may want to choose a different data type, such asCurrency, which is exact to 4 decimal places.
You might also consider making the data types Variant and use CDec() toconvert everything to the Decimal data type, which can be exact to 28decimal digits.
Rounding Currency ValuesWhen you use the Currency data type, which is exact to 4 decimal digits,you typically want to round to 2 decimal digits for cents.
The Round2CB function below is a hard-coded variation that performsbanker’s rounding to 2 decimal digits, but does not multiply the originalnumber. This avoids a possible overflow condition if the monetary amount isapproaching the limits of the Currency data type.

Function Round2CB (ByVal X As Currency) As CurrencyRound2CB = CCur(X / 100) * 100End Function
Rounding Decimal ValuesThe following is an example of asymmetric arithmetic rounding using theDecimal data type:

Function AsymArithDec(ByVal X As Variant, _Optional ByVal Factor As Variant = 1) As VariantIf Not IsNumeric(X) ThenAsymArithDec = XElseIf Not IsNumeric(Factor) Then Factor = 1AsymArithDec = Int(CDec(X * Factor) + .5)End IfEnd Function
Dropping Precision as a Shortcut in RoundingAs taught in school, rounding is usually arithmetic rounding using positivenumbers. With this type of rounding, you only need to know the number to 1digit past where you are rounding to. You ignore digits past the firstdecimal place. In other words, precision is dropped as a shortcut torounding the value.
For example, both 2.5 and 2.51 round up to 3, while both 2.4 and 2.49 rounddown to 2.
When you use banker’s rounding (or other methods that round .5 either up ordown) or when you round negative numbers using asymmetric arithmeticrounding, dropping precision can lead to incorrect results where you mightnot round to the nearest number.
For example, with banker’s rounding, 2.5 rounds down to 2 and 2.51 roundsup to 3.
With asymmetric arithmetic rounding, -2.5 rounds up to -2 while -2.51rounds down to -3.
The user-defined functions presented in this article take the number’s fullprecision into account when performing rounding.

Symptoms
Windows Firewall on Windows Server 2008 helps prevent unauthorized access to computer resources. However, if the firewall is configured incorrectly, attempts to connect to an instance ofSQL Server may be blocked.To access an instance of SQL Server that is behind the firewall, you must configure the firewall on the computer that is running SQL Server.
This article helps you open the firewall ports for SQL Server on Windows Server 2008.
To have us fix this problem for you, go to the “Fix it for me”section. If you prefer to fix this problem yourself, go to the “Let me fix it myself” section.

Resolution
To fix this problem automatically, click theFix this problemlink. ClickRunin the File Downloaddialog box, and then follow the steps in this wizard.

a.button {background: url(/library/images/support/KBGraphics/PUBLIC/cn/FixItButton.jpg) no-repeat 0 0;width: 139px;height: 56px;display:block;cursor:pointer;}a.button:hover {background-position: bottom right;}Fix this problem
Microsoft Fix it 50169

Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
Next, go to the “Did this fix the problem?” section.