Timed outs on Deletes and Updates 1

[opo]

I have a table with more than a million records.
and it is indexed. I can select * from... the table based on a indexed-field with no problem, but any deletes or updates timeout.
Any suggestions?

 

[Guest_imported]

Perhaps select * from sysconfigures and alter the value on your remote query timeout
Also is this MSDE?
If so have you tried using command line OSQL instead of the query analyzer that you are currently working with?

 

[tlbroadbent]

Are other users accessing the table at the same time? Is blocking occurring? How many rows are you trying to delete or update at a time? Do the delete and update statements use the index? are there other indexes on the table? Are any of the indexed columns being updated? What client software are you using? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.