Post reply

Alter Procedure With Invalid Object Name

  • October 20, 2021 at 12:20 pm

    #3942364

    We are trying to update a stored procedure to reference objects that don't yet exist in preparation for when they will exist. The problem is SSMS doesn't like that and gives the error that there are invalid objects. Is there a way to trick it into allowing the invalid references?

  • October 20, 2021 at 1:09 pm

    #3942396

    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 4 years ago by DNA_DBA.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply