Firstly thanks to you all for helping me out.

I tried what stax68 & GilaMonster mentioned regarding the DBCC but the 2 numbers i get is same (test machine with same DB backup)....

Yes the Primary key is in the Transactions Table and is an Auto Number(Identity column). And it is not possible to enter any more records via any means unless i delete...