SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installed sp4 to SQL Server Express 2005 but @@version shows Build 2600 Server Pack 3.


Installed sp4 to SQL Server Express 2005 but @@version shows Build 2600 Server Pack 3.

Author
Message
hmbtx
hmbtx
SSC Eights!
SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)

Group: General Forum Members
Points: 910 Visits: 1464
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



Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6175 Visits: 3537
Check the installation log of the service pack and see if it shows any error messages.
w00t shows what happen when you skim over something instead of reading it in detail!

Shawn Melton
Twitter: @wsmelton
Blog: blog.wsmelton.info
Michael Valentine Jones
Michael Valentine Jones
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15219 Visits: 11848
"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.
hmbtx
hmbtx
SSC Eights!
SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)

Group: General Forum Members
Points: 910 Visits: 1464
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



thisisfutile
thisisfutile
Right there with Babe
Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)Right there with Babe (729 reputation)

Group: General Forum Members
Points: 729 Visits: 1005
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.
Hehe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search