LinkedIn | FaceBook | Twitter
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.
PingBack from http://www.simplynetdev.com/editing-data-from-ssms/
Thanks for info. It help me when I needed. :)
Waste almost 2 weeks in MS SQL Server Express is not a good sign.