• I had same scenario of moving 8 databases from a SQL 7 server to a newly built SQL 7 server some time ago. I used the article Greg Larsen provided (246133) and it worked fantastic. Two additional articles that were of help are:

    http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b314546

    http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b240872

    Both above articles have links to other MS articles that can be of assistance.

    Dave Gradoville, MCDBA


    Dave Gradoville, MCDBA