Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    31

    Unhappy Unanswered: Accessing tables in another server!

    hi this might seem simple to all the techies out there but pls bear with me cos i am a novice to SQL Server 2000.

    Q: Is it possible to create a trigger on a table in a current server(For eg. Server1) that can select/insert/delete/update a table in ANOTHER SERVER(Server2)?

    I was exploring options of using a distributed partitioned view but i am still very much lost...

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Use a linked server. See BOL for details.

  3. #3
    Join Date
    Nov 2003
    Posts
    31
    If i used a linked server is a distributed partitioned view still necessary? can i just use a four-part-name in my queries to modify data? eg. servername.dbname.dbo.tablename

  4. #4
    Join Date
    Nov 2003
    Posts
    31

    Lightbulb Linked Server

    Can someone just list out the steps briefly for me? Or just tell me if i am right..

    1. create linked server(eg.server2) (I have done that)

    2. create distributed views on server1

    -creating the distributed views i understand that i can use OPENDATASOURCE or OPENROWSET or just a four-partname right?

    After creating the distributed views can i use a four-part name to make references to the remote databases?Can i also insert to those databases?

Posting Permissions

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