I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a month it would happen and now it is almost every other day it happens. Please help!
September 10, 2009 2:18 PM