MS SQL Server - Errors Copying DB Objects between Servers and Databases

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Errors Copying DB Objects between Servers and Databases

Larry Bird

2005-11-30, 1:23 pm

I have SQL 2000 installed on two different machines. I'm trying to copy a
database from machine A to machine B. I've created the database on machine B
and I'm now trying to copy the Database Objects from A to B. During the Copy
I get the following error:

[Microsoft][ODBC SQL Server][SQL SErver] Invalid Column Name AAAAA
[Microsoft][ODBC SQL Server][SQL SErver] Invalid Column Name BBBBBB
[Microsoft][ODBC SQL Server][SQL SErver] Invalid Column Name CCCCC

I'm not sure I understand the problem since the column names don't exit in
any of my tables.

How do I fix this problem and redo the copy?

Thanks

Sponsored Links