SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / Do I need a linked server if both databases reside within the same SQL Named Instance? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 02:51:38 GMT20RE: Do I need a linked server if both databases reside within the same SQL Named Instance?http://www.sqlservercentral.com/Forums/Topic1410394-391-1.aspxCheers Anthony! Exactly what I was after... many thanks.Wed, 23 Jan 2013 01:46:54 GMTShabbaRE: Do I need a linked server if both databases reside within the same SQL Named Instance?http://www.sqlservercentral.com/Forums/Topic1410394-391-1.aspxIf they exist on the same instance no, use cross database queriesLike the following.INSERT INTO DatabaseA.dbo.Mytable SELECT Col1, Col2 FROM DatabaseB.dbo.MyTableIf the database was on a different server, then yes a linked server would be needed.Wed, 23 Jan 2013 01:33:43 GMTanthony.greenDo I need a linked server if both databases reside within the same SQL Named Instance?http://www.sqlservercentral.com/Forums/Topic1410394-391-1.aspxDatabaseA needs to be able to retrieve data from DatabaseB on a periodic basis. Both databases reside on the same instance (SERVER\INSTANCE).Wed, 23 Jan 2013 01:31:38 GMTShabba