<div>
Sure, here's how you could create it (the linked server is called &quot;test&quot; here):<br />
<br />
EXEC sp_addlinkedserver @server='test', @srvproduct='', @provider='SQLOLEDB', @datasrc='YourServer\YourI<wbr />nstance'<br />
<br />
More info: <a href="http://msdn.microsoft.com/en-us/library/aa259589(v=sql.80).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa259589(v=sql.80).aspx</a>
</div>


Sure, here's how you could create it (the linked server is called "test" here):

EXEC sp_addlinkedserver @server='test', @srvproduct='', @provider='SQLOLEDB', @datasrc='YourServer\YourInstance'

More info: http://msdn.microsoft.com/en-us/library/aa259589(v=sql.80).aspx [http://msdn.microsoft.com/en-us/library/aa259589(v=sql.80).aspx]

<div>
<div class="content wysiwyg-content">
I have two databases that have been backed up from production. &nbsp;The stored procedures in one of the databases have references to a linked server connection to the other database. &nbsp;In production, these two database reside on different servers. &nbsp;I have backed up both databases and restored both of them to my default instance of Sql Server on my development machine. &nbsp;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?
</div>
</div>


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?

LinkedServer Connection to Same Database Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.