May 12, 2003 at 5:29 pm
When I am try to import all objects from my old sql server to new one I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition.
It happens after 96% is complete. It copies all tables but leaves about 30 stored procedures. So i think its a stored procedure which is causing the problem. How can find which one is it, or suggest some good way to import the database.
May 12, 2003 at 8:06 pm
How about scripting the stored procedures from the old database (Enterprise Manager -> Objects -> Generate SQL Scripts -> etc.), and then pull the script into Query Analyzer and select and run chunks of them (like 20 questions) until you narrow down the bad procedure?
May 12, 2003 at 11:23 pm
thamks, i found the error
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply