locked
SQL Server 2012 Express Service Pack 1 RRS feed

  • Question

  • I have SQL Server 2012 Express (64 bit) installed on my Windows 7 Pro machine.... 

    Two questions:
    1. How do I check if the Service Pack 1 for SQL Server is installed or not, and
    2. If it is not, where do I download it? I downloaded it from here: http://www.microsoft.com/en-za/download/details.aspx?id=35579 and selected the SQLEXPRADV_x64_ENU.exe file (because that is the version I have), but when I run it, it wants to install a new instance of SQL Server, or upgrade from SQL Server 2005 and 2008. Does this mean that I already have Service Pack 1 installed?

    Thank you...


    Fabricio Rodriguez Pretoria, South Africa

    Tuesday, November 27, 2012 3:12 PM

Answers

  • Hello Fabricio,

    You can find the download for the service pack here: http://www.microsoft.com/en-us/download/details.aspx?id=35575

    You'll want to choose one of the last two items as just the SP1 download for either x64 or x86 depending on what architecture you installed (x86=32 bit, x64=64 bit).

    You can check what version and service pack you're currently on by running the following:

    select SERVERPROPERTY('ProductVersion') AS [Full_Version_Number], SERVERPROPERTY('ProductLevel') AS [Service_Pack_Level]

    -Sean


    Sean Gallardy | Blog | Twitter

    • Proposed as answer by Olaf HelperMVP Tuesday, November 27, 2012 6:13 PM
    • Marked as answer by Shulei Chen Tuesday, December 4, 2012 9:22 AM
    Tuesday, November 27, 2012 3:33 PM
  • For #1, run "SELECT @@VERSION" to determine the version number.  If it is not 11.0.3000.00, then you don't have SP1 applied.

    For #2, the link you supplied is to install Express with SP1 in a single installation.  Since you already have SQL Server 2012 Express installed, you can install SP1 from http://www.microsoft.com/en-za/download/details.aspx?id=35575   You'll want either SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x32-ENU.exe depending on the architecture (32-bit of 64-bit) installed for your existing Express instance.

    Thanks,
    Sam Lester (MSFT)


    My Blog

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Olaf HelperMVP Tuesday, November 27, 2012 6:13 PM
    • Marked as answer by Fabs1977 Wednesday, November 28, 2012 9:18 AM
    Tuesday, November 27, 2012 3:31 PM

All replies

  • For #1, run "SELECT @@VERSION" to determine the version number.  If it is not 11.0.3000.00, then you don't have SP1 applied.

    For #2, the link you supplied is to install Express with SP1 in a single installation.  Since you already have SQL Server 2012 Express installed, you can install SP1 from http://www.microsoft.com/en-za/download/details.aspx?id=35575   You'll want either SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x32-ENU.exe depending on the architecture (32-bit of 64-bit) installed for your existing Express instance.

    Thanks,
    Sam Lester (MSFT)


    My Blog

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Olaf HelperMVP Tuesday, November 27, 2012 6:13 PM
    • Marked as answer by Fabs1977 Wednesday, November 28, 2012 9:18 AM
    Tuesday, November 27, 2012 3:31 PM
  • Hello Fabricio,

    You can find the download for the service pack here: http://www.microsoft.com/en-us/download/details.aspx?id=35575

    You'll want to choose one of the last two items as just the SP1 download for either x64 or x86 depending on what architecture you installed (x86=32 bit, x64=64 bit).

    You can check what version and service pack you're currently on by running the following:

    select SERVERPROPERTY('ProductVersion') AS [Full_Version_Number], SERVERPROPERTY('ProductLevel') AS [Service_Pack_Level]

    -Sean


    Sean Gallardy | Blog | Twitter

    • Proposed as answer by Olaf HelperMVP Tuesday, November 27, 2012 6:13 PM
    • Marked as answer by Shulei Chen Tuesday, December 4, 2012 9:22 AM
    Tuesday, November 27, 2012 3:33 PM
  • Thanks Samuel

    Fabricio Rodriguez Pretoria, South Africa

    Wednesday, November 28, 2012 9:18 AM
  • Thanks Sean

    Fabricio Rodriguez Pretoria, South Africa

    Wednesday, November 28, 2012 9:18 AM