No ‘open table’ option in SQL Server 2008

  • Questions
  • No 'open table' option in SQL Server 2008
Question ID: 104154

We have just recently upgraded to SQL Server 2008 and found that there is no ‘open table’ option in the right click menu. This was handy for quick database edits and changes. This option has now been replaced by "select top 200 rows" and "select top 1000 rows". This is inconvenient if the data is on row 1001.

Marked as spam
Posted by (Questions: 15, Answers: 10)
Asked on July 12, 2010 6:53 pm
Answers (1)
Private answer

It seems that Microsoft left us an easy out for this.

In SQL Management Studio go to:

Tools - Options
expand SQL Server Object Explorer
Click on ''Commands''

Here you can change the ''Value for Edit Top Rows command''

I changed this to ''0'' and now my right click shows ''edit all rows''

This provides the same display that the'open table' option provided in SQL 2005.

Marked as spam
Posted by (Questions: 15, Answers: 10)
Answered on July 12, 2010 6:58 pm