"The Seeker" <The See***@discussions.microsoft.com> wrote in message
news:F8A228AB-C19D-48F4-9A8F-92B1B83D64D0@microsoft.com...
> Hello,
>
> I'm running SQL 2005 SP1 with the latest hotfix rollup, and I'm struggling
> with the new Query Designer in the Management Studio.
>
> The functionality that I'm looking for is the ability to quickly query a
> table and produce a results pane that will allow me to quickly edit or
> delete
> data in the results set. This was easily done in the old Enterprise
> Manager
> by right-clicking on a Table and selecting "Query."
>
> If I create a new query in the Query Designer within the Management
> Studio,
> the Results pane option is greyed out. Once I'm done designing the query,
> I'm
> automatically returned to the query window containing the SQL code, and I
> cannot bring up the results pane. Running the query will display the
> results,
> but these results are not editable in any way.
>
> One workaround I have found is to use the "Open Table" option for a table
> that is small, and then I am suddently presented with all of the panes
> that I
> am looking for: Diagram, Criteria, SQL, and Results. I can then write SQL
> queries against the table I opened and other tables. This is a decent
> workaround, but there must be a better way to do this.
>
> Thank you for your help.
>
> John
>

"Steve Kass" wrote:

> John,
>
> You can do this if you use the View designer.  Pretend you are
> creating a new view (right-click on Views in object explorer for
> a database, type in the view, and execute it.  If the view is
> updatable, you should be able to modify the results.
>
> Steve Kass
> Drew University
>
> "The Seeker" <The See***@discussions.microsoft.com> wrote in message
> news:F8A228AB-C19D-48F4-9A8F-92B1B83D64D0@microsoft.com...
> > Hello,
> >
> > I'm running SQL 2005 SP1 with the latest hotfix rollup, and I'm struggling
> > with the new Query Designer in the Management Studio.
> >
> > The functionality that I'm looking for is the ability to quickly query a
> > table and produce a results pane that will allow me to quickly edit or
> > delete
> > data in the results set. This was easily done in the old Enterprise
> > Manager
> > by right-clicking on a Table and selecting "Query."
> >
> > If I create a new query in the Query Designer within the Management
> > Studio,
> > the Results pane option is greyed out. Once I'm done designing the query,
> > I'm
> > automatically returned to the query window containing the SQL code, and I
> > cannot bring up the results pane. Running the query will display the
> > results,
> > but these results are not editable in any way.
> >
> > One workaround I have found is to use the "Open Table" option for a table
> > that is small, and then I am suddently presented with all of the panes
> > that I
> > am looking for: Diagram, Criteria, SQL, and Results. I can then write SQL
> > queries against the table I opened and other tables. This is a decent
> > workaround, but there must be a better way to do this.
> >
> > Thank you for your help.
> >
> > John
> >
>
>
>