Re: Editing tables in Query Analyzer

#1

mjm (AT) barwonwater (DOT) vic.gov.au (Michael McGarrigle) wrote in message news:<9d0cafdc.0308042222.762a1f2a (AT) posting (DOT) google.com>...

Quote:

I am trying to update some rows in a table using Query Analyzer.
Using the Object Browser and selecting one of the User Tables,I then
right click on this table.
I can click on the Open option to view all rows but I want to choose
the Edit option but it is dimmed.
Is there some setting that needs to be enabled to allow me to make the
appropriate changes to this table. I have searched thru BOL but can't
seem to find anything.
I am logged on as sa

Thank You in advance.

Edit is for editing code in stored procedures, functions etc., rather
than working with data in a table. The best way to modify the data is
to write an UPDATE statement, especially if you have to change
multiple rows, or the table contains a lot of data. But if you want to
do it graphically, then you can use Open and edit the data in the grid
that's displayed.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Editing tables in Query Analyzer

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Editing tables in Query Analyzer - 08-05-2003 , 04:11 AM