• ok for me the fix is easy;

    there's a much better, award winning, peer reviewed and rather famous script to help handle things like reindexing.

    it's been deployed by more businesses, on bigger servers and databases than i will ever have the pleasure of working on.

    replace your current job with one using this scripts instead.

    http://ola.hallengren.com/

    (one of the best tools in my toolbox)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!