Forgive me if this is the wrong exchange site for this question. It seems like the right one.
I have been a fan of writing queries manually for a long time, but recently I've got into the habit of using the query designer in Management Studio for one reason – it allows editing of data in-place. (There's probably a way of doing this in the manual query window but I haven't found out yet)
Anyway, today I wanted to create a new instance of it for a table, and preserve the one I already had open. It wouldn't let me. When I clicked 'open table' on the object explorer it just took me to the window I already had open. This meant that if I want to query the data in a different way I have to abandon the query I had set up.
Is there a way of getting a second (or more) query designer window for the same table?
It occurs to me that I can just open a second instance of the entire app (SSMS) but that seems overkill for what must be a simple/common need.
Best Answer
I don't believe there is a way to do this. SSMS seems to prevent you from opening more than one instance, and the only workaround I can think of is not to kick SSMS but rather just open a new instance of the entire application (as you've already guessed as well).
In any case, I strongly recommend you revert to your previous behavior - the query designer is full of bugs and your "edit data in place" feature actually means that the grid has to place unnecessary locks on the underlying table. On a concurrent system this can be disastrous - what kind of concurrency handling do you think is there? You should try to open two instances of SSMS and try to edit the same row in each copy. Fun fun!
Even though it is slightly more work to write, using proper DML (update/insert/delete) in a proper query window is a much better approach to ad-hoc data modification IMHO. And I have long been advocating to stay away from the SSMS visual designers in all their various forms. The team tried but some of the faulty code has been in there since Query Analyzer and it will never be fixed.