SELECT @@VERSION shows winNT5.0 server SP4 ... NOT sql2000 SP ..why?

[mb224]

I'm trying to fing out what version/service pack is currently installed for SQL2000 .... so I run
select @@version

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)

this decieved me into thinking SQL2000 (SP) service pack 4 was installed ... but actually that is the SP for the windows 2000 server.

How can I determine the current service pack level if any for my SQL2000 server?

 

[mb224]

I think I found a solution

SELECT SERVERPROPERTY('productversion') , SERVERPROPERTY
('productlevel') , SERVERPROPERTY ('edition')

'PRODUCT LEVEL' returns

The level of the version of the SQL Server instance.
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version.

 

[Corran007]

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

The number will tell you what verion you are on. so looking at yours 8.00.194 you are on sql2000 rtm(no sp)

 

[masds]

I guess what puzzled you is the word "winnt 5.0", it means windows 2000.