How to obtain help and support for this security update
For home users, no-charge support is available by calling 1-866-PCSAFETY in the United States and Canada or by contacting your local Microsoft subsidiary. For more information about how to contact your local Microsoft subsidiary for support issues with security updates, visit the Microsoft International Support Web site:
North American customers can also obtain instant access to unlimited no-charge e-mail support or to unlimited individual chat support by visiting the following Microsoft Web site:
The following table lists the known issues with this security update. If you have problems with this security update that are not addressed by these known issues, no-charge support is available for consumers by calling 1-866-PCSAFETY in the United States and Canada or by contacting your local Microsoft subsidiary. For more information about how to contact your local Microsoft subsidiary for security update support issues, visit the International Support Web site:
Enterprise customers can obtain support for security updates through their usual support contacts.
To use the table, look in the top two rows of the table. Locate the column of the appropriate Microsoft Knowledge Base article number for the update that corresponds to the version of Microsoft SQL Server that you are using. The rows that contain an "X" correspond to a Microsoft Knowledge Base article that describes a known issue for the version of SQL Server that you are using. Click the article numbers in the left column to view the article.
Collapse this tableExpand this table
KB948113
KB948110
KB948111
KB948109
KB948108
Article number
SQL Server 7.0: Apply if the build number is between 7.00.1063 and 7.00.1151
SQL Server 2000 GDR and MSDE 2000: Apply if the build number is between 8.00.2039 and 8.00.2049)
SQL Server 2000 QFE and MSDE 2000: Apply if the build number is between 8.00.2148 and 8.00.2272
SQL Server 2005 GDR: Apply if the build number is between 9.00.3042 and 9.00.3067
SQL Server 2005 QFE: Apply if the build number is between 9.00.3150 and 9.00.3230)
Microsoft Knowledge Base articles that describe the known issues with this security update
For more information about the known issues that are referenced in this table, click the following article numbers to view the articles in the Microsoft Knowledge Base:
957008
(http://support.microsoft.com/kb/957008/
)
SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109
953743
(http://support.microsoft.com/kb/953743/
)
Supported method for applying updates to SQL Server 7.0
953742
(http://support.microsoft.com/kb/953742/
)
SQL Server 2000 and MSDE 2000 installers stop dependent services
953741
(http://support.microsoft.com/kb/953741/
)
SQL Server 2005 installers stop dependent services
953740
(http://support.microsoft.com/kb/953740/
)
How to identify and enable disabled SQL Server instances in SQL Server 2000
953739
(http://support.microsoft.com/kb/953739/
)
SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state
Microsoft Knowledge Base articles that describe the individual packages for this security update
For more information about the individual packages for this security update, click the following article numbers to view the articles in the Microsoft Knowledge Base:
948108
(http://support.microsoft.com/kb/948108/
)
MS08-040: Description of the security update for SQL Server 2005 QFE: July 8, 2008
948109
(http://support.microsoft.com/kb/948109/
)
MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
948110
(http://support.microsoft.com/kb/948110/
)
MS08-040: Description of the security update for SQL Server 2000 GDR and MSDE 2000: July 8, 2008
948111
(http://support.microsoft.com/kb/948111/
)
MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000: July 8, 2008
948113
(http://support.microsoft.com/kb/948113/
)
MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008
If the installation is not completed successfully, services that depend on the SQL Server service could be stopped. A restart is recommended to make sure that all services are in the correct state.
For more information about this security update and for information about any known issues with specific releases of this software, click the following article numbers to view the articles in the Microsoft Knowledge Base:
953742
(http://support.microsoft.com/kb/953742/
)
SQL Server 2000 and MSDE 2000 installers stop dependent services
953741
(http://support.microsoft.com/kb/953741/
)
SQL Server 2005 installers stop dependent services
How to determine whether SQL Server was successfully updated
To verify that SQL Server was successfully updated, follow these steps:
Find the version number of the instance or the instances of SQL Server.
For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:
321185
(http://support.microsoft.com/kb/321185/
)
How to identify your SQL Server version and edition
The SQL Server update is successful if the query analyzer returns a version of the Sqlserver.exe file that is listed in the following table.
Collapse this tableExpand this table
Product
Version
SQL Server 2005 GDR
9.00.3068
SQL Server 2005 QFE
9.00.3233
SQL Server 2000 GDR
8.00.2050
SQL Server 2000 QFE
8.00.2273
SQL Server 7.0
7.00.1152
Alternatively, you can review the installation log for a "Success" message. The installation log file is typically in one of the following folders.
The English (United States) version of this security update 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 item in Control Panel.
GDR packages
For all supported 32-bit editions of SQL Server 2000 Service Pack 4
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Updatelauncher.exe
5.2.3790.1288
8,704
25-May-2008
21:45
x86
Spupdsvc.exe
6.2.29.0
25,824
26-Dec-2007
02:26
x64
Osql.exe
2000.80.2050.0
57,344
25-May-2008
21:44
x86
Replmerg.exe
2000.80.2050.0
163,840
25-May-2008
21:44
x86
Replrec.dll
2000.80.2050.0
315,392
25-May-2008
21:44
x86
Sqlservr.exe
2000.80.2050.0
9,154,560
25-May-2008
21:44
x86
Osql.exe
2000.80.2039.0
57,344
25-May-2008
21:45
x86
Sqlbootldr.exe
1.4.1535.0
32,768
25-May-2008
21:45
x86
Sqlstpcustomdll.dll
1.4.1535.0
3,336,192
22-May-2008
21:57
x64
Spupdsvc.exe
6.2.29.0
22,752
26-Dec-2007
02:26
x86
Sqlstpcustomdll.dll
1.4.1535.0
2,316,288
25-May-2008
21:45
x86
For all supported Itanium-based editions of SQL Server 2000 Service Pack 4
Collapse this tableExpand this table
File Name
File Version
File size
Date
Time
Platform
impprov.dll
2000.80.2050.0
244224
3/8/2008
14:23
IA64
MSGPROX.dll
2000.80.2050.0
188928
3/8/2008
14:22
IA64
ODSOLE70.dll
2000.80.2050.0
151040
3/8/2008
14:23
IA64
OSQL.EXE
2000.80.2050.0
149504
3/8/2008
12:40
IA64
PFCLNT80.dll
2000.80.2050.0
1187328
3/8/2008
14:31
IA64
qrdrsvc.exe
2000.80.2050.0
356864
3/8/2008
14:35
IA64
replmerg.exe
2000.80.2050.0
375296
3/8/2008
12:41
IA64
REPLPROV.dll
2000.80.2050.0
537600
3/8/2008
14:22
ia64
replrec.dll
2000.80.2050.0
775168
3/8/2008
12:40
ia64
REPLSUB.dll
2000.80.2050.0
641024
3/8/2008
14:22
ia64
rinitcom.dll
2000.80.2050.0
654848
3/8/2008
14:22
ia64
semmap.DLL
2000.80.2050.0
161280
3/8/2008
14:21
ia64
snapshot.exe
2000.80.2050.0
91136
3/8/2008
14:22
ia64
sqlagent.EXE
2000.80.2050.0
1061376
3/8/2008
14:33
ia64
sqldiag.exe
2000.80.2050.0
334848
3/8/2008
14:24
x86
SQLDMO.dll
2000.80.2050.0
13860352
3/8/2008
14:34
ia64
sqlservr.exe
2000.80.2050.0
24925184
3/8/2008
12:40
ia64
sqlvdi.dll
2000.85.2101.0
338944
3/8/2008
14:31
ia64
SVRNETCN.dll
2000.80.2050.0
427008
3/8/2008
14:20
ia64
xpstar.DLL
2000.80.2050.0
872960
3/8/2008
14:23
ia64
For all supported editions of SQL Server 2000 Desktop Engine (WMSDE)
Collapse this tableExpand this table
File name
File version
Date
Time
File size
Atl71.dll
7.10.3077.0
30-Nov-2004
02:05
89,088
Dbmslpcn.dll
2000.80.2039.0
04-May-2005
14:02
20,480
Dbmsshrn.dll
2000.80.2039.0
04-May-2005
14:02
21,504
Msvcp71.dll
7.10.3077.0
30-Nov-2004
02:05
499,712
Msvcr71.dll
7.10.3052.4
30-Nov-2004
02:05
348,160
Distrib.exe
2000.80.2039.0
04-May-2005
11:36
61,440
Impprov.dll
2000.80.2050.0
08-Mar-2008
02:03
102,400
Mergetxt.dll
2000.80.2039.0
04-May-2005
14:06
39,656
Msgprox.dll
2000.80.2050.0
08-Mar-2008
01:56
94,208
Rdistcom.dll
2000.80.2039.0
04-May-2005
14:02
425,984
Replagnt.dll
2000.80.2039.0
04-May-2005
14:02
8,192
Repldist.dll
2000.80.2039.0
04-May-2005
14:02
77,824
Repldp.dll
2000.80.2039.0
04-May-2005
14:02
94,208
Repldsui.dll
2000.80.2039.0
04-May-2005
14:02
22,016
Repldts.dll
2000.80.2039.0
04-May-2005
14:02
94,208
Replerrx.dll
2000.80.2039.0
04-May-2005
14:06
101,096
Replmerg.exe
2000.80.2050.0
08-Mar-2008
03:28
163,840
Replprov.dll
2000.80.2050.0
08-Mar-2008
03:29
237,568
Replprox.dll
2000.80.2039.0
04-May-2005
14:02
196,608
Replrec.dll
2000.80.2050.0
08-Mar-2008
10:29
315,392
Replsub.dll
2000.80.2050.0
08-Mar-2008
03:32
270,336
Replsync.dll
2000.80.2039.0
04-May-2005
14:02
110,592
Rinitcom.dll
2000.80.2050.0
08-Mar-2008
03:33
278,528
Snapshot.exe
2000.80.2050.0
08-Mar-2008
03:34
61,440
Spresolv.dll
2000.80.2039.0
04-May-2005
14:06
76,544
Sqldistx.dll
2000.80.2039.0
04-May-2005
14:06
170,744
Sqlinitx.dll
2000.80.2039.0
04-May-2005
14:06
142,064
Sqlmergx.dll
2000.80.2039.0
04-May-2005
14:06
178,920
Sqlresld.dll
2000.80.2039.0
04-May-2005
14:02
35,840
Ssradd.dll
2000.80.2039.0
04-May-2005
14:06
47,856
Ssravg.dll
2000.80.2039.0
04-May-2005
14:06
47,864
Ssrdown.dll
2000.80.2039.0
04-May-2005
14:06
24,312
Ssrmax.dll
2000.80.2039.0
04-May-2005
14:06
47,864
Ssrmin.dll
2000.80.2039.0
04-May-2005
14:06
47,864
Ssrpub.dll
2000.80.2039.0
04-May-2005
14:06
24,832
Ssrup.dll
2000.80.2039.0
04-May-2005
14:06
24,824
Replres.rll
2000.80.2039.0
04-May-2005
14:02
159,744
Msxmlsql.dll
1.0.1045.0
07-Apr-2005
08:27
851,128
Msxmlsql.rll
1.0.1045.0
07-Apr-2005
08:27
50,360
Axscphst.dll
2000.80.2039.0
04-May-2005
14:02
61,440
Bcp.exe
2000.80.2039.0
04-May-2005
11:26
122,880
Cldtcstp.exe
2000.80.2039.0
04-May-2005
11:35
77,824
Cldtcstp.rll
2000.80.194.0
06-Aug-2000
15:06
28,672
Cnfgsvr.exe
2000.80.2039.0
04-May-2005
11:29
61,440
Cnvrem.dll
2000.80.2039.0
04-May-2005
11:28
94,208
Cnvsvc.exe
2000.80.2039.0
04-May-2005
11:23
61,440
Custtask.dll
2000.80.2039.0
04-May-2005
14:02
364,544
Dcomscm.exe
2000.80.2039.0
04-May-2005
11:29
11,776
Dtcsetup.exe
4.71.1015.0
16-Jul-1999
03:27
584,416
Dtsffile.dll
2000.80.2039.0
04-May-2005
14:02
126,976
Dtspkg.dll
2000.80.2039.0
04-May-2005
14:02
1,986,560
Dtspump.dll
2000.80.2039.0
04-May-2005
14:02
507,904
Dtsrun.exe
2000.80.2039.0
04-May-2005
11:42
33,792
Osql.exe
2000.80.2050.0
08-Mar-2008
02:05
57,344
Pfclnt80.dll
2000.80.2050.0
08-Mar-2008
01:59
430,080
Scm.exe
2000.80.2039.0
04-May-2005
11:52
86,016
Semmap.dll
2000.80.2050.0
08-Mar-2008
01:53
52,224
Semnt.dll
2000.80.2039.0
04-May-2005
14:02
69,632
Sqdedev.dll
2000.80.2039.0
04-May-2005
14:02
126,976
Sqladhlp.exe
2000.80.2039.0
04-May-2005
12:50
73,728
Sqldmo.dll
2000.80.2050.0
08-Mar-2008
03:27
4,362,240
Sqlmangr.exe
2000.80.2039.0
04-May-2005
12:07
81,920
Sqlredis.exe
5.0.2919.6304
04-May-2005
14:06
10,223,144
Sqlsvc.dll
2000.80.2039.0
04-May-2005
14:02
110,592
Sqlvdi.dll
2000.80.2050.0
08-Mar-2008
03:40
43,008
Svrnetcn.dll
2000.80.2050.0
08-Mar-2008
03:42
110,592
Svrnetcn.exe
2000.80.2039.0
04-May-2005
12:18
34,304
W95scm.dll
2000.80.2039.0
04-May-2005
14:02
41,984
Axscphst.rll
2000.80.194.0
06-Aug-2000
15:50
28,672
Bcp.rll
2000.80.2039.0
04-May-2005
14:02
9,216
Custtask.rll
2000.80.2039.0
04-May-2005
14:02
48,640
Dtsffile.rll
2000.80.194.0
06-Aug-2000
15:50
28,672
Dtspkg.rll
2000.80.2039.0
04-May-2005
14:02
208,896
Dtspump.rll
2000.80.194.0
06-Aug-2000
15:50
102,400
Dtsrun.rll
2000.80.194.0
06-Aug-2000
15:50
24,576
Pfclnt80.rll
2000.80.194.0
06-Aug-2000
15:50
28,672
Semmap.rll
2000.80.194.0
06-Aug-2000
15:50
32,768
Semnt.rll
2000.80.382.0
18-Apr-2001
13:21
12,288
Sqladevn.rll
2000.80.2039.0
04-May-2005
14:02
6,656
Sqldmo.rll
2000.80.2039.0
04-May-2005
14:02
585,728
Sqlmangr.rll
2000.80.194.0
06-Aug-2000
15:50
98,304
Sqlsvc.rll
2000.80.382.0
18-Apr-2001
13:21
12,288
Svrnetcn.rll
2000.80.2039.0
04-May-2005
14:02
16,896
Wn95scm.h
09-May-2001
15:08
1,341
W95scm.lib
04-May-2005
11:24
7,070
Atxcore.dll
2000.80.2039.0
04-May-2005
11:31
37,376
Cmdwrap.exe
2000.80.2039.0
04-May-2005
12:23
5,632
Comnevnt.dll
2000.80.194.0
26-Apr-2004
09:35
319,488
Dbghelp.dll
6.3.17.0
06-Aug-2004
06:38
940,032
Msdbi.dll
6.10.8226.0
26-Apr-1999
14:00
102,672
Mssql.mib
26-Apr-2004
09:46
26,740
Odsole70.dll
2000.80.2050.0
08-Mar-2008
02:04
69,632
Opends60.dll
2000.80.2039.0
04-May-2005
14:02
10,240
Sqlagent.dll
2000.80.2039.0
04-May-2005
14:02
12,288
Sqlagent.exe
2000.80.2050.0
08-Mar-2008
01:59
323,584
Sqlatxss.dll
2000.80.2039.0
04-May-2005
14:02
36,864
Sqlboot.dll
2000.80.2050.0
13-Mar-2008
23:01
140,312
Sqlcmdss.dll
2000.80.2039.0
04-May-2005
14:02
43,520
Sqlctr.h
09-May-2001
14:46
4,516
Sqlctr.ini
26-Apr-2004
09:37
19,984
Sqlctr80.dll
2000.80.2039.0
04-May-2005
14:02
40,960
Sqldata.dll
2000.80.2039.0
04-May-2005
14:02
815,104
Sqlimage.dll
5.0.2031.1
26-Apr-1999
14:00
36,112
Sqlmaint.exe
2000.80.2039.0
04-May-2005
12:07
167,936
Sqlrepss.dll
2000.80.2039.0
04-May-2005
14:02
65,536
Sqlservr.exe
2000.80.2050.0
08-Mar-2008
05:53
9,154,560
Sqlsnmp.dll
2000.80.2039.0
04-May-2005
14:02
53,760
Sqlsort.dll
2000.80.2050.0
08-Mar-2008
01:53
589,824
Sqlstbss.exe
2000.80.2039.0
04-May-2005
12:18
6,144
Ssmsad70.dll
2000.80.2039.0
04-May-2005
14:02
21,504
Ssmslpcn.dll
2000.80.2039.0
04-May-2005
14:02
18,432
Ssmsrp70.dll
2000.80.2039.0
04-May-2005
14:02
22,016
Ssmssh70.dll
2000.80.2039.0
04-May-2005
14:02
20,480
Ssmsvi70.dll
2000.80.194.0
06-Aug-2000
15:51
32,823
Ssnetlib.dll
2000.80.2039.0
04-May-2005
14:02
86,016
Ssnmpn70.dll
2000.80.2039.0
04-May-2005
14:02
10,240
Ums.dll
2000.80.2050.0
08-Mar-2008
05:49
35,328
W9xctrs.reg
14-Apr-2001
14:36
12,438
Xplog70.dll
2000.80.2039.0
04-May-2005
14:02
43,520
Xpqueue.dll
2000.80.2039.0
04-May-2005
14:02
45,056
Xprepl.dll
2000.80.2039.0
04-May-2005
14:02
155,648
Xpsqlbot.dll
2000.80.2039.0
04-May-2005
14:02
7,680
Xpstar.dll
2000.80.2050.0
08-Mar-2008
02:02
311,296
Atxcore.rll
2000.80.2039.0
04-May-2005
11:29
4,608
Odsole70.rll
2000.80.382.0
18-Apr-2001
13:21
20,480
Sqlagent.rll
2000.80.2039.0
04-May-2005
14:02
53,248
Sqlatxss.rll
2000.80.194.0
06-Aug-2000
15:50
24,576
Sqlcmdss.rll
2000.80.2039.0
04-May-2005
14:02
5,632
Sqlevn70.rll
2000.80.2050.0
08-Mar-2008
01:52
45,056
Sqlmaint.rll
18-Apr-2001
13:21
32,768
Sqlrepss.rll
2000.80.2039.0
04-May-2005
14:02
5,120
Sqlstbss.rll
2000.80.2039.0
04-May-2005
12:18
3,584
Xplog70.rll
2000.80.2039.0
04-May-2005
14:02
6,656
Xpstar.rll
2000.80.2039.0
04-May-2005
14:02
36,864
Master.mdf
04-May-2005
13:32
13,893,632
Mastlog.ldf
04-May-2005
13:32
524,288
Model.mdf
04-May-2005
13:32
655,360
Modellog.ldf
04-May-2005
13:32
524,288
Msdbdata.mdf
04-May-2005
13:31
3,145,728
Msdblog.ldf
04-May-2005
13:31
524,288
80sp1-tools.sql
14-Apr-2001
14:54
72,550
80sp2-tools.sql
04-Oct-2001
08:38
1,639
80sp3-tools.sql
21-Oct-2002
05:29
141,004
80sp4-tools.sql
26-Dec-2007
05:46
132,852
Ansiview.sql
05-Jul-2000
14:04
33,853
Instcat.sql
04-May-2005
12:35
956,866
Instdist.sql
26-Dec-2007
05:44
749,709
Instlang.sql
21-Oct-2002
05:18
36,298
Instls.sql
09-May-2001
15:05
52,628
Instmsdb.sql
22-Apr-2005
07:56
747,032
Messages.sql
19-Apr-2005
02:21
734,339
Odsole.sql
26-Apr-2004
09:37
1,873
Oledbsch.sql
05-Jul-2000
14:05
10,190
Procsyst.sql
26-Dec-2007
05:39
552,068
Replcom.sql
08-Mar-2008
01:54
1,214,694
Replmerg.sql
08-Mar-2008
10:35
1,151,444
Replsys.sql
26-Dec-2007
05:44
1,096,209
Repltran.sql
26-Dec-2007
05:44
999,165
Servmsgs.sql
04-May-2005
12:48
58,772
Sp1_repl.sql
24-Apr-2001
04:25
1,742,437
Sp1_serv_uni.sql
14-Apr-2001
14:36
140,748
Sp2_repl.sql
13-Oct-2001
10:36
674,264
Sp2_serv_uni.sql
04-Oct-2001
08:18
15,622
Sp3_repl.sql
05-Dec-2002
01:52
557,890
Sp3_replcom.sql
08-Mar-2008
01:54
1,214,694
Sp3_replmerg.sql
08-Mar-2008
10:35
1,151,444
Sp3_replsys.sql
26-Dec-2007
05:44
1,096,209
Sp3_repltran.sql
26-Dec-2007
05:44
999,165
Sp3_serv_uni.sql
19-Apr-2005
02:21
104,898
Sp4_serv_uni.sql
08-Mar-2008
01:40
156,802
Sqldmo.sql
04-May-2005
12:25
186,441
Sysmessages.sym
04-May-2005
13:32
731,156
Upgrade.sql
08-Jul-2004
07:49
387,712
U_tables.sql
25-Sep-2004
03:09
55,444
Web.sql
05-Jul-2000
14:17
16,324
Xpstar.sql
19-Apr-2005
02:21
73,114
Dbnetlib.dll
2000.85.1117.0
29-Apr-2004
00:00
106,496
Odbcbcp.dll
2000.85.1117.0
29-Apr-2004
00:01
24,576
Sqlsrv32.dll
2000.85.1117.0
29-Apr-2004
00:00
421,888
Sqlsrv32.rll
2000.85.1117.0
29-Apr-2004
00:00
90,112
Sqlunirl.dll
2000.80.2039.0
04-May-2005
14:02
192,512
For all supported 32-bit editions of SQL Server 2005 Service Pack 2
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Msmdsrv.exe
9.0.3068.0
14894608
26-Feb-08
22:08
x86
Microsoft.sqlserver.maintenanceplantasks.dll
9.0.3068.0
295952
26-Feb-08
22:08
x86
Msdtssrvr.exe
9.0.3068.0
205840
26-Feb-08
22:08
x86
Nsservice.exe
9.0.3068.0
21520
26-Feb-08
22:08
x86
Microsoft.reportingservices.diagnostics.dll
9.0.3068.0
799760
26-Feb-08
22:08
x86
Reportingservicesservice.exe
9.0.3068.0
16912
26-Feb-08
22:08
x86
Sqlaccess.dll
2005.90.3068.0
350224
26-Feb-08
22:08
x86
Sqlservr.exe
2005.90.3068.0
29183504
26-Feb-08
22:08
x86
Microsoft.sqlserver.maintenanceplantasksui.dll
9.0.3068.0
721936
26-Feb-08
22:08
x86
Sqlwb.exe
2005.90.3068.0
823824
26-Feb-08
22:08
x86
For all supported Itanium-based editions of SQL Server 2005 Service Pack 2