Sunday, February 19, 2012

Error while running DDL Script

Hi All,
SQL SERVER 7
I am trying to synchronize 4 db from staging to development server.
all the 4 db r present on development but not in synchronization
with the staging. im not able to restore the db directly as the
sort_id is different b/w two servers. i am creating a DDL script of
.sql file and creating a temporary db and running the .sql file and
import data and then restoring it to the original db. i was able
to do it for 3 db. but fourth db gives an error when i run the
.sql for one stored procedure

the error is
"insert error:column name or number of supplied
values does not match table defnition."

I tried checking out
the datatypes of all the columns stated, they r same.

pls let me know if anyone has any idea regarding this. as this is urgent

TIA
Regards
AdilHaven't you tried with BCP?|||That's a DML error...

Post the offending script and we might be able to help..

Also if you double click on the error it'll bring you to the offending clause...

No comments:

Post a Comment