Obtain version informations of SQL-Server / MSDE (kb2486)

The information in this article applies to:

  • Microsoft Database Engine 2000
  • Microsoft Database Engine 1.0
  • Microsoft SQL Server 2000
  • Microsoft SQL Server 7.0
  • Microsoft Windows 2000 Server

[ Summary | Information | Links ]


This articles describes how to obtain version informations of SQL-Server / MSDE and to analyse them. This means especially to get the installed Service Pack Level.


The version number of the installed SQL-Engine (SQL-Server or Microsoft Data Engine - MSDE) can be obtained from the script being attached to this article or from the Application Eventlog.



Start the attached script by double clicking it or by the following command line: cscript sqlversion.wsf


Application Eventlog

The version information can be found in the startup message of the MSSQLServer (Event ID: 17055):

SQL-Server versions info in the eventlog
SQL-Server versions info in the eventlog
Click to enlarge...


Analyse the version informations 

Following Products / Service Pack (SP) levels are connected to the version numbers:

VersionProduct / Service Pack Level
7.00.623Original SQL Server 7.0 or MSDE 1.0 Release
7.00.699SQL Server 7 / MSDE 1.0 SP1
7.00.842SQL Server 7 / MSDE 1.0 SP2
7.00.961SQL Server 7 / MSDE 1.0 SP3
7.00.1063SQL Server 7 / MSDE 1.0 SP4
8.00.194SQL Server 2000
8.00.384SQL Server 2000 SP1
8.00.534SQL Server 2000 SP2
8.00.760SQL Server 2000 SP3 or SP3a



As far as software supplied or used by us, includes open source elements the additional terms under apply in addition. An overview which products from the Swyx portfolio include open source elements and which open source license is relevant can be found under

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Swyx in no way guarantees the accuracy of this third-party contact information nor is responsible for it's content.


Comment on this article

If we have any follow-up questions, where can we contact you?

E-Mail Address (optional)


This feedback form can't be used for support requests. Those requests must be directed to your Swyx reseller or distributor.