Editing data in 2005 Mgt Studio

[amy88]

Hello,

I recently migrated from SQL 2000 to 2005. In SQL 2000 Enterprise Manager, I was able to edit and commit data on-the-fly directly from the results pane. Action->Open Table->Query. I could write and execute a select statement and the results pane would show the resulting data. The data is editable and instantly updated.

I can not see how to do this in SQL 2005 Management Studio. I can open the table, return all rows, and edit directly there, but that is a pain when you have a large table.

Is there some way to edit data in a query results grid in SQL 2005 Management Studio as you would in SQL 2000 Enterprise Manager?

Any help appreciated.

 

[amy88]

I have found that this can be done, but it's a little more difficult than in 2000:

Right click on table and open
Stop query
Right click in the results window
Panes
Select SQL (to get the SQL/query pane)
Type or paste your SQL statement
Right click in the SQL pane & execute
Then you can edit in the results pane