Indexing and DTS

Indexing and DTS

 

  

I have a quick question, I have a maintenance plan that goes out and
checks indexes, but at the same time there is a DTS job that is moving
data across to another server. These start at the same time. Is this
going to fail data from being moved? The reason I ask is that I've been
having issues w/ our reporting server's tables being empty, when there
should have been data otherwise. Is this the result of these two running
at the same time?

Thanks,

MG

MS Sql Server LazyDBA home page