What “Open Table “in SQL Server 2005 replaced with in SQL Server 2008? How to change this Edit top 200 to edit all?

Posted by


Today, a customer asked me how to open a table in SQL Server 2008 to edit the rows in a table manually as she is able to do it in SQL 2005 using open table option in right click of table but in SQL Server 2008 it was replaced with edit top 200 rows. Initially I though there is no way to change from the default option Edit top 200 to all but after searching in BOL ,I found this


SSMS -> Tools -> Options-> SQL Server Object Explorer-> Commands-> Set value 0 for Value for Edit Top Rows Command


Note: Setting value 0 lets you retrieve all or you can customize this value to your requirement.                 


Source: BOL


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s