SQL SERVER – Order of Hotfix and Service Pack

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 (http://blog.SQLAuthority.com)

7 thoughts on “SQL SERVER – Order of Hotfix and Service Pack

  1. hello,

    I have a confusion on IDENTITY column. I read it in a book that DEFAULT constraint can not be created on IDENTITY column.

    While, I found a situation from internet is the following:

    We have a table and it has just one column that the identity property of that column set to ON, we need a query to insert some records in that.

    Ans: INSERT INTO TableName DEFAULT VALUES

    My question is that, if default values can not be created on identity column then how can default values be inserted into identity column ?

    Like

  2. @barnali chhotaray

    DEFAULT means different things. For an IDENTITY COLUMN, the IDENTITY attribute populates the COLUMN. DEFAULT also populates the COLUMN. Therefore, it would be in conflict with the IDENITY attribute. Only one thing can provide the value!

    DEFAULT VALUES in a statement, tells SQL Server that the query will not provide any values for the COLUMNs. Which is fine for an IDENTITY, as it will populate that COLUMN anyway.

    Like

  3. Hi Pinal Dave,

    I was wondering if you know how to script the installment of service packs on SQL 2005.

    I have to install a bunch of new servers with SQL and I used the template.ini to configure a install script with options to install SQL server.
    Now to use the GUI to install about 40 servers is going to be a pain in the … So if you or anybody else reading this could give me a clue on how to do that. It ‘ll be much appreciated.

    Like

  4. Dear Pinal,
    I need you help. I have learned that in sql 2005 you can easily uninstall SP just by replacing the resource database of old buld. I have tried that but it didnt worked out. Can you please illustrate us how to uninstall SP in sql 2005 with the help of resource database.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s