Results 1 to 2 of 2

Thread: Linking Server

  1. #1
    Join Date
    Aug 2008
    Posts
    26

    Unanswered: Linking Server

    Hi,

    In oracle you are able to link the oracle database to a specific SQL Server database, can we do this on SQL Server, I want to link the SQL Server to a specific SQL Server database not the entire SQL Server, sp_addlinkedserver only allow me to link a SQL Server to another SQL Server, is this correct?.

    Regards,

    Thai

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You link to an instance, but the database access depends on the account you use.
    So you could use an account that can only access your required database when you link the server.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •