Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Question Unanswered: SQL Server Views

    Need a Clarification in SQL Server 2000.

    I would like to know if its possible to create a view of a table residing in a SQL server which is not the one in which we r currently working in
    1) Say i have 2 SQL servers( different Boxes) A & B
    I am working in ' B ', can i have a view of a table residing in SQL server 'A' in my system( Server 'B')
    2) Leaving out the network uncertainities, will such a setup give any performance issue when the view is for a table that captures daily transactions running into several
    thousands of records
    3) Is ther any other Alternative to access tables in another SQL sever without going for Views?

    Plz find out and reply ASAP.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    1) Yes.
    2) Maybe.
    3) Yes.

    Check out four part names for more details.


  3. #3
    Join Date
    Nov 2002
    hell I thought the answers were all yes...

    You need to replicate the data for best performance...

    Either use replication (which I shy away from) or set up your own methods...

    What is database B for?

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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