SQL Server 2005 SP4 available through Microsoft Update

Today (Jan 25th, 2011), Microsoft released SQL Server 2005 Service Pack 4 (SP4) to Microsoft Update. SP4 was made available on the download center back in December 2010.   The SP4 update for non-Express SQL Server editions (Developer, Enterprise, Standard, and so on) will be made available as an optional update. As an optional update,…

2

SQL Server Support on Windows XP x64

Recently, I have been getting several questions regarding whether SQL Server 2008 or SQL Server 2008 R2 is support on Windows XP x64. The simple answer is yes.  The confusion comes in around the service packs for Windows XP x64. If you search the internet for Windows XP x64 information, you will see several references…

1

SQL Server 2008 Service Pack (SP) 1 on Microsoft Update as a Required Automatic Update

[Update on September 4th, 2009] We are still discussing when to make SQL Server 2008 SP1 available through Automatic Update. At this time, it would be released through Automatic Update in September.  SQL Server 2008 SP1 started to be deployed through Microsoft Update on April 28th. We are now considering making the update available through Automatic Update…

2

Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1

[Updated on April 7th, along with the availability of SQL Server 2008 SP1] Today, I am going to show you how to create new source media that will slipstream the original source media and SQL Server 2008 Service Pack 1. Once you have created this drop, you can install SQL Server 2008 SP1 in a…

0

Creating a SQL Server 2008 Management Studio Express Slipstream drop

[Updated on 2/16/2010: Corrected an issue with step #6] In today’s blog I will show you have to create a drop of SQL Server 2008 Management Studio Express with Service Pack 1. Without these steps, you need to install the original release of Management Studio Express and then apply Service Pack 1. Once you run…

4

SQL Server 2008 Service Pack 1 on Microsoft Update

Starting on April 28th, service pack 1 for SQL Server 2008 will be posted to Microsoft Update. The update will patch any edition or whether the instance is clustered or a stand-alone instance. To obtain the update, you need must opt into Microsoft Update and manually scan for the update. The service pack will not…

2

SQL Server 2008 Service Pack 1 is Released!

The SQL Server 2008 Service Pack that can update any edition can be found here. The Express 2008 SP1 release can be found here. This service pack makes available Slipstream and SP uninstall.    The Slipstream functionality in Service Pack 1 There are 2 different procedures that allows you to patch the original SQL Server…

4

SQL Server 2008, basic slipstream steps

[Updated on April 7th, along with the availability of SQL Server 2008 SP1] Starting in SQL Server 2008 Service Pack 1, you can update the product using our "Slipstream" infrastructure.  Below, I have the basic steps for slipstreaming the original SQL Server 2008 with Service Pack 1. These steps are better for a single installation…

16

SQL Server 2008 Service Pack (SP) Uninstall

Starting in SQL Server 2008 SP1, uninstall will be supported.  When you install a Service Pack, an entry is added to Add or Remove Programs or Program and Features in Vista and above.  The uninstall wizard is launched through this entry.   Behaviors: Files restored to previous version, for example: You install SQL Server 2008…

4

SQL Server SP3 has compatibility issues on Vista and Windows 2008

SQL Server SP3 shipped with files that have known compatibility issues on Vista and Windows 2008. To resolve, it is suggested that you apply Visual Studio 2005 Service Pack 1, See http://support.microsoft.com/?kbid=960320 for more information.   If you obtain the SQL Server SP3 update through Microsoft Update when available, you may see a Windows dialog mentioning…

1