Service pack | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Service pack

How can I find which is the latest Service Pack installed on my system for SQL Server. Thanks!
Fire a SELECT @@VERSION from Query Analyzer and compare the result to this list:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Frank
How can I analyse that I have to install a patch for my sql server?
If I observe that there is a patch left for me to install, what are the steps I need to follow to be current with my server? Thanks!
This is the return of the above statement on my machine
Microsoft SQL Server 2000 – 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) This is Service Pack 4 level according to the list in the link I’ve posted. If you determine a lower version number, just download Service Pack 4 from the MS site. The Service Packs are additive. Don’t know if this is the correct word, but SP4 contains all previous SP’s and hotfixes. So that you are then on a most current level. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Yeah Frank
even my machine return the same but I would like to know if in case I found that I have lower version, then am I just supposed to download the latest service pack online or do I need to follow any predefined steps to go through the installltion process. This is just to be proactive. Thanks!
When I googled for the infromation I found the following link.
http://www.windowsitpro.com/Article/ArticleID/14804/14804.html Does MS provide all the steps to follow along with service pack for installation or do we get that info from some third parties.
As I am new to these things and never installed any service pack before so thought of clarifying my doubts from our forum. Thanks!
I think there are no predefined guidelines for this. There are folks who apply the latest Service Pack directly after it is released and are happy. And then there are other folks who wait (or have to wait because of restrictions from third-party vendors) before they apply a Service Pack. While I have SP4 on my dev machine, I think all of our servers still run on SP3a. We have here some third-party apps and have to wait for the okay from the vendor in order to be still supported in case of an emergency. I would checkhttp://www.microsoft.com/sql/default.mspx once a week or so, to see if there is a new hotfix, patch or security bulletin available and then decide whether to apply that or not. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

I appreciate you for the information you have provided for me, its really worth to me. You are the guy replying for almost all of my threads.Thanks Frank. Thanks!
For every hotfix and service pack release there will be a README.HTM or Knowledge base article (KBA) file which helps you to understand what bugs have been fixed. It is recommended to keep in touch with the link provided SQLSecurity by Frank, one of my favourite and most visited link.<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Reddy</i><br /><br /><br />Does MS provide all the steps to follow along with service pack for installation or do we get that info from some third parties.<br /> As I am new to these things and never installed any service pack before so thought of clarifying my doubts from our forum.<br /><br />Thanks!<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />It is no wonder how Frank Kallis achieved MVP status within couple of years, it is a best achieved recognition from MS to the people that are helping community a lot.[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
]]>