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)
I am 100% sure that everybody don’t know about this and will get benefit from your TIPS
What is common knowledge to some people is also going to be new to many others.
I certainly enjoy reading your short tips and would love to see more.
Meaning, Release to Manufacturing (RTM) to Service Pack 3 is okay?
sorry… just want to clarify things, im new in MS SQL…
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 ?
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.
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.
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.