Sqlagent.exe

Microsoft SQL Server 2000 Agent

Sqlagent.exe version 2000.80.997.0:

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

Sqlagent.exe version 2000.80.993.0:

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

Sqlagent.exe version 2000.80.2273.0:

• 948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000: July 8, 2008 Q948111 KB948111 x86 ia64
• 941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege Q941203 KB941203 x86 ia64

Sqlagent.exe version 2000.80.2271.0:

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

Sqlagent.exe version 2000.80.2265.0:

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

Sqlagent.exe version 2000.80.2253.0:

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

Sqlagent.exe version 2000.80.2249.0:

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

Sqlagent.exe version 2000.80.2248.0:

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

Sqlagent.exe version 2000.80.2246.0:

• 935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000 Q935465 KB935465 x86 IA-64

Sqlagent.exe version 2000.80.2245.0:

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

Sqlagent.exe version 2000.80.2244.0:

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

Sqlagent.exe version 2000.80.2242.0:

• 932686 FIX: Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication in SQL Server 2000: “Cannot create a file when that file already exists” Q932686 KB932686
• 932674 FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4 Q932674 KB932674
• 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 Q929131 KB929131 x86

Sqlagent.exe version 2000.80.2238.0:

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

Sqlagent.exe version 2000.80.2236.0:

• 930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 every 49.7 days Q930484 KB930484 x86 IA-64

Sqlagent.exe version 2000.80.2234.0:

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

Sqlagent.exe version 2000.80.2232.0:

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

Sqlagent.exe version 2000.80.2231.0:

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

Sqlagent.exe version 2000.80.2229.0:

• 927186 FIX: Error message when you create a merge replication for tables that have computed columns or columns of the timestamp data type in SQL Server 2000 Service Pack 4: "The process could not log conflict information" Q927186 KB927186 x86

Sqlagent.exe version 2000.80.2226.0:

• 925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000 Q925732 KB925732 x86 IA-64
• 925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000 Q925684 KB925684 x86 IA-64

Sqlagent.exe version 2000.80.2223.0:

• 925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: "The process could not enumerate changes at the 'Subscriber'" Q925678 KB925678 x86 IA-64
• 925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000 Q925419 KB925419 x86

Sqlagent.exe version 2000.80.2218.0:

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

Sqlagent.exe version 2000.80.2217.0:

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

Sqlagent.exe version 2000.80.2215.0:

• 924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000 Q924662 KB924662 x86 IA-64
• 923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher Q923796 KB923796 x86 IA-64
• 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" Q923563 KB923563 x86 IA-64
• 923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000 Q923327 KB923327 x86

Sqlagent.exe version 2000.80.2207.0:

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

Sqlagent.exe version 2000.80.2201.0:

• 920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000 Q920930 KB920930 x86 IA-64

Sqlagent.exe version 2000.80.2199.0:

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

Sqlagent.exe version 2000.80.2197.0:

• 919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: "Failed to read trace data" Q919399 KB919399 x86
• 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 Q919133 KB919133 x86
• 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 Q919068 KB919068 x86

Sqlagent.exe version 2000.80.2196.0:

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

Sqlagent.exe version 2000.80.2194.0:

• 917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000 Q917972 KB917972 x86
• 917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding Q917565 KB917565 x86

Sqlagent.exe version 2000.80.2192.0:

• 917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4 Q917606 KB917606 x86 IA-64
• 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 Q917593 KB917593 x86

Sqlagent.exe version 2000.80.2191.0:

• 916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer Q916950 KB916950 x86 IA-64
• 916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'" Q916698 KB916698 x86

Sqlagent.exe version 2000.80.2189.0:

• 916653 FIX: An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000 Q916653 KB916653 x86 IA-64
• 916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000 Q916652 KB916652 x86 IA-64
• 915436 FIX: Error message when you run a complex insert query or a stored procedure in SQL Server 2000: "Internal SQL Server error" Q915436 KB915436 x86
• 913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4 Q913438 KB913438 x86 IA-64

Sqlagent.exe version 2000.80.2187.0:

• 915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000 Q915340 KB915340 x86
• 914439 FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000 Q914439 KB914439 x86
• 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 Q914384 KB914384 x86
• 914298 FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data Q914298 KB914298 x86
• 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 Q913991 KB913991 x86
• 909379 FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000 Q909379 KB909379 x86
• 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 Q909100 KB909100 x86

Sqlagent.exe version 2000.80.2180.0:

• 913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000 Q913789 KB913789 x86
• 913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor Q913684 KB913684 IA-64

Sqlagent.exe version 2000.80.2175.0:

• 911678 FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000 Q911678 KB911678 x86 IA-64
• 911677 FIX: A query may run more slowly against SQL Server 2000 post-SP3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988 Q911677 KB911677 x86
• 911569 FIX: You may receive an access violation error message when you run a linked server query that includes a subquery Q911569 KB911569 x86

Sqlagent.exe version 2000.80.2172.0:

• 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 Q910710 KB910710 x86 IA-64
• 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 Q910707 KB910707 x86 IA-64

Sqlagent.exe version 2000.80.2171.0:

• 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 Q910895 KB910895 x86 IA-64
• 910392 FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000 Q910392 KB910392 x86 IA-64
• 909380 FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000 Q909380 KB909380 x86 IA-64
• 909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected Q909369 KB909369 x86 IA-64
• 909089 FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000 Q909089 KB909089 x86 IA-64
• 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 Q908156 KB908156 x86 IA-64

Sqlagent.exe version 2000.80.2166.0:

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

Sqlagent.exe version 2000.80.2159.0:

• 907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000 Q907250 KB907250 x86
• 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 Q906790 KB906790 IA-64

Sqlagent.exe version 2000.80.2156.0:

• 906890 FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000 Q906890 KB906890 x86 IA-64
• 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 Q906790 KB906790 IA-64

Sqlagent.exe version 2000.80.2151.0:

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

Sqlagent.exe version 2000.80.2148.0:

• 900470 FIX: You may receive an error message when you perform transactional replication in SQL Server 2000 Q900470 KB900470 x86
• 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 Q899410 KB899410 x86

Sqlagent.exe version 2000.80.2050.0:

• 948110 MS08-040: Description of the security update for SQL Server 2000 GDR and MSDE 2000: July 8, 2008 Q948110 KB948110 ia64
• 941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege Q941203 KB941203 ia64

Sqlagent.exe version 2000.80.1037.0:

• 930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 every 49.7 days Q930484 KB930484 x86 IA-64

Sqlagent.exe version 2000.80.1036.0:

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

Sqlagent.exe version 2000.80.1035.0:

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

Sqlagent.exe version 2000.80.1034.0:

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

Sqlagent.exe version 2000.80.1030.0:

• 872843 FIX: The Log Reader Agent may fail and you receive an assertion error message Q872843 KB872843 x86

Sqlagent.exe version 2000.80.1029.0:

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

Sqlagent.exe version 2000.80.1027.0:

• 900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000 Q900416 KB900416 x86 IA-64

Sqlagent.exe version 2000.80.1024.0:

• 898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3" Q898709 KB898709 x86 IA-64

Sqlagent.exe version 2000.80.1014.0:

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