Recover data from a operation mistake

  • I'm using  a ERP app on SQL200 and sometimes the users input several serials numbers of merchandaise to ship and suddenly appears deleted, There is anyway to get the command batch sent from my application to SQL Server like Profiler's Trace display  so i can to reprocess thats commands and aviod to retype again?

     

    Thank's in advace for you help

     

    Alex Cast

  • Hi

    First find out why some serial numbers "appear" deleted. If u can correct this issue then there is no need to reprocess again.

    About reprocessing commands this is my suggestion (maybe completely wrong)...

    U can define another table which contains the serial numbers when they are inputted by users. U can have a job which runs at frequent intervals and checks whether serial numbes appear deleted. If so the job can call the procedures\functions or whatever that needs to happen then.

    "Keep Trying"

  • Create DDL triggers on the table which host serial numbers also look into SQL 2000 BOL for "finding specific events in" under  traces. also look into sp_trace_xxxxx that will help to capture any events from server side.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply