Hello,

In earlier versions of SQL, I could use Enterprise Manager to modify or
delete records from the pane that was displayed when I right-clicked a table
and chose "Open Table Return All Rows" or "Open Table Query".  With the new
SQL Server Management Studio Express, I cannot find a way to do this.  Was
this feature changed or is the Express edition allowed to do this?

Thank you,

Robert (Rob***@discussions.microsoft.com) writes:
You can definitely modify rows from Open Table. I think you can delete
as well.

However, it's impedient that the rows are identifyable. That is, the
table needs to have a primary key.

In any case, my strong preference is to use INSERT, UPDATE and DELETE
statements to modify data. Scripts can be reused, and they can also be
added as a lot to support cases.

Backup job failed-SVP2
Profiler temp file
debugger problems in query analyzer
Should I Upgrade from RTM to SP3a or SP4 To Try To Fix Problems?
Scripting Performance after SP2 applied?