Results 1 to 5 of 5

Thread: Database Access

  1. #1
    Junior Member
    Join Date
    Mar 2008
    Answers
    9

    Database Access

    I have two servers both servers have some databases
    if i want to access from one server database table to other server database table
    how it possible in SQL Server


  2. #2
    Contributing Member
    Join Date
    Jun 2007
    Answers
    65

    Re: Database Access

    Quote Originally Posted by boreddy View Post
    I have two servers both servers have some databases
    if i want to access from one server database table to other server database table
    how it possible in SQL Server
    hi reddy,

    u can use the following query

    SELECT * FROM [DatabaseName].[OwnerName].[TableName]

    [DatabaseName] - Name of the database in which table exists
    [OwnerName] - Name of the target database owner
    [TableName] - Name of the table

    ---V V---
    Vikas Vaidya
    Mark it as Thank if u found the answer useful


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Database Access

    You need to establish the link first between both the servers.


  4. #4
    Junior Member
    Join Date
    Mar 2008
    Answers
    9

    Re: Database Access

    How to link between servers


  5. #5
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Database Access

    follow this link


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact