How can view the contents of a table in a SQL Server database using Enterprise Manager?

Open Enterprise Manager and expand the registered SQL Server


Expand Databases


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

Your rating: None