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

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

Sounds like you (or your DBA) should avoid using such characters in server names! I hate seeing SQL that is full of square brackets!