how do you edit query results in results pane of Management Studio

I have been running querries in management studio and ocasionally I want to
edit the result set but when you double click on the row and column you want
to edit nothing happens. I have searched google and seen some references to
the same question but no answers. This is a feature I miss from query
analyzer and it appears to have been removed. Can anyone confirm this or
does anyone none the magic hoop to jump though to enable it or has ms taken
to using the DataReader rather than DataSet.

David Hubbard (dghubbard@nospam.com)  writes:
> I have been running querries in management studio and ocasionally I want
> to edit the result set but when you double click on the row and column
> you want to edit nothing happens. I have searched google and seen some
> references to the same question but no answers. This is a feature I miss
> from query analyzer and it appears to have been removed. Can anyone
> confirm this or does anyone none the magic hoop to jump though to enable
> it or has ms taken to using the DataReader rather than DataSet.

I thihk you are confusing two features. As far as I know, you cannot run
a query in Query Analyzer, and then modify the result set.

But I believe that in QA you can right-click on a table from Object Broswer,
and then choose some option thar permits you to edit the table. This
functionality is indeed avaiable Mgmt Studion as well. Right-click a
table in Object Explorer and pick Open Table.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sorry when I mentioned query analyser I meant Enterprise Manager, and I
mispoke on the query. I meant that in the old EM I could right click and
return all rows and then edit results and save. Now in server management
studio when I right click and select open table I get the query message
"Object instance not set to an instance of an object. (SQLEditors)". So I
cannot edit the results. Have you seen this error before?

Thanks

David Hubbard (dghubbard@nospam.com)  writes:
> Sorry when I mentioned query analyser I meant Enterprise Manager, and I
> mispoke on the query. I meant that in the old EM I could right click and
> return all rows and then edit results and save. Now in server management
> studio when I right click and select open table I get the query message
> "Object instance not set to an instance of an object. (SQLEditors)". So I
> cannot edit the results. Have you seen this error before?

I don't know for sure whether I have seen it or not. In any case, that
is not the way it's supposed to work. So it seems that something is fishy.

What happens if you try a table in AdventureWorks?

Are you using the main Mgmt Studio, or the Express version?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

I am using management studio. I will have to load AdventureWorks and let you
know.

Erik,

I finally loaded the adventure works database and selected a table and
select "open table" and still get the message "Object reference...". What
could cause this?