PhilMuller
asked on
deleting table rows with SQL Server 2005
Is there any way to directly edit a table using SQL Server Management Studio (2005)? I need to delete rows in a table as you could do under Enterprise Manager, but I can't see a way to do it with the new software.
Right click on the table --> Open table
ASKER
I do that, but it only lets me delete values in individual cells. How do I delete the whole row (record).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, so I click the arrow to select the whole row and then right-click and click Delete. It prompts me that I am about to delete a row and I say OK. It then tells me that the data has changed (I haven't changed it), but to commit changes anyway, click Yes. I click Yes and it tells me it can't delete the row because the data has changed! Just to make sure I wasn't going crazy, I completely exited out and came back in and nobody else is in the database and I still get the same messages.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried to create a primary key, but it wouldn't let me. There were duplicate records (keys) and so it couldn't create the primary key. The duplicate record problem is the problem I'm trying to fix in the first place. I then try to change values in the row to make the duplicate records unique (so I can later remove them), but it wouldn't let me. So, it seems like a catch-22. I've figured out another way to solve this problem that is actualy a bit more efficient. Thanks for your help though.