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,
AnandSELECT 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!
No comments:
Post a Comment