On an average once a week I receive a question from my readers regarding what should be the sequence of hotfix and service pack. Not long ago, one of my regular readers who is using SQL Server 2000 asked me how can he improve the installation speed as he has to install 4 Service Packs to upgrade his server to SQL Server SP4 version. All these questions from my readers have prompted me to write down this small note. I hope this will clear some of the common doubts they have about this subject and they no longer would have to ponder over such issues
You do not need to install all Service Packs to upgrade your server version to the latest versions. Just install Latest Service Pack and Hotfix and you are done!
This might be the smallest tip I have given so far on my blog but I am just curious to know from you all if you already knew about the solution or came to know about it through my blog today. Based on your feedback, I will come up with small articles like this in future and solve your day-to-day queries.
All Microsoft Service Packs are listed here.
Reference : Pinal Dave (https://blog.sqlauthority.com)