Page History

...

1. Download (from Microsoft website) and install SQL Server Management Studio 2014 (see Microsoft documentation).
2. Start SQL Server Management Studio utility. Click Start -> All Programs -> Microsoft SQL Server 2014 -> SQL Server Management Studio.
3. Specify parameters of connection to MS SQL server in the Connect to Server window.
   Image Modified
   
   1. Select the Database Engine type in the Server type list (1).
   2. Select the name of MS SQL server to which it is necessary to connect in the Server name list (2).

   3. Select authentication type used for connection to MS SQL server in the Authentication list (3).

      Info
      title Note
      The type of authentication that was selected while creating MS SQL server is specified.

      
      

      Info
      title Note
      If SQL Server Authentication type is used, then select the user in the Login list and type-in the required password in the Password field (3).

      
      

4. Click Connect to connect to MS SQL server. If the connection is successful, then the Object Explorer window is displayed.
   Image Modified
5. Open the embedded list of the Databases catalogue in the Object Explorer box and go to the required database.
   Image Modified
6. Select the table for viewing in the Tables catalogue.
7. Select Select Top 1000 Rows item in the context menu of the table.
   Image Modified

As a result, the box with SQL Query on top of it and the table data selected by the query will be displayed.

...

Info
title Note
One can change the quantity of rows and set of fields requested in the table by editing SQL Query. To start modified SQL Query click Image Removed Image Added on the toolbar.

Image Modified

If one need to create his own query, then select Script Table as -> SELECT To -> New Query Editor Window in the context menu and type in SQL Query in the box.

Image Modified

Info
title Note
To execute the query, click  on the toolbar.

Viewing Axxon PSIM database is now completed.

...