| Author |
Topic |
|
tkizer
Almighty SQL Goddess
38200 Posts |
 Posted - 2003-05-23 : 15:53:21
|
| I wonder if sp3a fixes any of the problems that sp3 has. We've contacted our MS rep about this, and I'll let you know what she says once we find out.Here's the info:[url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url]Tara |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-23 : 16:14:27
|
I would like to think that it does, but I find this quote strange if that is the case:quote:
If you have applied SP3, you do not need to apply SP3a. SP3a is only for SQL Server users who have not applied any versions of SP3. However, you should use SP3a rather than SP3 moving forward.
-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-23 : 16:18:11
|
| Yeah I foudn that strange too. That's why I am going to wait to hear from our MS rep. Hopefully the news is good. If not, then we'll just stick with sp2 + cumulative security patches.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-05-23 : 17:37:17
|
| One must wonder if 3 is the same as 3a, why is there a 3a?I've never installed 3 after all the horror stories I've read on the boards.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-23 : 17:42:21
|
quote:
...why is there a 3a?
From the above mentioned link:quote:
SQL Server 2000 SP3a:Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a enables service pack upgrades for trial software. In the past, service packs have not been applicable to trial software. Includes a new version of Microsoft Data Access Components (MDAC) version 2.71a. This version fixes the installation of MDAC files and a memory leak. These issues are addressed in articles 814572 and 814410 in the Microsoft Knowledge Base. Disables listening on port 1434 when networking is disabled. This provides further protection from "denial of service" attacks. This service pack includes the following files:...BenefitsIn addition to providing the latest updates and fixes, SQL Server 2000 SP3a includes the following benefits: Serviceability improvements include: Enhanced error reporting. SQL Server can be configured to have critical errors automatically sent to Microsoft. Improved multiserver administration. New diagnostic Transact-SQL function. Database administrators or third-party tools can use the new fn_get_sql function to help diagnose problem processes. PerformanceSP3a introduces support for QLogic’s VI-enabled SANblade QLA2350 Fibre Channel controller. The use of Virtual Interface technology in the SQL Server networking layer reduces CPU consumption per message on the server and client systems and improves performance. SecurityThe latest security features and tools include: Updates to SQL Server 2000 Books Online. SQL Server 2000 Books Online provides customers with guidance on how to make their environment more secure. Security patches. SP3a includes patches for known vulnerabilities reported by users or discovered through ongoing testing. SQL Server Agent enhancements. SP3a gives you the ability to run SQL Server Agent without having to be an administrator.
-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-23 : 19:14:05
|
| I heard some time ago that they were sp3 was to be re-released (can't remember where) - I guess 3a is it.sp3 came not too long after the worm hot fix. But I'm sure that was just a cooincidence and it was ready to release.As with all these things let other people rush into testing it before risking a production system.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-23 : 19:16:37
|
quote:
I heard some time ago that they were sp3 was to be re-released (can't remember where) - I guess 3a is it.
Well it was probably me that you heard it from. I mentioned it because that's what our MS rep had told us. We are trying to confirm if sp3a is the re-release of sp3 but without the problems. I'll let you know.Tara |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-05-27 : 14:38:37
|
| Any news on this front? I'm about to put a new server into production, and I'm debating between SP2+hotfixes and SP3a.Thanks-b |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-27 : 14:41:43
|
| I haven't heard anything from our MS rep yet.I'd wait on sp3a for a couple of months especially considering how important your database is (from your other post). There probably aren't too many servers out there that have sp3a running in production yet.Tara |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-05-27 : 16:12:31
|
Apart from set up fixes and a change for MSDE in terms of command line switches for the install, the most important bit is the fix for a memory leak in the ODBC driver quote:
Fixes specific to SP3a:814572 FIX: SQL Server Does Not Start and an Access Violation Occurs After You Install SQL Server 2000 Service Pack 3 814410 FIX - Performance Degradation and Memory Leak in the SQL Server ODBC Driver 814130 INF: How to Secure Network Connectivity for SQL Server 2000 Local Databases
[url]http://support.microsoft.com/?kbid=306908[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
SQL Server 2000 sp3a is out!