I am trying to use copy objects to copy all database
tables and stored procs from a Windows 2000 SQL 2000 SP4
server to a Windows 2000 SQL 2000 SP4. I get the
following message "[MICROSOFT][ODBC SQL SERVER DRIVER]
[SQL SERVER]INSERT ERROR: COLUMN NAME OR NUMBER OF
SUPPLIED VALUES DOES NOT MATCH THE DEFINITION TABLE.

The DB I am trying to copy from was orginally on a SQL 7
server and was restored to the sql 2000 server.

I can't used copy database because the database I want to
copy to has some stored procs that I want to keep.

Any help most apprerciated.

Thanks

Danielle