Thanks for the response, I was unaware that the position from ordinal_position in information_schema could be different than the column_id in sys.columns. The column order matched between the two...

Ah yes, you are completely right about that, and that I have fixed. Unfortunately, what is done is done, and I don't want to shut down the entire database...

Honestly I don't understand what you mean be fixing the root... these are fk constraints that need to be there; so enlighten me!

I figured the problem out. I had to nocheck the fk constraints referencing the table that was being switched.

Thanks!

I can't post the particular report to the public. I will try to reproduce it without sensitive data.

Thanks for the comments concerning the contracts. They are being reviewed and so far it seems that performance is most of the basis for separation. Legal issues may...