Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    11

    Unanswered: Create View from 2 servers.

    Hi,
    Can we create a view from databases residing on different servers?
    Thanks,
    Harriet.

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    yes, you can do that. Setup one server as a linked server on the other one and you can access objects in the linked server by using their full names (server.database.owner.objectname). See for more info on setting up a linked server in books online.
    Johan

  3. #3
    Join Date
    May 2003
    Posts
    11
    hey, thanks a ton buddy. It was of great help.
    Thanks once again

    btw, do you have any idea as to how I would be able to run udfs on version 7.0?
    Cheers!!
    Hsm

Posting Permissions

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