How to know the version of SQL Server?

[hmcheung]

How can I know the version and edition of my SQL server? I've installed SQL Server 2000, how can I know whether it is a personal edition, standard edition or enterprise edition? I suppose i can find it in some sort of 'about' menu but there isn't any....
thanks! Please visit my WebCam!!

http://i.am/andycheung

 

[Bernadette]

Hi There

This is the only way I know to tell the difference. but it is between the Developer and Standard edition Maybe one of these will work for the standard and enterprise editions.

When installing SQL Server
1. Autorun shows "SQL Server 7.0 Developer Edition".
2. The Setup title bar contains "Developer Edition".
3. Check the End User License Agreement (EULA) in Setup
4. Results of "select @@version" indicate "Developer
Edition".
5. The SQL Server Errorlog contains "Developer Edition".

Good Luck
Hope this helps .. even a little bit

Bernadette

 

[foxdev]

As Bernadette mentioned, SELECT @@VERSION should give you what you need. For example, mine shows:

Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: )

Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org