How to view the data defined by a view (Enterprise Manager)

To view the data defined by a view

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the view belongs, and then click Views.
3. In the details pane, right-click the view, point to Open View, and then click Return All Rows to view all the data defined by the view.
4. Optionally, in the details pane, right-click the view, point to Open View, and then click Return Top.... Enter the number of rows to view.

See Also

Getting Information About a View