INF: How to Identify Which Edition of SQL Server 7.0 Is Running

ID: Q247710

The information in this article applies to:

Microsoft SQL Server version 7.0

SUMMARY

SQL Server 7.0 comes in various editions to suit different needs. The editions of SQL Server that are available are:

Evaluation

Desktop

Standard

Enterprise

Developer

Small Business

Microsoft Data Engine (MSDE)

To find which edition of SQL Server is currently running, execute the following query from either Query Analyzer or OSQL.exe:


SELECT @@version

The result of this query will show the edition on the line below the Copyright line, as in the following examples:

SQL Server 7.0 Evaluation Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      Standard Edition Evaluation on Windows NT 4.0 (Build 1381: Service Pack 4)

SQL Server 7.0 Desktop Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      Desktop Edition on Windows 4.10 (Build 2222: A)

SQL Server 7.0 Standard Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

SQL Server 7.0 Enterprise Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
      May 21 1999 14:08:18
      Copyright (c) 1988-1998 Microsoft Corporation
      Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

SQL Server 7.0 Developer Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      Developer Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

NOTE: SQL Server 7.0 Developer Edition is part of MSDE for Microsoft Visual Studio 6.0 and the Visual Studio 6.0 Plus Pack. MSDE for Visual Studio 6.0 is available to licensed customers of any Visual Studio 6.0 Professional or Enterprise Edition tool. You can also order an MSDE CD from:

http://msdn.microsoft.com/vstudio/msde/order.asp

SQL Server 7.0 Small Business Server (SBS) Edition


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      Small Business Server Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

Microsoft Data Engine (MSDE)


   Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
      Nov 27 1998 22:20:07 
      Copyright (c) 1988-1998 Microsoft Corporation
      MSDE on Windows 4.10 (Build 2222: A)

MORE INFORMATION

The results of the SELECT @@version query shows much useful information, including:

The version and build number, which can be used to determine which service pack (if any) has been applied. For example, if you are running SQL Server 7.0 with no service pack applied, you will see version 7.00.623; if you have applied Service Pack 1, the version will be 7.00.699.

For additional information about a how to determine this in SQL Server 6.x, click the article number below to view the article in the Microsoft Knowledge Base:
Q202051 INF: How to Determine SQL Server 6.x Service Pack Installed

The edition of SQL Server (for example, Enterprise or Standard).

The operating system and service pack number.

Additional query words:

Keywords : SSrvAdmin kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbhowto kbinfo