i have an stored procedure that inserting record to table and with the scope_identity inserting the ID to another table
but..some times (something about one record to 100) the first table miss the record while the second has the id inserted
and when i'm checking those tables i find many ID's that in the second table - but disappear in the first one.
is anyone knows causes of this ?????
thanks for the help !!!!
j.cave