INFO

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 ]


Summary

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.


Information

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.

 

Script

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:

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

 


Links

As far as software supplied or used by us, includes open source elements the additional terms under https://www.swyx.com/open-source 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 https://www.swyx.com/open-source.

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

Comment on this article



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

E-Mail Address (optional)


Note

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