Do I need a linked server if both databases reside within the same SQL Named Instance?

  • DatabaseA needs to be able to retrieve data from DatabaseB on a periodic basis. Both databases reside on the same instance (SERVER\INSTANCE).

  • If they exist on the same instance no, use cross database queries

    Like the following.

    INSERT INTO DatabaseA.dbo.Mytable SELECT Col1, Col2 FROM DatabaseB.dbo.MyTable

    If the database was on a different server, then yes a linked server would be needed.

  • Cheers Anthony! Exactly what I was after... many thanks.

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

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