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?

Ok it turns out the problem is even worse. I figured just as a temporary fix, I would use that new table I created that is identical to the original table and just change any views that query the original table to query the new table instead. It worked fine for the first view, but when I tried to update the second one, the same thing happened and Enterprise Manager froze. Sigh...

Hi,

Very first check if ur Transaction log is free or not. If not Truncate the Log using backup or other ways.

Otherwise it seems ur tables are inside an incomplete transaction. Check out from Enterprise manager Management -->> Current Activity utility an dfigure out if any Deadlock like thing sits tehre. U can release it write away. If users are not connecetd, u can kill their process from here irself. If this doesn't work, U must restart SQL Services. It will release all the resources and locks and transaction.

Hope this helps.

B. Anant

That's exactly what it was!! Thanks for the help. I found the screwed up process and killed it and everything is ok now!