Any reason I can not use EXEC sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")' ?

After I run SHOWCONTIG they look fine afterwards.

I backed up and restored to a test server. ...

Ok, same deal. The script will work in SQL2000 or SQL2005.

However, you should be posting in the SQL2000 forum, not the SQL2005 forum. The advice for that platform...

Ok, so If this folder is not being shared out I do not know of a native way to monitor the data files to see where the problem is occuring...

However,...

Just use the new SSIS import and export wizard, it takes you right through it. Create a new Integation Service Project, then Project>

Import and Export Wizard.

If you cant figure...

Dave's suggestion is right on. Create it part of a job to change the server name afterwards so it's all automated.

Another suggestion is instead of copying the master database...

Start>Administrative Tools>Computer Management.

Action>Connect to another computer.

Type in Server Name

click on Shared Folders>Sessions>OpenFiles

Look for the username that is accessing that file.

Ok, never mind. I looked at your code and I saw what was happening...

Try this if its not a mission critical system to see if its your backup job...