November 5, 2007 at 8:20 am
Hi ,
What is the latest Service pack for SQL Server 2000. Is RTM the latest one? If we install SP4 set up Select Serverproperty('productlevel') shows RTM.
Why is it so?
Regards,
Rohit
November 5, 2007 at 9:14 am
RTM is the original release of 2000. That is build 194 (8.00.194). Service Pack 4 is 8.00.2039
What does @@version return? There are hotfixes post SP4, so your version might be higher.
Sp1 - 384
SP2 - 534
SP3 - 760
November 5, 2007 at 9:55 pm
Hi,
Thanks for your reply. @@version returns the below results.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Regards,
Rohit
November 5, 2007 at 9:57 pm
We get this after running
SQL2000-KB884525-SP4-ia64-ENU.EXE
November 7, 2007 at 6:36 am
The latest publicly available Service Pack for SQL Server 2000 is "Pack 4 build 2187".
http://support.microsoft.com/kb/916287/
The Database Version will show as "8.00.2187"
I use the chunk of code below for Database versioning purposes:
-- --
-- Show information about all SQL Server Databases.
-- SQL Server 2000
USE master
GO
select
-- getdate() as 'Time_Data_Gathered'
--,
cast(serverproperty('ServerName') as varchar(20)) as [Server Name]
,Case when serverproperty('InstanceName') is null
then '(default)'
else serverproperty('InstanceName')
end as [Instance Name]
,name as [Database Name]
,cast(serverproperty('productversion') as varchar(20)) as [Product Version]
,cast(serverproperty('productlevel') as varchar(20)) as [Product Level]
,cast(serverproperty('edition') as varchar(40)) as [Edition]
FROM dbo.sysdatabases
-- --
For more information on SQL Server versions ... The folks at SQLSecurity.com maintain a SQL Server Version Database.
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Hope This Helps
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
November 7, 2007 at 7:26 am
Rohit Chitre (11/5/2007)
We get this after runningSQL2000-KB884525-SP4-ia64-ENU.EXE
This is the service pack for 64-bit Itanium version. Your select @@version result shows an Intelx86 version. So you have the wrong service pack you need the x86 version.
Markus
[font="Verdana"]Markus Bohse[/font]
November 7, 2007 at 7:46 am
Thanks a ton. The information / script was really helpful.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply