How to: Use the Properties Window in Management Studio
The Properties window describes the state of an item in SQL Server Management Studio, such as a connection or a Showplan operator, and information about database objects such as tables, views, and designers.
You can use the Properties window to view the properties of the current connection. Many properties are read-only in the Properties window but can be changed elsewhere in the Management Studio. For example, the Database property of a query is read-only in the Properties window, but can be changed on the tool bar.
On the Query menu, click Include Actual Execution Plan.
In the SQL Query Editor, type and execute a query.
If the Properties window is not visible, click Properties Window on the View menu, or press F4.
On the Execution plan tab of the SQL Query Editor click the icons of the operators to view information about the operators in the Properties window.