I made a script today from my dev to prod box and the primary key did not get made on prod which caused the foreign key constraints to fail, any idea why it would have missed it? it was creating the table on prod
nunz112
0

Comments

6 comments

  • Brian Donahue
    Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).
    Brian Donahue
    0
  • nunz112
    no filestreams
    nunz112
    0
  • Brian Donahue
    OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.
    Brian Donahue
    0
  • jgonzalez
    Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.
    jgonzalez
    0
  • nunz112
    Yes I did but I would like it to create the primary key even in these instances especially when this is going to be the creation of the table.
    nunz112
    0
  • jgonzalez
    Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.
    jgonzalez
    0

Add comment

Please sign in to leave a comment.