Create synonyms for the missing objects, SQL Server doesn't check if the object really exists or not. You can then create a proc that references the synonym. When you are ready, drop the synonym and create the real object with the same name.
create synonym TheObject for AnyNameHere
create procedure test
as
begin
select * from TheObject
end
- This reply was modified 3 years, 2 months ago by DNA_DBA.