I do prefer the second one its easy to join columns when the column names are same and also easy to remember them.

Why not the report services can't be installed in remote servers. They can be done. Only thing is they will have thier databases here in the local database server and...

TO add more info just removing rows from the table will not free up disk space as there might be file level and table level fragmentation. You need to defrag...

You need to free up space used by the database. Shrink the data file so that your unused space will be taken by the OS.

You should set a complex password by default for sa did you do that.

What is the version of MDAC? is latest SP applied.

You can use SSMS to change the password. Move to the folder security and logins where you will find the sa user right click and properties and change password.

You can use profiler to trace and track when the object gets created. That should be helping you.

Then give select @ db level and control permissions @ object level so that he can grant permission to other users.

sp_helprotect will not be useful. Can you list the extended procedures and check what is the xtype of them and include that.

Where they same editions and build numbers?

Yes that can be done if you are using windows native backups move the backup file to disk and then restore from disk.

Use the import/export option with 2005 in SSIS, they use SQL native client than using ODBC\OLEDB providers. Also post the exact error message so that we can confirm if that...

But this is not the right solution. You have uninstalled and reinstalled so that you have avoided the problem that you got earlier.

Then think of using Quest's co-efficient.