Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: Where did the SQL Server Instance disappear? The clue may be in the WMI logs!

    We recently worked with a customer who ran into an interesting situation. This problem deals with SQL Server 2005 Service Pack 3 setup. Normally, when you launch the SQL 2005 SP3 setup and you reach the screen which shows the components for which you can apply the service pack, you will get a list...
  • Blog Post: SSMS Fails to restore with SQL 2000 instances and SSMS Versioning Explained….

    I recently have been on vacation. When I returned I noticed an interesting issue that deserves some details and explanation in case you encounter the problem. As part of this explanation, I’ll give you some information about how the “version” of SQL Server Management Studio is determined. A problem was...
  • Blog Post: SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

    Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3.  The problem can happen for any SQL Server 2000...
  • Blog Post: SQL Server Setup prompts with “The installed product does not match the installation source(s).” (Part I)

    Recently I looked at an issue when upgrading from SQL Server 2005 to SQL Server 2008 and in the middle of the upgrade it would halt asking for a matching source for VSS Writer.  However, there is nothing descriptive to tell you what specific source it is that you need to choose to find the right...
  • Blog Post: Trying to keep up with Version Numbers….

    Updated. See information at the bottom of the post I can’t begin to tell you how many times I find myself seeing a version number for SQL Server and not knowing exactly what service pack or cumulative update the build belongs to without quite a bit of pain. I have to admit years ago (ok how about a decade...
  • Blog Post: SQL Server 2008 SP1 and Cumulative Updates Explained.....

    NOTE: I've made a change to this blog post to account for the fact that actually 6 fixes in CU4 for 2008 RTM fixes DID made it into 2008 SP1. One of our readers sent me the following questions I think you will find valuable when understanding our recently posted SQL Server 2008 Service Pack 1 and our...
  • Blog Post: How to fix your SQL Server 2008 Setup before you run setup (Part II)....

    NOTE: Now updated for SQL Server 2008 SP1 RTM. Last year you might have read my post where I showed you how to patch setup for RTM for SQL Server 2008 before you launch setup . This processing involved installing a Cumulative Update to apply fixes for the SQL Server 2008 Setup Support Files. Well, we...
  • Blog Post: Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)

    Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds. An application that uses the Sxs.dll file crashes when you run the application on a Windows XP-based...
  • Blog Post: How to fix your SQL Server 2008 Setup before you run setup...

    Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place? This would include a new installation, upgrade, or...
  • Blog Post: Welcome to SQL Server 2008 Patching

    We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005 patch installations. The first thing I did was download...
  • Blog Post: SQL Server 2005 SP3 and Self-Service Hotfixes

    If you have not seen or heard the news, we have announced our plans to release a service pack for SQL Server 2005. If you want to read more about the announcement, look at this blog post http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx We are...
Page 1 of 1 (11 items)