@nicholas - Running the job on SQL Server 2008 R2, the restores are running on SQL Server 2005

@bruce-2 - Have commented out the ChangeDBOwner method call...

That was my first approach alright

But if the SQL is wrong I wouldn't have expected the databases to restore.

One more thing, I noticed that after I created the user on the 2008 instance and then script off the login as a CREATE statement it gives me the create...

Also, login for user is all lower case - I read in another article about there being issues of case sensitivity differences between 200 and 2005/2008 with sql logins

Output of first query (to create login on 2005 box):

CREATE LOGIN [test] WITH PASSWORD=0x0100FE58AC4B85EDAC816C6299E7D5605DB3DA94DA224232DF2AB13F02564C47DB72644B963573351DC83A58F66F HASHED, CHECK_POLICY=OFF, SID=0xB2111D54E2518A49B85A4DA2ECD54236

Output of second query to create login on 2008 box:

CREATE LOGIN [test] WITH PASSWORD...

Also tried the following:

DBCC CHECKTABLE ("XXXXXXXXXX", 4);

Getting over 200 errors as below:

Msg 8951, Level 16, State 1, Line 1

Table error: table 'XXXXXXXXXXXXXXXXx' (ID 1934629935). Data row does not have a...

Microsoft SQL Server 2005 - 9.00.3239.00 (Intel X86) Apr 9 2008 22:56:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build...

2005

From what I can see the only way to pull this data out is between the database and opening the dtsx files as XML. Doesn't look like there's any easy...