Different @@version

I have 2 machines, both that I _thought_ were loaded with the same
version, but when I do select @.@.version on the two I get different
results:
1.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Cop
yright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows
NT 5.2 (Build 3790: )
2.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Cop
yright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Notice how 1 doesn't say Service Pack 1. Both should have SP4 on them.
WHat is the difference?
Darin
*** Sent via Developersdex http://www.codecomments.com ***> Notice how 1 doesn't say Service Pack 1.
That is the service pack of the operating system, not the SQL Server instanc
e. The interesting part
is:
> Microsoft SQL Server 2000 - 8.00.2039
You can now map the build number to the service pack (Aaron has an article o
n this at
www.aspfaq.com). You can also use the SERVERPROPERTY() function to get the s
ervice pack from your
SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Darin" <darin_nospam@.nospamever> wrote in message news:OV95wYneGHA.4840@.TK2MSFTNGP03.phx.gb
l...
>I have 2 machines, both that I _thought_ were loaded with the same
> version, but when I do select @.@.version on the two I get different
> results:
> 1.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Cop
> yright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows
> NT 5.2 (Build 3790: )
> 2.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Cop
> yright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> Notice how 1 doesn't say Service Pack 1. Both should have SP4 on them.
> WHat is the difference?
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***