No ‘open table’ option in SQL Server 2008
Question ID:
104154
| ♥ 0 |
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
|
Answers (1)
|
Private answer
It seems that Microsoft left us an easy out for this. In SQL Management Studio go to: Tools - Options 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 young-steve (Questions: 15, Answers: 10) Answered on July 12, 2010 6:58 pm
|