>Hi Everyone,
>
>I have a table in my application which maintains primary key references.
>These are allocated in a stored procedure as new records are appended. I am running into a problem where I get occasional duplications, e.g. out of 3 months sales, 14000 records, there are approximately 25 records with duplicated references, in groups of 2, which causes some havoc with reporting!!
>
>ie. 2 records with key 33936, 2 with 33937...etc and they always seem to occur in small groups.
>
>The particular customer in question has a vanilla NT server running on a 10mb coaxial ethernet network with 6 workstations. The stored procedure is obtaining a record lock on the primary keys table, incrementing the value, storing it to a variable, unlocking the
>record and then returning the value which is specified as the Default value in the table for the primary key field.
>
>I am at a real loss with this problem and pulling my hair out (whats
>left!!!). I've no real idea where the cause is, whether its a server problem (write back caching etc). Does anyone have any experience of this type of issue?
>
>Any suggestions, hints or past experiences would be really appreciated.
>
>
>Many thanks,
>
>
>Paul
Without seeing your exact code, we can't tell you what is wrong.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer