Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installed sp4 to SQL Server Express 2005 but @@version shows Build 2600 Server Pack 3. Expand / Collapse
Author
Message
Posted Tuesday, March 29, 2011 10:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:55 AM
Points: 162, Visits: 1,046
I have MSSQL 2005 Express Edition installed on my Windows XP sp3 computer.

I just installed MSSQL 2005 Express Edition sp4 but when I run @@version I get the following:

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 20 2010 Coyright (c) 1988-205 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600 Service Pack 3).

I believe that 9.00.5000.00 is 2005sp4RTM but I am wondering why it shows "(Build 2600 Service Pack 3)" when it should be Service Pack 4.

I am not certain if everything is okay or not.

Any information on this would be appreciated.

Thanks

Howard



Post #1085701
Posted Tuesday, March 29, 2011 10:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 8:38 PM
Points: 908, Visits: 2,585
Check the installation log of the service pack and see if it shows any error messages.
shows what happen when you skim over something instead of reading it in detail!


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1085704
Posted Tuesday, March 29, 2011 10:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 3, 2014 2:23 AM
Points: 3,108, Visits: 11,503
"Build 2600 Service Pack 3" is for the Windows version, not the SQL Server version.

You can verify this by starting Notepad, selecting the Help menu, and selecting About Notepad.

Post #1085710
Posted Tuesday, March 29, 2011 10:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:55 AM
Points: 162, Visits: 1,046
Thanks to all for the fast response to my question.

It was extremely helpful.

I also came across the following t-sql that displays "SQL Server 9.00.5000.00 - SP4 (Express Edition).

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

Howard



Post #1085725
Posted Sunday, June 19, 2011 11:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 8:20 AM
Points: 83, Visits: 741
OMG, I didn't realize that was referring to Windows and not SQL...UGH. I just reinstalled this thing 4 or 5 times and assumed I was doing something wrong because @@version kept showing "SP3". I feel like such an ID-10-T.
Post #1127863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse