I have found the very strange features in SQL SSMS 2005 and 2008. Let say I choose one of the table in SSMS 2008 and right click on the table I want to open. I ONLY have the option for 1. Select Top 1000 Rows 2.Edit Top 200 Rows
NOT OPEN option.
I saw some server has installed same version of SQL 2005 and 2008, they have just OPEN option and there is no SELECT TOP 1000 / EDIT TOP 200. (that is great and what I wanted)
Anybody know why? I would like to have OPEN option only on my Development Machine because I can view and also edit the data on the same time.
Anybody know how to change the option to OPEN ONLY? I am using Developer Edition of SQL 2008.