May 24, 2005 at 6:58 am
I installed SP4 on MSDE (quite carefully, they make it really hard to figure out what to do).
I also did it on my full SQL server install, different machine.
But when I print @@version on MSDE it says SP2, and on SQL server it says SP4 as expected.
Should I worry about this?
May 24, 2005 at 10:30 am
Does it have the correct version number of 8.00.2039.
Most people confuse the OS version number as being the SP version.
Tim S
May 24, 2005 at 10:49 am
This is a direct copy of each of them. I felt they should both say Service Pack 4. As you can see the MSDE on says it is SP2, not SP4, but does have the version # you mentioned.
(On WIndows 2000):
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 4)
(On Windows XP):
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
May 24, 2005 at 11:31 am
The Windows 2000 server is on SP 3 for SQL 2000 and it is Service Pack 4 on the windows OS. So if you want it to be SQL SP4 it still needs patched
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) This line after the on applies to OS.
Tim S
May 24, 2005 at 11:49 am
Duh. Somedays you just feel stupid. Ok, so the Service pack info is about the OS not the SQL server. Who knew. It's sort of obvious after you think about it.
Based on your comments I revisited the update for the full SQL server 2000. I did itover again and guess what? Seems right now. Don't know what happened.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Thanks for your help BTW.
May 24, 2005 at 4:26 pm
one query you can use to determine the service pack level of SQL Server (with other info) is:
select serverproperty('productlevel') as 'Service Pack', serverproperty('edition') as edition, serverproperty('productversion') as 'build number'
May 24, 2005 at 7:29 pm
Cool thanks, all my SQL servers seem to be up to date now!!!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply