Can anyone help?
variable after an insert it constantly returns the wrong value
eg I get 17640 instead of 1.
The right value is inserted into the table but causes problems with FK
I have tried:-
1. DBCC CheckIdent.
2. Truncating the table (with and without checkpointing)
3. Dropping and recreating the table
4. Stopping & starting the Server
All with no success.