View the contents of a table in a SQL Server database using Enterprise Manager?
Open Enterprise Manager and expand the registered SQL Server
Expand the database
Click on Tables, all of the tables in the database will show up in the right pane
Locate the table you’d like to open, right-click it and select Open Table -> Return Top…
Type the number of rows you would like to view, click OK
If you would like to view all rows in the table, select the Return All Rows option.