I have a DTS scheduled job that fails every so often. Maybe once a week, but I never go a week without a failure.
The job drops and recreates 3 tables copying data from the main db.
I notice that if I separate the job into 3, 1 table per job, I never have a problem.
Anyone experience this problem?

Thanks in advance,

Justin Gilli







MS Sql Server LazyDBA home page