January 27, 2003 at 12:25 pm
I downloaded sp3, installed it, ran thru all the screens and reboots and all that it does. It reports no problems. However, after installed, I run select @@Version, and it still tells me that i am on service pack 2, with the same version numbers that i had before. So i reran sp3, and same results.
am i doing something wrong?
January 27, 2003 at 12:36 pm
Check the sqlsp.log file in your system directory (C:\WINNT\ or C:\WINDOWS\ or whatever you used). Are there any errors being reported?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 27, 2003 at 12:37 pm
BTW, the header should be:
23:22:34 Begin Setup
23:22:34 Version on Media: 8.00.760
Or something of that sort where the version is 8.00.760.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 27, 2003 at 1:08 pm
It does start out like you said. I dont pretend to understand it all, but i dont see anything in it that raises any flags in my head.
about a minute into the log, it says : This machine has SQL Server 2000 SP3 already installed.
so, maybe its there, but why doesnt @@Version report it correctly? hum...
it says :
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
weird. Maybe its all ok... but it bugs me.
January 28, 2003 at 10:17 am
I believe it says that your windows 2000 is on SP2. SQL Server does not display it's real SP version.
If you get the 'Microsoft SQL Server 2000 - 8.00.760 (Intel X86)' line, you are on SP3 in SQL Server.
January 28, 2003 at 10:43 am
Yup, NPeeters has it correct. The way to check service pack is the 8.00.XXX number. The "Service Pack 2" is for the OS.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 28, 2003 at 11:11 am
cool to know. thanks guys. I was worried because it didnt display it correctly.
alls well, i paniked for nothing. But I'd rather do that, then not worry, and actually have a problem.
thanks again.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply