How to open table in SQL 2008


What happen to open table in SQL 2008 and how do I open a table in SQL 2008?
In SQL 2008, to open a table you need to Right Click table which you want to open and select edit top 200 rows

Open table in SQL 2008

The reason it got changed this way in SQL 2008 is that in previous version users are opening hug tables and it slows down the SQL performance.
In this way it will only allow you to open top 200 rows.

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 )

Google+ photo

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

Connecting to %s