SQL 2005 Server Management Studio

5 Jun 2006 3:24 PM

Don Potts

Hi,

How do you edit grid results from a SELECT query? It appears the new tool
is missing the capability to edit and delete records from the results grid.
SQL Server 2000 Enterprises Manager allows editing of grid results.

Thanks,
Don

5 Jun 2006 3:46 PM

Keith Kratochvil

SSMS allows you to pull the data in different ways. One method is a simple
query. This returns data to the results window in grid or text form. As
you have noticed, this data is not editable (similar to Query Analyzer).

You can choose "Open Table" within the Object Explorer. This gives you an
editable grid that allows you to change data within the table.

--
Keith Kratochvil

Show quote

"Don Potts" <d**@checkassist.com> wrote in message
news:uN0BjQLiGHA.4592@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> How do you edit grid results from a SELECT query? It appears the new tool
> is missing the capability to edit and delete records from the results
> grid. SQL Server 2000 Enterprises Manager allows editing of grid results.
>
> Thanks,
> Don
>