Are there any patches are updates for SQL Server 2000 that are NOT included
in service pack 3a? I have a customer thinking that additional sql server
patches are required on a server but I don't believe that there are any that
are not already included in 3a which this server has.
Thanks.
MichelleI found this from July 2003:
http://www.microsoft.com/technet/se...n/MS03-031.mspx
I think that's everything.
"michelle" <michelle@.nospam.com> wrote in message
news:OL$aOsN9EHA.4004@.tk2msftngp13.phx.gbl...
> Are there any patches are updates for SQL Server 2000 that are NOT
included
> in service pack 3a? I have a customer thinking that additional sql server
> patches are required on a server but I don't believe that there are any
that
> are not already included in 3a which this server has.
> Thanks.
> Michelle
>|||Michelle,
SP4 is just going into beta. See
http://support.microsoft.com/defaul...kb;en-us;888799 for fixes
included.
Chris Wood
"michelle" <michelle@.nospam.com> wrote in message
news:%23bXn8UO9EHA.1292@.TK2MSFTNGP10.phx.gbl...
> I found this from July 2003:
> http://www.microsoft.com/technet/se...n/MS03-031.mspx
> I think that's everything.
> "michelle" <michelle@.nospam.com> wrote in message
> news:OL$aOsN9EHA.4004@.tk2msftngp13.phx.gbl...
> included
server[vbcol=seagreen]
> that
>sql
Showing posts with label patches. Show all posts
Showing posts with label patches. Show all posts
Friday, March 23, 2012
Tuesday, March 20, 2012
POST SP3 Problems
Fresh install of Win2K Server with all the latest Services Packs and Patches.
Fresh Install of SQL Servers 2000
Everything works OK
Install SP3
SQL Services Manager runs for 1 second and closes
Running New SQL Server Registration Wizard in Enterprise Manger, after hitting Next on the first screen Enterprise Manager goes poof and closes
DR. Watson Error:
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 2/14/2003
Time: 8:38:37 AM
User: N/A
Computer: CRUISE03
Description:
The application, mmc.exe, generated an application error The error occurred on 02/14/2003 @. 08:38:37.458 The exception generated was c0000005 at address 780011CD (wcslen)
Has anyone else experienced this error, or know how I can correct it?I have experienced a different error (possibly related)
Windows 2K box
SQL 2K sp2
Add SQL SP3
SQL Server process crashes on any extended stored procedure execution. Some DBCC commands (checkdb but not showcontig) also crash the server process.
I talked to Microsoft about it, and it seems that there is one MDAC hotfix that will report a successful installation no matter what. Out of 4 machines, I only had one go bad, but I still have 30 to go...
The fix in my case was as follows:
1) run C:\SQL2KSP3\x86\other\sqlredis.exe /t:C:\Extract /c
2) run C:\Extract\mdac_qfe.exe
2a) reboot.
3) Re-run SQL SP3 setup
It fixed my particular problem, but I don't know if it will do anything to yours. Can you run extended stored procs in Query Analyzer?
~Matt|||Unfortunately this fix didn't work for me.
I don't having any stored procedures to test, this is a very simple setup for my new web server.
Fresh Install of SQL Servers 2000
Everything works OK
Install SP3
SQL Services Manager runs for 1 second and closes
Running New SQL Server Registration Wizard in Enterprise Manger, after hitting Next on the first screen Enterprise Manager goes poof and closes
DR. Watson Error:
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 2/14/2003
Time: 8:38:37 AM
User: N/A
Computer: CRUISE03
Description:
The application, mmc.exe, generated an application error The error occurred on 02/14/2003 @. 08:38:37.458 The exception generated was c0000005 at address 780011CD (wcslen)
Has anyone else experienced this error, or know how I can correct it?I have experienced a different error (possibly related)
Windows 2K box
SQL 2K sp2
Add SQL SP3
SQL Server process crashes on any extended stored procedure execution. Some DBCC commands (checkdb but not showcontig) also crash the server process.
I talked to Microsoft about it, and it seems that there is one MDAC hotfix that will report a successful installation no matter what. Out of 4 machines, I only had one go bad, but I still have 30 to go...
The fix in my case was as follows:
1) run C:\SQL2KSP3\x86\other\sqlredis.exe /t:C:\Extract /c
2) run C:\Extract\mdac_qfe.exe
2a) reboot.
3) Re-run SQL SP3 setup
It fixed my particular problem, but I don't know if it will do anything to yours. Can you run extended stored procs in Query Analyzer?
~Matt|||Unfortunately this fix didn't work for me.
I don't having any stored procedures to test, this is a very simple setup for my new web server.
Subscribe to:
Posts (Atom)