Using SQL Server Enterprise Manager

In SQL Server Enterprise Manager, on the Tools menu, click SQL Server Query Analyzer to run SQL Server Query Analyzer. With SQL Server Query Analyzer, users can interactively design and execute queries.

SQL Server Enterprise Manager also provides the Query Designer, a graphical (GUI) tool for designing queries used in specific objects:

Right-click Views in the console tree, and then click New View. Query Designer can be used to design the SELECT statement for the view. For more information, see How to access the Query Designer to design a view (Enterprise Manager).
Right-click a Data Transformation Services Execute SQL task object, and then click Properties. Query Designer can be used to design the query to be executed. For more information, see How to access the Query Designer in Data Transformation Services (Enterprise Manager).
Right-click a table in the left pane, and then click Show Table to see the rows in the table. Query Designer can be used to change the query to see specific rows. For more information, see How to access the Query Designer to view a table (Enterprise Manager).

The Query Designer window has four separate panes for specifying or displaying different items associated with a query.

Pane	Description
Diagram	Has a diagram showing the tables referenced in the query. The diagram shows all columns for each table and checks the columns used in the result set.
SQL	Shows the syntax of the SQL statement.
Grid	Shows the details of the result set columns, such as name, data type, and size.
Results	Shows the result set returned by the last execution of the query.

For more information on opening and hiding the panes, see How to open panes in the Query Designer (Enterprise Manager) and How to hide panes in the Query Designer (Enterprise Manager).