Home : Products : Hach WIMS : Platform Installer : Documentation : How to Tell Which MS SQL Database is Installed
Q14346 - HOWTO: How to Tell Which MS SQL Database is Installed

This article explains how to tell which database is installed for Hach WIMS.

There are several good articles online to match database version to database numbers. The http://sqlserverversions.blogspot.com/ is a good place to start.

To find out which database version is installed:

Using MS SQL Server Management Studio Express (SSMSE)

  1. Run  SSMSE
  2. Log on to the Hach WIMS DBMS
  3. Note the database number in the upper right hand window of SSMSE

Using COMMAND or CMD prompt:

  1. Enter the following command and hit Enter:
    sqlcmd -S localhost\OPSSQL
  2. At the 1> prompt enter:
    select @@version
  3. At the 2> prompt enter:
    go
  4. The screen will display the SQL number in the middle:

 

Now look up the database version at the website from the database number, in the examples above we are running SQL Server 2005 SP4

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/21/2015 9:39 AM.
Last Modified on 10/21/2015 10:55 AM.
Last Modified by No Author Name Available!.
Article has been viewed 2775 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article