Prev: File/Filegroup last changed
Next: What does red cross icon mean beside server name in SSMS in sql 20
From: JohnJohn on 12 Aug 2010 17:13
Hello,

We have a server running SQL Server 2000 running on Windows Server 2003 R2.
When I run "select @@version" in Query Analyzer, I get the following output:

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)

However, when I right-click on the server in Enterprise Manager and choose
"Properties", it shows:

Product: SQL Server Standard Edition
Operating system: Microsoft Windows NT - 5.2 (3790)
Product version: 8.00.2055 (SP4)
Language: English (United States)
Platform: NT Intel X86
.....yaddda yadda yadda

Why is it showing "Service Pack 2" in Query Analyzer, but "SP4" in
Enterprise Manager? And does anyone know which info is more reliable? My
gut tells me to trust @@version.

Please let me know if you need any more information, and thank you in
advance for any help!

John


From: Tom Cooper on 12 Aug 2010 18:01
They're both right, but returning different information. The @@version is
saying you are on SP2 of Windows NT 5.2. The properties is saying you are
on SP4 of SQL Server 2000.

Tom

"JohnJohn" <JohnJohn(a)discussions.microsoft.com> wrote in message
news:39243202-455A-4D8B-B791-669A4C933EEF(a)microsoft.com...
> Hello,
>
> We have a server running SQL Server 2000 running on Windows Server 2003
> R2.
> When I run "select @@version" in Query Analyzer, I get the following
> output:
>
> Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT
> 5.2 (Build 3790: Service Pack 2)
>
> However, when I right-click on the server in Enterprise Manager and choose
> "Properties", it shows:
>
> Product: SQL Server Standard Edition
> Operating system: Microsoft Windows NT - 5.2 (3790)
> Product version: 8.00.2055 (SP4)
> Language: English (United States)
> Platform: NT Intel X86
> ....yaddda yadda yadda
>
> Why is it showing "Service Pack 2" in Query Analyzer, but "SP4" in
> Enterprise Manager? And does anyone know which info is more reliable? My
> gut tells me to trust @@version.
>
> Please let me know if you need any more information, and thank you in
> advance for any help!
>
> John
>
>

 | 
Pages: 1
Prev: File/Filegroup last changed
Next: What does red cross icon mean beside server name in SSMS in sql 20