Post reply

Join two tables from two different sql server intances

  • November 10, 2006 at 9:39 pm

    #115055

    Hi

        I am having two different sql server instances ,i want to join two tables from different sql server instances plz help

  • November 10, 2006 at 11:03 pm

    #671209

    if you have created linked server,then use format "ServerName.DatabaseName.SchemaName.TableName" you can write your sql.  

  • November 11, 2006 at 1:32 am

    #671214

    Can you help me how to create linked server

  • November 11, 2006 at 5:23 am

    #671219

    Check out sp_addlinkedserver in the books online.  I can't give  you the exact syntax without asking much more info !

     

    Message back if you have problems creating it.

  • November 12, 2006 at 4:45 am

    #671236

    I tried sp_addlinkedserver ,still unable to find the solution, what information u need from my side let me know

     

  • November 12, 2006 at 6:20 am

    #671237

    What code did you use with sp_addlinkedserver?

     

    Can you do a simple select from the remote server?

     

    Like so : Select * FROM RemoteServer.Master.dbo.SysObjects

  • November 12, 2006 at 9:19 pm

    #671260

    Hi

      Thanks for the help, i changed few settings in sp_addlinkedserver now its working fine.

Viewing 7 posts - 1 through 6 (of 6 total)

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