Microsoft KB Archive/247710

= 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.</li></ul>

Keywords: kbhowto kbinfo KB247710

Technology: kbAudDeveloper kbSQLServ700 kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.