The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Knowledge Base

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

PSS ID Number: 247710

Article Last Modified on 8/27/2002

The information in this article applies to:

Microsoft SQL Server 7.0

This article was previously published under Q247710

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; if you have applied Service Pack 2, the version will be 7.00.842; and if you have applied Service Pack 3, the version will be 7.00.961.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:

202051 INF: How to Determine SQL Server 6.x Service Pack Installed

For information on how to obtain Service Pack 2, see the following article:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
The edition of SQL Server (for example, Enterprise or Standard).
The operating system and service pack number.

Keywords: kbhowto kbinfo KB247710
Technology: kbAudDeveloper kbSQLServ700 kbSQLServSearch

Microsoft KB Archive/247710

Contents