United States

Change

All Microsoft Sites

Help and Support

Article ID: 903086 - Last Review: November 2, 2007 - Revision: 2.6

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

Hotfix Download Available
View and request hotfix downloads

View products that this article applies to.

Bug #: 474449 (SQL Server 8.0)
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 (http://support.microsoft.com/kb/256986/ ) Description of the Microsoft Windows registry

Microsoft distributes Microsoft SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.

SUMMARY

This article describes the following about this hotfix release:

The issues that are fixed by this hotfix package
The prerequisites for installing the hotfix package
Information about whether you must restart the computer after you install the hotfix package
Information about whether the hotfix package is replaced by any other hotfix package
Information about whether you must make any registry changes
The files that are contained in the hotfix package

Back to the top

SYMPTOMS

Consider the following scenario:

You have a Transact-SQL script.
You configure the Microsoft SQL Server 2000 SQL Server Agent to run this script as a job.

In this scenario, you experience the following symptoms if an error is raised in this script:

The batch stops running.
Output from the job is truncated after the location in the batch where the error occurred.

Note This problem occurs even if you apply the fix that is mentioned in the following Microsoft Knowledge Base article:

309802 (http://support.microsoft.com/kb/309802/ ) FIX: A call to a RAISERROR statement in a Transact-SQL batch can cause a SQLAgent job to fail and to lose output in SQL Server

Back to the top

CAUSE

This problem may occur if your script processes messages and then generates output in the form of a result set.

Back to the top

RESOLUTION

The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:

The system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.

Note This issue does not occur on systems that use the Intel Itanium processor architecture.
The system is running a 64-bit version of the Microsoft Windows Server operating system.
The system is running a 32-bit version of SQL Server 2000.

We have corrected this installation issue in later builds of SQL Server 2000, starting with version 8.00.2244. When a customer who is running SQL Server 2000 on an x64-based system requests this hotfix, we will provide a build that includes this hotfix and that can be installed correctly on an x64-based system. The build that we provide will be version 8.00.2244 or a later version.

Back to the top

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

You must have SQL Server 2000 Service Pack 4 (SP4) installed to apply this hotfix.

For more information about how to obtain SQL Server 2000 Service Pack 4, 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

Restart information

You do not have to restart your computer after you apply this hotfix.

Registry information

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

You must modify the registry after you apply this hotfix. After you apply this hotfix, SQL Server Agent behavior is defined by a new registry DWORD value that is named TruncateJobResultOnError. To enable the new behavior, add the TruncateJobResultOnError value to one of the following registry subkeys, and then set the TruncateJobResultOnError value to 0:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent (default instance)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\SQLServerAgent (named instance)

After you restart SQL Server Agent, job results will no longer be truncated by RAISEERROR statements. To restore the original behavior, set the TruncateJobResultOnError value to 1. This value is the default value if the value is not set.

Warning If you set this registry value to 0, and if the Transact-SQL script contains an infinite loop in which an error is raised, the SQL Server Agent continuously logs this error. Therefore, this error logging may use all the hard disk space.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

309802 (http://support.microsoft.com/kb/309802/ ) FIX: A call to a RAISERROR statement in a Transact-SQL batch can cause a SQLAgent job to fail and to lose output in SQL Server

Hotfix file information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain of all the files that you must have to fully update a product to the latest build.

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

SQL Server 2000 32-bit versions

   Date         Time   Version         Size       File name
   -------------------------------------------------------------------
   17-Jun-2005  00:15  5.2.3790.1288       8,704  Updatelauncher.exe  
   01-Jun-2005  17:22  6.1.22.5           25,824  Spupdsvc.exe     
   12-Jul-2005  18:37                        869  Tempcatsign.cdf
   06-Jun-2005  22:46  8.11.50523.0      239,104  Mssdi98.dll      
   17-May-2005  01:51  2000.80.1025.0     57,904  Osql.exe         
   12-Jul-2005  17:24  2000.80.2148.0    430,080  Pfclnt80.dll     
   17-Jun-2005  00:15                    552,068  Procsyst.sql
   17-Jun-2005  00:15                     18,810  Sp4_serv_qfe.sql
   08-Jul-2005  01:50  2000.80.2148.0    323,584  Sqlagent.exe     
   08-Jul-2005  02:51  2000.80.2148.0    118,784  Sqldiag.exe      
   08-Jul-2005  02:09  2000.80.2148.0    102,400  Sqlfth75.dll     
   08-Jul-2005  16:07  2000.80.2148.0  9,154,560  Sqlservr.exe     
   17-May-2005  01:51  2000.80.1025.0     57,904  Osql.exe         
   16-Jun-2005  17:40  1.0.125.0       1,366,016  Sqlstpcustomdll.dll  
   26-May-2005  12:37                     25,088  Sqlstpcustomdll.rll
   01-Jun-2005  17:25  6.1.22.5          462,560  Updspapi.dll     
   01-Jun-2005  17:22  6.1.22.5           22,752  Spupdsvc.exe     
   12-Jul-2005  18:35                        869  Tempcatsign.cdf
   06-Jun-2005  22:46  8.11.50523.0      239,104  Mssdi98.dll      
   17-May-2005  01:51  2000.80.1025.0     57,904  Osql.exe         
   12-Jul-2005  17:24  2000.80.2148.0    430,080  Pfclnt80.dll     
   17-Jun-2005  00:15                    552,068  Procsyst.sql
   17-Jun-2005  00:15                     18,810  Sp4_serv_qfe.sql
   08-Jul-2005  01:50  2000.80.2148.0    323,584  Sqlagent.exe     
   08-Jul-2005  02:51  2000.80.2148.0    118,784  Sqldiag.exe      
   08-Jul-2005  02:09  2000.80.2148.0    102,400  Sqlfth75.dll     
   08-Jul-2005  16:07  2000.80.2148.0  9,154,560  Sqlservr.exe     
   17-May-2005  01:51  2000.80.1025.0     57,904  Osql.exe         
   16-Jun-2005  17:23  1.0.125.0         941,568  Sqlstpcustomdll.dll  
   26-May-2005  12:18                     24,576  Sqlstpcustomdll.rll
   01-Jun-2005  17:25  6.1.22.5          371,936  Updspapi.dll

SQL Server 2000 64-bit version

   Date         Time   Version         Size        File name              Platform
   -------------------------------------------------------------------------------
   08-Jul-2005  16:22  2000.80.2148.0     106,496  Atxcore.dll            IA-64
   08-Jul-2005  16:22  2000.80.2148.0     162,816  Axscphst.dll           IA-64
   08-Jul-2005  01:37  2000.85.1016.0     200,704  Bcp.exe                IA-64
   08-Jul-2005  01:39  2000.80.2148.0      11,264  Cmdwrap.exe            IA-64
   08-Jul-2005  16:57  2000.80.2148.0     285,696  Cnvrem.dll             IA-64
   08-Jul-2005  16:57  2000.80.2148.0      61,952  Cnvsvc.exe             IA-64
   08-Jul-2005  01:37  2000.80.2148.0      59,392  Dbmslpcn.dll           IA-64
   08-Jul-2005  03:05  2000.80.2148.0      60,928  Dbmsshrn.dll           IA-64
   08-Jul-2005  16:25  2000.80.2148.0      88,576  Distrib.exe            IA-64
   08-Jul-2005  16:24  2000.80.2148.0      27,648  Ftsetup.exe            IA-64
   08-Jul-2005  16:24  2000.80.2148.0     244,224  Impprov.dll            IA-64
   08-Jul-2005  16:29  2000.80.2148.0     258,048  Logread.exe            IA-64
   08-Jul-2005  17:58  8.0.2148.0       1,907,200  Msdmeng.dll            IA-64
   08-Jul-2005  17:36  8.0.2148.0       5,489,152  Msdmine.dll            IA-64
   08-Jul-2005  16:28  2000.80.2148.0     188,416  Msgprox.dll            IA-64
   08-Jul-2005  19:16  8.0.2148.0       5,651,456  Msmdcb80.dll           IA-64
   08-Jul-2005  17:03  8.0.2148.0       5,961,216  Msmdgd80.dll           IA-64
   08-Jul-2005  17:01  8.0.2148.0       5,289,472  Msmdpump.dll           IA-64
   08-Jul-2005  19:15  8.0.2148.0       6,492,160  Msmdsrv.exe            IA-64
   08-Jul-2005  19:46  8.0.2148.0       6,845,952  Msolap80.dll           IA-64
   06-Jun-2005  22:46  8.11.50523.0       758,784  Mssdi98.dll            IA-64
   12-May-2005  00:01  1.0.1045.0       2,801,336  Msxmlsql.dll           IA-64
   08-Jul-2005  16:23  2000.80.2148.0     151,040  Odsole70.dll           IA-64
   08-Jul-2005  01:37  2000.80.2148.0      27,136  Opends60.dll           IA-64
   08-Jul-2005  01:41                      19,880  Opends60.lib
   08-Jul-2005  16:24  2000.80.2148.0     149,504  Osql.exe               IA-64
   08-Jul-2005  16:22  2000.80.2148.0   1,187,840  Pfclnt80.dll           IA-64
   08-Jul-2005  16:36  2000.80.2148.0     356,864  Qrdrsvc.exe            IA-64
   08-Jul-2005  16:44  2000.80.2148.0   1,033,728  Rdistcom.dll           IA-64
   08-Jul-2005  16:28  2000.80.2148.0     132,608  Repldist.dll           IA-64
   08-Jul-2005  16:28  2000.80.2148.0     173,056  Repldp.dll             IA-64
   08-Jul-2005  16:27  2000.80.2148.0     201,728  Replerrx.dll           IA-64
   08-Jul-2005  16:38  2000.80.2148.0     375,296  Replmerg.exe           IA-64
   08-Jul-2005  16:32  2000.80.2148.0     537,600  Replprov.dll           IA-64
   08-Jul-2005  16:32  2000.80.2148.0     775,168  Replrec.dll            IA-64
   08-Jul-2005  16:32  2000.80.2148.0     233,984  Replsync.dll           IA-64
   08-Jul-2005  16:39  2000.80.2148.0     654,336  Rinitcom.dll           IA-64
   08-Jul-2005  17:07  2000.80.2148.0     161,280  Semmap.dll             IA-64
   08-Jul-2005  16:30  2000.80.2148.0     153,088  Semnt.dll              IA-64
   08-Jul-2005  16:58  2000.80.2148.0     383,488  Setup.exe              IA-64
   08-Jul-2005  16:31  2000.80.2148.0      91,136  Snapshot.exe           IA-64
   08-Jul-2005  16:33  2000.80.2148.0      97,792  Spresolv.dll           IA-64
   08-Jul-2005  17:08  2000.80.2148.0     269,824  Sqdedev.dll            IA-64
   08-Jul-2005  16:32  2000.80.2148.0     171,520  Sqladhlp.exe           IA-64
   08-Jul-2005  17:10  2000.80.2148.0      14,848  Sqlagent.dll           IA-64
   08-Jul-2005  17:10  2000.80.2148.0   1,061,376  Sqlagent.exe           IA-64
   08-Jul-2005  17:12  2000.80.2148.0     103,936  Sqlatxss.dll           IA-64
   08-Jul-2005  16:41  2000.80.2148.0      90,112  Sqlboot.dll            IA-64
   08-Jul-2005  17:19  2000.80.2148.0   2,275,328  Sqlca.dll              IA-64
   08-Jul-2005  17:10  2000.80.2148.0     811,008  Sqlcluster.dll         IA-64
   08-Jul-2005  17:13  2000.80.2148.0     132,608  Sqlcmdss.dll           IA-64
   08-Jul-2005  16:23  2000.80.2148.0      32,256  Sqlctr80.dll           IA-64
   08-Jul-2005  01:43  2000.80.2148.0     812,032  Sqldata.dll            IA-64
   08-Jul-2005  01:46                       1,774  Sqldata.lib
   08-Jul-2005  16:33  2000.80.2148.0     334,336  Sqldiag.exe            IA-64
   12-May-2005  00:01  1.0.48.0         1,428,480  Sqldiscoveryapi.dll    IA-64
   08-Jul-2005  16:35  2000.80.2148.0     314,368  Sqldistx.dll           IA-64
   08-Jul-2005  17:18  2000.80.2148.0  13,860,352  Sqldmo.dll             IA-64
   08-Jul-2005  16:34                      51,712  Sqldumper.exe          IA-64
   08-Jul-2005  16:24  2000.80.2148.0     246,784  Sqlfth75.dll           IA-64
   08-Jul-2005  16:24  2000.80.2148.0     420,864  Sqlftqry.dll           IA-64
   08-Jul-2005  16:39  2000.80.2148.0     251,904  Sqlinitx.dll           IA-64
   08-Jul-2005  16:36  2000.80.2148.0     119,296  Sqlisapi.dll           IA-64
   08-Jul-2005  17:10  2000.80.2148.0     498,176  Sqlmaint.exe           IA-64
   08-Jul-2005  16:21  2000.80.2148.0      23,040  Sqlmap70.dll           IA-64
   08-Jul-2005  16:38  2000.80.2148.0     320,000  Sqlmergx.dll           IA-64
   08-Jul-2005  16:37  2000.80.2148.0     162,816  Sqlrepss.dll           IA-64
   08-Jul-2005  01:42  2000.80.2148.0      29,184  Sqlresld.dll           IA-64
   08-Jul-2005  16:23  2000.80.2148.0  30,181,888  Sqlservr.exe           IA-64
   08-Jul-2005  16:46  2000.80.2148.0      70,656  Sqlslic.cpl
   08-Jul-2005  01:43  2000.80.2148.0     616,960  Sqlsort.dll            IA-64
   08-Jul-2005  01:46                       5,814  Sqlsort.lib
   08-Jul-2005  17:12  2000.80.2148.0     963,072  Sqlspars.dll           IA-64
   08-Jul-2005  16:42  2000.80.2148.0      10,752  Sqlstbss.exe           IA-64
   08-Jul-2005  17:17                     822,510  Sqlstp.lib
   08-Jul-2005  17:10  2000.80.2148.0     699,392  Sqlsval.dll            IA-64
   08-Jul-2005  02:58  2000.80.2148.0     344,064  Sqlsvc.dll             IA-64
   08-Jul-2005  02:53  2000.80.2148.0     662,528  Sqlunirl.dll           IA-64
   08-Jul-2005  16:39  2000.80.2148.0     120,832  Sqlvdi.dll             IA-64
   08-Jul-2005  16:39  2000.80.2148.0     714,240  Sqlvdir.dll            IA-64
   08-Jul-2005  16:37  2000.80.2148.0     227,328  Sqsrvres.dll           IA-64
   08-Jul-2005  01:37  2000.80.2148.0      55,808  Ssmslpcn.dll           IA-64
   08-Jul-2005  16:39  2000.80.2148.0      62,976  Ssmsqlgc.dll           IA-64
   08-Jul-2005  03:05  2000.80.2148.0      57,344  Ssmssh70.dll           IA-64
   08-Jul-2005  01:38  2000.80.2148.0     259,584  Ssnetlib.dll           IA-64
   08-Jul-2005  16:21  2000.80.2148.0      23,040  Ssnmpn70.dll           IA-64
   08-Jul-2005  16:39  2000.80.2148.0      64,000  Ssradd.dll             IA-64
   08-Jul-2005  16:39  2000.80.2148.0      64,512  Ssravg.dll             IA-64
   08-Jul-2005  16:42  2000.80.2148.0      59,392  Ssrmax.dll             IA-64
   08-Jul-2005  16:41  2000.80.2148.0      58,880  Ssrmin.dll             IA-64
   08-Jul-2005  16:42  2000.80.2148.0     427,008  Svrnetcn.dll           IA-64
   08-Jul-2005  16:42  2000.80.2148.0     189,952  Svrnetcn.exe           IA-64
   08-Jul-2005  02:51  2000.80.2148.0     142,848  W95scm.dll             IA-64
   08-Jul-2005  02:55                       8,260  W95scm.lib
   08-Jul-2005  16:42  2000.80.2148.0     162,816  Xpadsi.exe             IA-64
   08-Jul-2005  01:39  2000.80.2148.0     125,952  Xplog70.dll            IA-64
   08-Jul-2005  16:44  2000.80.2148.0      97,792  Xpqueue.dll            IA-64
   08-Jul-2005  16:45  2000.80.2148.0     298,496  Xprepl.dll             IA-64
   08-Jul-2005  03:09  2000.80.2148.0     872,960  Xpstar.dll             IA-64
   08-Jul-2005  16:43  2000.80.2148.0     196,096  Xpweb70.dll            IA-64
   12-May-2005  00:44                   3,206,656  Overridepresp4qfe.msp
   12-May-2005  00:01                       1,214  Acatctr.h
   12-May-2005  00:01                       5,065  Acatctr.ini
   12-May-2005  00:01  9.107.8320.9        20,992  Athprxy.dll            IA-64
   12-May-2005  00:01  9.107.8320.9       434,176  Catutil.exe            IA-64
   12-May-2005  00:01                       1,868  Dsscntrs.h
   12-May-2005  00:01                      34,047  Dsscntrs.ini
   12-May-2005  00:01                       1,304  Enablecheckpoints.vbs
   12-May-2005  00:01  9.107.8320.9       414,208  Ftsqlpar.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       384,512  Gathercl.dll           IA-64
   12-May-2005  00:01                       3,193  Gsrvctr.h
   12-May-2005  00:01                      84,504  Gsrvctr.ini
   12-May-2005  00:01                       2,466  Gthrctr.h
   12-May-2005  00:01                      73,590  Gthrctr.ini
   12-May-2005  00:01                       4,799  Gthrlog.vbs
   12-May-2005  00:01                     745,916  Lcdetect.dat
   12-May-2005  00:01  9.107.8320.9        56,320  Lcdetect.dll           IA-64
   12-May-2005  00:01  9.107.8320.9         7,168  Mssadmin.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       169,472  Msscntrs.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       997,376  Mssdmn.exe             IA-64
   12-May-2005  00:01                         155  Mssdmn.exe.local
   12-May-2005  00:01  9.107.8320.9       471,552  Mssearch.exe           IA-64
   12-May-2005  00:01                       4,948  Mssearch.inf
   12-May-2005  00:01  9.107.8320.9       622,592  Msserror.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       192,000  Mssitlb.dll            IA-64
   12-May-2005  00:01  9.107.8320.9     2,748,416  Mssmmcsi.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       622,592  Mssmsg.dll             IA-64
   12-May-2005  00:01  9.107.8320.9     1,283,584  Mssmulpi.dll           IA-64
   12-May-2005  00:01  9.107.8320.9     1,157,632  Mssph.dll              IA-64
   12-May-2005  00:01  9.107.8320.9     6,831,616  Mssrch.dll             IA-64
   12-May-2005  00:01  9.107.8320.9       676,352  Msstools.dll           IA-64
   12-May-2005  00:01  9.107.8320.9        27,648  Mssws.dll              IA-64
   12-May-2005  00:01  9.107.8320.9       338,432  Nlhtml.dll             IA-64
   12-May-2005  00:01                       2,246  Nlindctr.h
   12-May-2005  00:01                      18,325  Nlindctr.ini
   12-May-2005  00:01                       1,696  Noise.chs
   12-May-2005  00:01                       1,696  Noise.cht
   12-May-2005  00:01                         741  Noise.dat
   12-May-2005  00:01                     149,848  Noise.deu
   12-May-2005  00:01                         751  Noise.eng
   12-May-2005  00:01                         751  Noise.enu
   12-May-2005  00:01                      19,684  Noise.esn
   12-May-2005  00:01                      49,196  Noise.fra
   12-May-2005  00:01                      19,618  Noise.ita
   12-May-2005  00:01                       2,060  Noise.jpn
   12-May-2005  00:01                       1,486  Noise.kor
   12-May-2005  00:01                      13,256  Noise.nld
   12-May-2005  00:01                      13,730  Noise.sve
   12-May-2005  00:01  9.107.8320.9       217,600  Objcreat.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       910,336  Propdefs.dll           IA-64
   12-May-2005  00:01  9.107.8320.9       404,992  Pstoreutl.exe          IA-64
   12-May-2005  00:01  9.107.8320.9        46,080  Query9x.dll            IA-64
   12-May-2005  00:01  9.107.8320.9       599,552  Searchstp.exe          IA-64
   12-May-2005  00:01                         845  Settemppath.vbs
   12-May-2005  00:01  9.107.8320.9       971,264  Srchadm.dll            IA-64
   12-May-2005  00:01                      29,696  Srchadm.msc
   12-May-2005  00:01  9.107.8320.9     2,375,680  Srchidx.dll            IA-64
   12-May-2005  00:01                     238,172  Sssadmin.vbs
   12-May-2005  00:01  9.107.8320.9     6,146,560  Tquery.dll             IA-64
   12-May-2005  00:01                         536  Tschs.xml
   12-May-2005  00:01                         536  Tscht.xml
   12-May-2005  00:01                         536  Tsdut.xml
   12-May-2005  00:01                         536  Tseng.xml
   12-May-2005  00:01                         536  Tsenu.xml
   12-May-2005  00:01                         536  Tsfra.xml
   12-May-2005  00:01                         536  Tsger.xml
   12-May-2005  00:01                         536  Tsita.xml
   12-May-2005  00:01                         536  Tsjap.xml
   12-May-2005  00:01                         536  Tskor.xml
   12-May-2005  00:01                         536  Tsneu.xml
   12-May-2005  00:01                         810  Tsschema.xml
   12-May-2005  00:01                         536  Tsspa.xml
   12-May-2005  00:01                         536  Tsswe.xml
   08-Jul-2005  16:24  2000.80.2148.0       3,584  Atxcore.rll
   12-May-2005  00:00  2000.85.1016.0      12,288  Bcp.rll
   12-May-2005  00:02  10.0.2619.0         42,056  Dwintl.dll             IA-64
   08-Jul-2005  16:26  8.0.2148.0         201,728  Msolap80.rll
   12-May-2005  00:01  1.0.1045.0          49,336  Msxmlsql.rll
   08-Jul-2005  16:33  2000.80.2148.0     146,432  Replres.rll
   08-Jul-2005  01:40  2000.80.2148.0      34,816  Sqlevn70.rll
   08-Jul-2005  16:39  2000.80.2148.0       4,608  Sqlisapi.rll
   08-Jul-2005  16:45  2000.80.2148.0       2,560  Sqlstbss.rll
   08-Jul-2005  16:42  2000.80.2148.0      61,440  Sqlvdir.rll
   08-Jul-2005  01:42  2000.80.2148.0       6,144  Xplog70.rll

Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

For more information about the naming schema for Microsoft SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:

822499 (http://support.microsoft.com/kb/822499/ ) New naming schema for Microsoft SQL Server software update packages

For more information about the terminology that Microsoft uses when Microsoft corrects software after the software is released, click the following article number to view the article in the Microsoft Knowledge Base:

824684 (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

Back to the top

APPLIES TO

Microsoft SQL Server 2000 Enterprise Edition 64-bit
Microsoft SQL Server 2000 Desktop Engine (Windows)
Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Personal Edition
Microsoft SQL Server 2000 Standard Edition

Back to the top

kbautohotfix kbhotfixserver kbbug kbfix kbqfe KB903086

Back to the top

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

Related Support Centers

SQL Server 2000

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Help and Support

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

On This Page

SUMMARY

SYMPTOMS

CAUSE

RESOLUTION

Hotfix information

Prerequisites

Restart information

Registry information

Hotfix file information

SQL Server 2000 32-bit versions

SQL Server 2000 64-bit version

STATUS

MORE INFORMATION

APPLIES TO

Keywords:

Get Help Now

Article Translations

Related Support Centers

Page Tools

Get Help Now