August 22, 2007 at 7:53 pm
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
August 22, 2007 at 9:35 pm
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"
August 24, 2007 at 3:31 pm
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