'Cannot find server when run stored procedure

I have a database backup from a client. This database has a SP that I am trying to execute. I am getting the following message:

Msg 7202, Level 11, State 2, Procedure SP_NAME, Line 24 [Batch Start Line 2] Could not find server 'InstanceName' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

I also looked into inside of the SP and see that it references tables that are not in the DB I am running the stored prog from, they are in another DB. Somehow the stored prog runs fine on the client side. The client says they do not use any linked server. Any idea what my error message actual means?

Thanks

sql-server

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Cannot find server when run stored procedure

Sources

Related Questions