Post reply

Joining the TABLES from DIFFERENT DATABASES & From DIFFERENT SERVERS..

  • June 11, 2008 at 1:14 am

    #192073

    I'm Using Asp.Net with C# & Sql Server 2005..

    How to Join the TABLES from DIFFERENT DATABASES & From DIFFERENT SERVERS..

    I'm having Two Tables(Emp_Info & Cat_Info) in Different Servers(Employee & Categories respectively).. there Database Names(Emp_Notice & Cat_Notice)..

    How to Join these TABLES..

    Thank You..

  • June 11, 2008 at 1:27 am

    #827094

    1) Add linked server

    2) SELECT column_list FROM Server.Database.Schema.Table

  • June 11, 2008 at 1:36 am

    #827097

    What to do IF I HAD UserName & Password for second Server..

  • June 11, 2008 at 6:17 am

    #827185

    Hi,

    When you create a linked server, you would have given the credentials there itself..

    Regards..

    Vijay.

    Warm Regards,
    Neel aka Vijay.

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

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