837 patch and MS03-031

Hello
We're about to apply the MS03-031 security rollup patch to upgrade our 90
SQL Servers from SP3a (760) to (818).
Problem is we have applied a hotfix already to a couple of boxes which
ugraded SQL to version (837).
What will happen when we apply MS03-031 to these boxes with the hotfix? Will
it fail and if so whats the solution?
thank you
-- cranfield, DBA
Hi
It will run, but is clever enough not to run older scripts against the newer
build. It does binary file version checking so it won't overwrite newer
binaries.
Have you considered hotfix 878?
When I tried to run 818 against a 952 server, I got the following:
=== Version check on sqlservr.exe 8.0.952 shows different major build of
sqlservr.exe than hotfix build number 8.00.818
=== NOT RUNNING SCRIPTS
The build number of SQLSERVR.EXE and HotFix package did not match. This
happens
when SQLSERVR.EXE was not replaced because the version was higher than the
Hotfix build.
In these cases Hotfix will not run any scripts and return error code
ERROR_BAD_ENVIRONMENT
Error message: Error running SQL script. Please view the log file for details.
INSTALL FAILURE: Hotfix failed to apply the patches on instance MSSQLSERVER,
the error code returned was: 10
<EndFunc Name='DoSQLHotFix' Return='10' GetLastError='0'>
Regards
Mike
"cranfield" wrote:

> Hello
> We're about to apply the MS03-031 security rollup patch to upgrade our 90
> SQL Servers from SP3a (760) to (818).
> Problem is we have applied a hotfix already to a couple of boxes which
> ugraded SQL to version (837).
> What will happen when we apply MS03-031 to these boxes with the hotfix? Will
> it fail and if so whats the solution?
> thank you
> -- cranfield, DBA
|||Hi Mike
Why do you ask if I have considered hotfix 878? We applied the 837 hotfix i
an attempt to sort out some Exception errors we were having on our 4-node
cluster.
We're just looking at bringing up our servers to an accepted level and our
testers have only tested up to 818, MS02-031.
regards
Alan Cranfield
DBA Support
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> It will run, but is clever enough not to run older scripts against the newer
> build. It does binary file version checking so it won't overwrite newer
> binaries.
> Have you considered hotfix 878?
> When I tried to run 818 against a 952 server, I got the following:
> === Version check on sqlservr.exe 8.0.952 shows different major build of
> sqlservr.exe than hotfix build number 8.00.818
>
> === NOT RUNNING SCRIPTS
> The build number of SQLSERVR.EXE and HotFix package did not match. This
> happens
> when SQLSERVR.EXE was not replaced because the version was higher than the
> Hotfix build.
> In these cases Hotfix will not run any scripts and return error code
> ERROR_BAD_ENVIRONMENT
> Error message: Error running SQL script. Please view the log file for details.
> INSTALL FAILURE: Hotfix failed to apply the patches on instance MSSQLSERVER,
> the error code returned was: 10
> <EndFunc Name='DoSQLHotFix' Return='10' GetLastError='0'>
> Regards
> Mike
> "cranfield" wrote:
|||Hi
878 is the highest publicly available hotfix, that is fully supported by PSS.
We encountered quite a few problems with hotfixes in the 820 to 850 range,
and those issues were fixed after 850.
(regression bugs etc)
Regards
Mike
"Cranfield" wrote:
[vbcol=seagreen]
> Hi Mike
> Why do you ask if I have considered hotfix 878? We applied the 837 hotfix i
> an attempt to sort out some Exception errors we were having on our 4-node
> cluster.
> We're just looking at bringing up our servers to an accepted level and our
> testers have only tested up to 818, MS02-031.
> regards
> Alan Cranfield
> DBA Support
> "Mike Epprecht (SQL MVP)" wrote:
|||I suspect applying MS03-031 to the servers that are already at
8.00.837 will do nothing - it shouldn't overwrite files with
earlier versions, and you can compare the file information in the KB
article http://support.microsoft.com/kb/821277 with what's on your
servers.
Is there a reason you think MS03-31 contains something that is
not already installed as part of the 837 hotfix on the hotfixed boxes?
Usually these things are cumulative, and especially since 818 was a
security issue, I'd be surprised if MSFT gave out something numbered
8.00.837 that didn't fix prior security issues.
Steve Kass
Drew University
cranfield wrote:

>Hello
>We're about to apply the MS03-031 security rollup patch to upgrade our 90
>SQL Servers from SP3a (760) to (818).
>Problem is we have applied a hotfix already to a couple of boxes which
>ugraded SQL to version (837).
>What will happen when we apply MS03-031 to these boxes with the hotfix? Will
>it fail and if so whats the solution?
>thank you
>-- cranfield, DBA
>
|||This is exactly what i want to know. Can I safely assume that I don't have to
patch the 837 servers as they will already be up to 818 level?
thanks
alan
"Steve Kass" wrote:

> I suspect applying MS03-031 to the servers that are already at
> 8.00.837 will do nothing - it shouldn't overwrite files with
> earlier versions, and you can compare the file information in the KB
> article http://support.microsoft.com/kb/821277 with what's on your
> servers.
> Is there a reason you think MS03-31 contains something that is
> not already installed as part of the 837 hotfix on the hotfixed boxes?
> Usually these things are cumulative, and especially since 818 was a
> security issue, I'd be surprised if MSFT gave out something numbered
> 8.00.837 that didn't fix prior security issues.
> Steve Kass
> Drew University
> cranfield wrote:
>