Editing Data from SSMS

Sometimes you want to edit data directly in a table (often a very bad idea!). In Enterprise Manager (SQL2K) and SQL Server Management Studio (SQL2K5) you right-click a table and select "Open Table" from the menu. That brings back ALL of the rows in the table, and you edit them that way. This has a bad habit of locking tables while all that happens.

So in SSMS 2K8, we added two menu items - "Edit Top 200 Rows" and "Select Top 1000 Rows". Now you can edit just a few at a time or view them. By the way, these numbers are a value you can set in the Tools | Options menu.

Comments (2)
  1. Rare lam says:

    Thanks for info. It help me when I needed. :)

    Waste almost 2 weeks in MS SQL Server Express is not a good sign.

Comments are closed.

Skip to main content