Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: 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
    Adil
    Last edited by aadil; 12-02-03 at 18:47.

  2. #2
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Re: Error while running DDL Script

    Haven't you tried with BCP?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •