Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unhappy Unanswered: Pls Help - Urgent handling "-" in query

    Hi,

    i am using sp_addlinkedserver to connect with my another server.
    Let say my current server name is anand and other server name is anand-new

    now sp_addlinkedserver worked ok

    Now i want to fetch some record from the anand-new server.

    I am writing my query in I server (i.e. Anand)


    SELECT TOP 10 * FROM anand-new.NEWSITE.DBO.Xyz_NEW

    I am getting error

    Server: Msg 170, Level 15, State 1, Line 1
    Line 1: Incorrect syntax near '-'.


    Pls help

    Its urgent

    Cheers,
    Anand

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    SELECT TOP 10 * FROM [anand-new.NEWSITE.DBO.Xyz_NEW]
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Sounds like you (or your DBA) should avoid using such characters in server names! I hate seeing SQL that is full of square brackets!

Posting Permissions

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