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 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.

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:
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?

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?

Has anyone received an answer to this question.  Its really driving my user
nuts.  Its as though they removed a vital piece of functionality.

Queries executed from SQL Server 2005 Management Studio can return results
in text, grid, or file formats.  The grid control is read only, but from the
context menu it is possible to save the results to .csv file.  From text
output, the results can be editted directly but you will need to save the
results elsewhere (via copy/paste).  With results file output, you can save
the file directly to disk or a network share for post-processing and
modifications.

Regards,

Keith Wilson
Microsoft SQL Server

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Right click on a table in Object Explorer and select Open Table.  You can
then edit rows much like you did with Enterprise Manager, including tweaking
the SELECT statement.

Show quoteHide quote

problem with SQL 2000 Enterprise Manager display
creating unique index and clustered index in sql server management studio
modifying stored procedure with SSMSE
Server Memory usage\Performance problem
Enterprise Manager Won't Run