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
Comments
6 comments
-
Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).
-
no filestreams
-
OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.
-
Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.
-
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.
-
Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.
Add comment
Please sign in to leave a comment.