December 7, 2009 at 9:07 pm
hi, is it ok to update my MS sql server 2000 server with the latest patch? Will it not cause any problem with the applications connected to it? Where can i download the latest patch for sql server 2000. Many thanks.
Dominic
December 7, 2009 at 9:15 pm
You need to search Microsoft for the latest patches for your product.
Regarding the assurance that nothing will happen and your applications will not have any issues, that promise cannot be given by any one as you are the one in charge of your application and how it is using and what changes in SQL 2000 that are made with the patch you are installing is know to you.
If you are not sure of the application if it would work or not, then as usual, like every other SQL Server implementation, set up a Test environment and apply the patch, test your application and plan for patching the Production machine.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 9:32 pm
Test it, test it, test it..
There is no way to tell whether there will be a problem with your particular implementation.
However, I wouldn't apply hotfixes unless you are actually experiencing the problem they are designed to fix. Apply the latest SP which you should be able to get from:
http://support.microsoft.com/kb/290211
CEWII
December 7, 2009 at 10:12 pm
Hi, do I have to install the latest patch? I believe it's sp 4 for sql server 2000 or do i need to install the older patches? Like install service pack 1 first followed by service pack2 up to sp4 ... Thanks
December 7, 2009 at 10:51 pm
Service packs are cumulative so just install SP4 and all the changes from sp1-sp4 will be applied.. Just run the EXE file you get from MS..
CEWII
December 7, 2009 at 10:56 pm
Ok, Thanks a lot.
December 7, 2009 at 10:59 pm
You are very welcome..
CEWII
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply