SP4

I've got about four production 2000 servers still on SP2.  We've done some
preliminary testing with SP4 on our dev environment and SP4 seems to be
having no problems.  But I've read a number of posts about problems with SP4
.
Is SP4 having some problems like the ill-fated SP3?  Is there going to be a
SP4a?

CLM wrote:

> I've got about four production 2000 servers still on SP2.  We've done some
> preliminary testing with SP4 on our dev environment and SP4 seems to be
> having no problems.  But I've read a number of posts about problems with S
P4.
>  Is SP4 having some problems like the ill-fated SP3?  Is there going to be
 a
> SP4a?

No SP4a but there are some fixes post-SP4 so take a look at:

http://www.aspfaq.com/sql2000builds.asp

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--