I have tried to right click on the row itself and delete it(it goes away until I run the query again), or run a "delete from" query(says row has been affected). I get no errors, the row just doesn't really go away. I did not create this database and am not sure what setting would cause this behavior. I am a .NET programmer that works with SQL 75% of my day, however, I do not know all the ins and outs by any means. Any help on this would be great! I need to get rid of some really old data.
Thank you in advance,