Post reply

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

  • January 23, 2013 at 1:31 am

    #267540

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

  • January 23, 2013 at 1:33 am

    #1579938

    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.

  • January 23, 2013 at 1:46 am

    #1579944

    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