Perhaps I should have clarified a bit more.  Really the common tables and proc were isolated but now we are finding opportunities to make the meta data tables and...

"I wonder if when you compiled your stored proc, you had a GO statement above the CREATE TABLE statement.  If that was so, only the code above GO would be...

(I have taken various steps to try this but here is one.)

1) Delete the table.

2) Created and execute the proc.  (I removed a bunch of fields in the CREATE TABLE...