Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
This article applies to SQL 2000 and SQL 2005 only.
To check you SQL server version and edition, run the following query on the SQL instance:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')
The results are:
- The product version (for example, 8.00.534).
- The product level (for example, "RTM" or "SP2").
- The edition (for example, "Standard Edition"). For example, the result looks similar to: "8.00.534 RTM Standard Edition"
Use the following table to identify your version:
|SQL Server 2000 RTM||2000.80.194.0|
|SQL Server 2000 SP1||2000.80.384.0|
|SQL Server 2000 SP2||2000.80.534.0|
|SQL Server 2000 SP3||2000.80.760.0|
|SQL Server 2000 SP3a||2000.80.760.0|
|SQL Server 2000 SP4||2000.8.00.2039|
|SQL Server 2005 RTM||2005.90.1399|
|SQL Server 2005 Service Pack 1||2005.90.2047|
|SQL Server 2005 Service Pack 2||2005.90.3042|
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!