how can i tell if sql2k instance is standard or enterprise? 1

[vadimg]

Hello.
how can i tell if sql instalation is standard or enterprise?

(xp_msver output if that helps)...


1
ProductName NULL Microsoft SQL Server 2
ProductVersion 524288 8.00.760 3
Language 1033 English (United States) 4
Platform NULL NT INTEL X86 5
Comments NULL NT INTEL X86 6
CompanyName NULL Microsoft Corporation 7
FileDescription NULL SQL Server Windows NT 8
FileVersion NULL 2000.080.0760.00 9
InternalName NULL SQLSERVR 10
LegalCopyright NULL © 1988-2003 Microsoft Corp. All rights reserved. 11
LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation 12
OriginalFilename NULL SQLSERVR.EXE 13
PrivateBuild NULL NULL 14
SpecialBuild 49807360 NULL 15
WindowsVersion 248381957 5.2 (3790) 16
ProcessorCount 16 16 17
ProcessorActiveMask 65535 0000ffff 18
ProcessorType 586 PROCESSOR_INTEL_PENTIUM 19
PhysicalMemory 16383 16383 (17178877952) 20
Product ID NULL NULL

 

[ccampbell]

Go to Start - Programs - SQL Server... Do you have an Enterprise Manager? If you do then you have Enterprise Edition, if not, you don't.

 

[vadimg]

I DON"T think that's correct.
Enterprise Manager is a client tool.
i have developer edition installed at home, and it also has Enterprise manager.

Anybody else?
Thanks!

 

[CurtisJM]

if you execute select @@version from one of the sql tools - or from any odbc type tool - it will tell you the version and type. For example:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 1)

or


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 2)

Note the first one... boy, it needs to be upgraded to sp3! <grin>...

 

[ecobb]

I have SQL 2000 Pro. and it has Enterprise Manager. For that matter, we have several 2000 machines with Enterprise Manager on them that don't even have SQL Server on them, we just use them for remote management of all of our SQL Servers.

 

[vadimg]

Curtis, a star for you!! can't believe i haven't checked @@version!
watch out for the slammer, and thanks!