SQL Table missing info 1

[Jimmy24]

Dear Sir or Madam,

I have a SQL table that provides me a Batch_Number and number of Cycles my transaction will run every month. For some reason my Batch is not running because my Number of Cycles was changed to 0, I need to run a audit to see who, when, why and how was changed. Is that possible to do, if it is would you provide me with some guidance.

Regards,

Jim

 

[hmckillop]

If this is data related change - you can try an get a transaction log explorer such as one provided by luminent.
Unfortunately I dont think you will be able to determine who made this change unless you application does internal auditing or you have auditing via SQL profiler.

As a recommendation, I would suggest setting your users and roles/profiles so as to stop anyone doing direct updates to your data unless authorised to do so.

"I'm living so far beyond my income that we may almost be said to be living apart