Delen via


Options (Query Results/SQL Server/Multi-Server)

When you are querying multiple servers at the same time, use this page to specify the options for displaying result sets. Merge results combines the result sets from all servers into a single result set. When merging results, the first server to respond sets the schema for the result set. To merge the result sets, the query must return the same number of columns with the same column names from each server. When merging results, a message is displayed for each server that does not match the schema (column count and column names) that is returned by the first server to return results.

When you do not merge results, the result set from each server will be displayed in its own grid with its own schema.

  • Merge results
    Select this check box to combine the result sets from several servers into the same grid.

  • Add server name to the results
    Select this check box to include an additional column that provides the name of the server that produced each row.

  • Add login name to the results
    Select this check box to include an additional column that provides the login that was used to connect to the server that provided each row.