Records are being deleted from Live databaseHi,
From last few days our subscribers has reported some issue related to records missing in Live database.
Now again we have the same problem with bunch of users. We have already scanned the delete queries in all the store procedures. Also, we had some doubts that id might be due to a back end application which runs daily. But now we come to know many of the affected users are not using this service.
Can someone suggest how to identify the cause?
FYI, the records are missing from reference table not from main table.