SQL 2008 SP2

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  July 6, 2011 at 8:23 am

  #243697

  ok guys. pre service pack i run (dev env)

  select @@ version =

  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) (VM)

  i run the sp 2 -

  summary.text says:

  Description: SQL Server Database Services 2008

  SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}

  ProductName: SQL2008

  Type: RTM

  Version: 10

  SPLevel: 2

  KBArticle: KB2285068

  KBArticleHyperlink: http://support.microsoft.com/?kbid=2285068

  PatchType: SP

  AssociateHotfixBuild: 0

  Platform: x86

  PatchLevel: 10.2.4000.0

  ProductVersion: 10.0.1600.22

  SELECT @@VERSION still says

  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) (VM)

  my query is, shouldnt the @@version show something like

  Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) (VM)

  confused.:unsure:

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 6, 2011 at 1:54 pm

  #1349277

  Looks to me like you tried to apply th x86 version of SP2 to an x64 instance.