Missing Primary key

nunz112 · August 16, 2011 10:35AM

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

Brian Donahue · August 16, 2011 11:42AM

Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).

nunz112 · August 16, 2011 11:45AM

no filestreams

Brian Donahue · August 16, 2011 12:55PM

OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.

jgonzalez · October 31, 2011 1:08PM

Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.

nunz112 · October 31, 2011 1:19PM

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.

jgonzalez · October 31, 2011 1:20PM

Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.

Missing Primary key

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk