Marco,
What's the checkpoint interval setting on the SQL Server?
Cheers,
Andrew
>When i update a certain table in SQL Server (begin tran, select with (updlock), update, commit tran) and query the record immidiately after, very often the change is not yet noticed. It can take up to 30 minutes before the record seems to be updated.
>
>Can anyone tel me what could cause this behaviour?
>
>Marco.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.