Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Start SQL Server Management Studio utility. Click ‘Start’ => ‘All Programs’ => ‘Microsoft SQL Server 2008 R2’ 2014’ => ‘SQL Server Management Studio’.
  2. Specify parameters of connection to MS SQL server in the Connect to Server box.

    1. Select the Database Engine type in the Server type list (1).
    2. Select the name of MS SQL server to wich it is necessary to connect in the Server name list (2).
    3. Select authentication type used for connecton to MS SQL server in the Authentication list (3).

      Info
      titleNote.
      The type of  authentication  that was selected while creating MS SQL server is specified.
      Info
      titleNote.
      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).
  3. Click Connect to connect to MS SQL server. If the connection is successful, then the Object Explorer box is displayed.
  4. Open the embedded list of the Databases catalogue in the Object Explorer box and go to the required database.
  5. Select the table for viewing in the Tables catalogue.  
  6. Select Select Top 1000 Rows item in the context menu of the table.

...