I have two databases that have been backed up from production. The stored procedures in one of the databases have references to a linked server connection to the other database. In production, these two database reside on different servers. I have backed up both databases and restored both of them to my default instance of Sql Server on my development machine. My question is, is it possible to create a Linked Server connection back to the same instance of Sql Server so that the stored procedures work without any modifications to the linked server references?