March 29, 2011 at 10:29 am
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
March 29, 2011 at 10:32 am
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: wsmelton.github.com
Github: wsmelton
March 29, 2011 at 10:36 am
"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.
March 29, 2011 at 10:52 am
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
June 19, 2011 at 11:07 am
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:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply