won't let me delete rows in sql server 2005 management studio

I just want to delete those null rows, i tried to use them 开发者_C百科and it wont even let me edit them, i get the same error trying to delete or edit them.

the problem being that there are a number of rows with just nulls, so when you try and delete just one row it will complain as that row is not unique,

Maybe try a SQL statement to delete the rows, such as

DELETE FROM sop
WHERE Order IS NULL

I have not been able to test this query but it should work for you.