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.
SYMPTOMS
After you apply the hotfix that is described in Q825042 or
any other hotfix with SQL Server version 8.00.0840 or later, calls to the
xp_logininfo procedure may fail with error 8198 and you may receive an error
message that is similar to the following:
Error:
8198, Could not obtain information about Windows NT group/user
'domain\user'
If the application reports the state of the error, it
will typically be either state 31 or state 34.
A common symptom is for SQL Server Agent jobs to fail because the SQL Server
Agent uses the
xp_logininfo extended stored procedure to schedule
jobs.
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix information
The English
version of this hotfix has the file attributes (or later) 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.
Date Time Version Size File name
-----------------------------------------------------------------
31-May-2003 18:45 2000.80.818.0 78,400 Console.exe
28-Oct-2003 04:21 2000.80.873.0 315,968 Custtask.dll
30-Jan-2004 16:29 2000.80.911.0 33,340 Dbmslpcn.dll
25-Apr-2003 02:12 786,432 Distmdl.ldf
25-Apr-2003 02:12 2,359,296 Distmdl.mdf
30-Jan-2003 01:55 180 Drop_repl_hotfix.sql
12-Sep-2003 03:26 2000.80.859.0 1,905,216 Dtspkg.dll
26-Aug-2003 20:16 2000.80.854.0 528,960 Dtspump.dll
23-Jun-2003 22:40 2000.80.837.0 1,557,052 Dtsui.dll
23-Jun-2003 22:40 2000.80.837.0 639,552 Dtswiz.dll
24-Apr-2003 02:51 747,927 Instdist.sql
03-May-2003 01:56 1,581 Inst_repl_hotfix.sql
30-Jan-2004 16:29 2000.80.911.0 90,692 Msgprox.dll
01-Apr-2003 02:07 1,873 Odsole.sql
30-Jan-2004 16:29 2000.80.911.0 62,024 Odsole70.dll
30-Jan-2004 16:29 2000.80.911.0 25,144 Opends60.dll
30-Jan-2004 16:28 2000.80.911.0 57,904 Osql.exe
02-Apr-2003 23:15 2000.80.797.0 279,104 Pfutil80.dll
04-Aug-2003 18:17 550,780 Procsyst.sql
12-Sep-2003 00:37 12,305 Qfe469315.sql
22-May-2003 22:57 19,195 Qfe469571.sql
30-Jan-2004 01:16 1,090,380 Replmerg.sql
30-Jan-2004 16:29 2000.80.911.0 221,768 Replprov.dll
30-Jan-2004 16:29 2000.80.911.0 307,784 Replrec.dll
29-Jan-2004 23:24 2000.80.911.0 159,813 Replres.rll
06-Sep-2003 00:00 1,087,150 Replsys.sql
13-Aug-2003 16:28 986,603 Repltran.sql
30-Jan-2004 16:29 2000.80.911.0 287,304 Rinitcom.dll
30-Jan-2004 16:29 2000.80.911.0 57,916 Semnt.dll
29-Jul-2003 20:13 2000.80.819.0 492,096 Semobj.dll
31-May-2003 18:27 2000.80.818.0 172,032 Semobj.rll
02-Jan-2004 19:42 2000.80.904.0 53,832 Snapshot.exe
09-Dec-2003 20:07 117,834 Sp3_serv_uni.sql
05-Feb-2004 00:46 2000.80.913.0 28,672 Sqlagent.dll
05-Feb-2004 00:47 2000.80.913.0 311,872 Sqlagent.exe
19-Feb-2004 18:02 2000.80.916.0 168,001 Sqlakw32.dll
12-Mar-2004 04:34 2000.80.923.0 33,344 Sqlctr80.dll
30-Jan-2004 16:29 2000.80.911.0 4,215,360 Sqldmo.dll
07-Apr-2003 17:44 25,172 Sqldumper.exe
29-Jan-2004 23:17 2000.80.911.0 28,672 Sqlevn70.rll
05-Mar-2004 17:13 2000.80.922.0 180,792 Sqlmap70.dll
03-Sep-2003 02:56 2000.80.857.0 188,992 Sqlmmc.dll
02-Sep-2003 23:03 2000.80.857.0 479,232 Sqlmmc.rll
22-Oct-2003 00:08 2000.80.871.0 401,984 Sqlqry.dll
30-Jan-2004 16:29 2000.80.911.0 57,920 Sqlrepss.dll
12-Mar-2004 04:35 2000.80.923.0 7,618,641 Sqlservr.exe
30-Jan-2004 16:29 2000.80.911.0 590,396 Sqlsort.dll
30-Jan-2004 16:29 2000.80.911.0 45,644 Sqlvdi.dll
30-Jan-2004 16:29 2000.80.911.0 106,588 Sqsrvres.dll
30-Jan-2004 16:29 2000.80.911.0 33,340 Ssmslpcn.dll
30-Jan-2004 16:29 2000.80.911.0 82,492 Ssnetlib.dll
30-Jan-2004 16:29 2000.80.911.0 25,148 Ssnmpn70.dll
28-Oct-2003 04:21 2000.80.873.0 123,456 Stardds.dll
30-Jan-2004 16:29 2000.80.911.0 158,240 Svrnetcn.dll
30-Jan-2004 16:29 2000.80.911.0 76,416 Svrnetcn.exe
30-Apr-2003 23:52 2000.80.816.0 45,132 Ums.dll
30-Jan-2004 16:29 2000.80.911.0 98,872 Xpweb70.dll
Note Because of file dependencies, the most recent hotfix or feature
that contains these files may also contain additional files.