Can't Modify or Delete table
Hi guys, well all of a sudden SQL Server decided that it would not let me modify or even delete a table. It's not a permissions problem because I am the administrator. I can view the data just fine, but when I try to change the data in the linked table through Access, it gives me a Server timeout error. When I try to do it through Enterprise Manager, it just immediately freezes Enterprise Manager. It will also not allow me to change any of the table's properties, though I can view these just fine as well. Just out of curiosity, I created a table in the same database that is completely identical to the problem table and copied all the data over to it, and this new table works perfectly fine. Any ideas?