Viewing Table Properties and Data in Enterprise Manager


To view the properties for a table, right-click the table name in the Details pane of Enterprise Manager. The Properties page allows you to view the table definition and set permissions on the table. Figure 12.6 shows the Table Properties page.

Figure 12.6. The Table Properties page.

graphics/12fig06.jpg

Enterprise Manager also allows you to view and change table data through the GUI. In the Details pane, right-click the table and select Open Table. This will present you with three selections: Return All Rows, Return Top, and Query. The first selection returns all rows in a table, the second allows you to set a maximum return value, and the third opens a query window to write a custom select statement. Data returned in this manner can be edited from the GUI, but I don't recommend it except for perhaps one-item updates on small tables. If an update is attempted on a row, without scrolling through the entire table, the error Transaction cannot start while in firehose mode is generated. This is due to the way SQL Server processes the default result set, also known as a firehose cursor. Figure 12.7 shows the results of a query using Return All Rows.

Figure 12.7. Viewing data in Enterprise Manager.

graphics/12fig07.jpg



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net