A little over a month ago, I posted some thoughts on a few of the new features in SSMS that I found (not) useful (see /blogs/aaron_bertrand/archive/2007/11/18/november-ctp-initial-impressions-of-ssms-changes.aspx).
In addition to learning that the server prefix information was designed for multi-server queries, and that by RTM we will be able to suppress this information for "local" queries, I realize now that I forgot a couple of changes that are actually very important!
Gone from the table context menu are the options "Open Table" and "Edit." The former opened the entire table, and also allowed for modification of data — this was a very dangerous thing to do, especially for a large table and/or busy system (I complained about it in Connect #264592). The latter basically duplicated the functionality of Script Table As > Create To > New Window.
Now they have separated the "Open Table" feature into two separate options:
While the SELECT option is a welcome read-only replacement for Open Table, I am still going to continue to recommend using proper DML statements to modify data, rather than trying to edit them in a grid using the EDIT option.
Anyway, I just wanted to bring up those new context menu items, because I realized they were a shameful omission from my first review. Hopefully I will have more to share with you soon.
Comments are closed.
pinback