Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    8

    Unanswered: Linked server problem

    SELECT
    A.PATIENTID
    FROM
    xxxx.yyyyy.dbo.Patient A

    SELECT
    *
    FROM
    xxxx.yyyyy.dbo.Patient A


    The first sql does not work and the second one works over linked server.
    Does anybody know????

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Do you get an error? What is it?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Oct 2004
    Posts
    8
    Server: Msg 207, Level 16, State 3, Line 1
    Invalid column name 'patientid'.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check the spelling of the column name when selecting all columns.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    works fine for me.....

    select * from server.database.owner.table A
    will work OK

    select A.column_name from server.database.owner.table A
    wiill work OK too.....

    Spelling most likely problem....

Posting Permissions

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