MS SQL Timeout problem

Hi,

This works fine:

SELECT * FROM mytable
where fIndex = '12345'

But this times out:

UPDATE mytable
SET fEmail = 'me@mydomain.com'
WHERE fIndex = '12345'

Any ideas? fIndex is indexed and I also added an index to fEmail.

Is findex integer or char? How many rows in mytable?

Try this:
UPDATE mytable
SET fEmail = 'me@mydomain.com'
WHERE fIndex = 12345

If running from query analyser, increase query time-out. may or may not help.

Select tools/options and then select Connection tab. Then increase value for 'Query Timeout' parameter.

Changing the timeout parameter usually just masks the problem. When you look at the query plan of the update statement in query analyzer (paste the query in query analyzer and hit CTRL-L) what does it show?

Thanks for your suggestions, guys. In the end it turned out to be something slightly different.

The previous lines of code opened the SAME record to get some details from it; this recordset was not closed when I tried to do the update so it was, presumably, locked out. All I did was close the recordset and then perform the update and it all worked.

I will allow myself to sleep now.