I would have thought that this is the issue with sql server not TS box. So in a multi-user network enviornment at school it would be the same issue. I thik the SQL server supports Strict two-phase locking and non-strict two phase locking as well as Update Lock etc so it takes care of issues of two exact records being update/modified at the same time be different users. If this functionality is not utilised by capita developers then its their fault really! cos they should be doing this to prevent this kinds of things happening. We use the full SQL server 2000 with our sims system and have never had a problem.
I will however inform our local support people at LEA to see what they say and if they have heard of this problem.
It is to do with the way the client prog handles input. I think it holds stuff in a temp file for a bit before a commit to the Server side.
There are currently 1 users browsing this thread. (0 members and 1 guests)