Time out on table in sql server, anyone know the cause?

[AtomicWedgie]

Hello,

I have had a problem with a table in an sql server database. For some reason it gave a time-out when trying to update through the application GUI. When trying an update via query analyser on the specific table it didn't finish the update, the query execution time just got higher and higher....so i quit it. When logging in directly to the database via sql server and opening the specific table all of a sudden the update (that i did with the query analyser) was there.

Is it possible that for some reason the specific table was locked, and opening it directly via sql server unlocked the table and then the update was completed? Or has it got o do with something completely different?

Thanks in advance,

Atomic Wedgie

 

[fluteplr]

It is possible it was locked.

Opening it in enterprise manager would have no affect on that however.

Are there any triggers on the table that might be taking a long time to run?

 

[AtomicWedgie]

As far as i know there are no triggers on that table.