SQL Server Version

Use Query Analyzer with Microsoft SQL Server 2000

.

The easiest method to find the current version and SP level is to use the SQL Query Analyzer and run the SQL query in step 4 for servers that run Microsoft SQL Server 2000.

1. Select Programs > Microsoft SQL Server Enterprise Manager.

2. Select Tools > SQL Query Analyzer.

3. Select the local instance of your SQL server in the initial SQL Query Analyzer popup window.

   You also need to select your connection authentication method. Use either SQL Server authentication or Windows authentication for your server. Windows authentication is the easier method in most cases because it uses the credentials of the account that you are currently logged in with. Supply an SQL Server login name such as SA and the associated password if you select SQL Server authentication.

   The account that you are logged into does not have the necessary rights to connect to the SQL server if you attempt a connection and receive the error Not Associated with a Trusted SQL Server Connection when you use Windows authentication. Log off the server and log on again as a different user with the correct rights or use SQL Server authentication instead.

   

   The Windows authentication method is selected in this case. Click OK.

4. Enter the SQL query string as this example shows:

   SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY 
   ('productlevel'), SERVERPROPERTY ('edition')
   

5. Select the Parse Query tool to verify the syntax.

   The message Command(s) complete successfully displays. Modify the syntax until the parser allows it to run without errors if the syntax is incorrect.

6. Select the Execute Query tool to run your query.

   Output similar to the text in this image displays:

   

   The server runs Standard Edition, build number 8.00.760, SP 3 in this case.

7. Close the SQL Query Analyzer. You are prompted to save the current query. Save the query to a local folder if you want to be able to run this again at a later time. Otherwise, answer no to finish the close.

8. Close the Microsoft SQL Server Enterprise Manager.

Use Query Analyzer with Microsoft SQL Server 7.0

The query that comes with Microsoft SQL Server 2000 does not work on SQL Server 7.0. The only option available is to use the select @@version query that provides the build number. You can look the build number up in the table once you have it.

The initial steps that you use to start the SQL Query Analyzer for Microsoft SQL Server 7.0 are the same as for Microsoft SQL Server 2000.

1. Select Programs > Microsoft SQL Server Enterprise Manager.

2. Select Tools > SQL Query Analyzer.

3. Select the local instance of your SQL server in the initial SQL Query Analyzer popup window. Also select your connection authentication method.

   Use either SQL Server authentication or Windows authentication as appropriate for your server. Windows authentication is the easier method in most cases because it uses the credentials of the account that you are currently logged in with. Supply an SQL Server login name such as SA and the associated password if you select SQL Server authentication.

   The account that you are logged into does not have the necessary rights to connect to the SQL server if you attempt a connection and receive the error Not Associated with a Trusted SQL Server Connection when you use Windows authentication. Log off the server and log on again as a different user with the correct rights or use SQL Server authentication instead.

   

   The Windows authentication method is selected in this case. Click OK.

4. Enter the SQL query string as this example shows:

   USE MASTER SELECT @@VERSION
   

5. Select the Parse Query tool to verify the syntax.

   The message Command(s) complete successfully displays. Modify the syntax until the parser allows it to run without errors if the syntax is incorrect.

6. Select the Execute Query tool to run your query.

   Output similar to the text below displays:

   Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86) Sep 6
    2002 15:10:15 Copyright (c) 1988-2002 Microsoft Corporation 
   Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

   The SQL engine is Microsoft SQL Server 7.00, Standard Edition. The build number in this case is 7.00.1077. This build number corresponds to SQL Server 7.0 SP 4 + SQL7-MS02-061 (Microsoft Knowledge Base articles Q263968 and Q326573) in the table.

   This server has had SP 4 applied as well as an additional hot fix for Q263968 and Q326573 in this case.

7. Close the SQL Query Analyzer.

   You are prompted to save the current query. Save the query to a local folder if you want to be able to run this again at a later time. Otherwise, answer no to finish the close.

8. Close the Microsoft SQL Server Enterprise Manager.