Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Andural69
Starting Member
2 Posts |
 Posted - 2010-03-01 : 13:38:20
|
| have view1 that uses tables1-5, creates fine.We have to go back and update something based on what's in that view. I can do a select * from view1, table1. Np, but if I add view1.field1 = table1.field1, it just querries and never comes back. I have to cancel. Now, the code seems fine as it's been working for years and working on other dbs on the same server. It seems to be the field is locked.I looked at the data and the data looks fine, not nulls or anything odd. I've done a sp_who and checked processes and there's nothing outstanding. I think that a stop and start would work, but it's a production server and that's not reasonable.How can I figure out, what's stuck or locked and fix it? |
|
|
Andural69
Starting Member
2 Posts |
Posted - 2010-03-01 : 15:33:48
|
| Not sure what happened, I couldn't find any locks or open transactions, but I did a update statistics and it works fine now. |
 |
|
|
|
|
|
Table seems to be locked or something**CLOSED