Incorrect syntax near '-'

Question

i am trying to run a query in another server and need to specify it in the select statement but the server name has got an '-' in it, like server-name. this is producing the error in the title. How can i fix it?

Answer 1

Use square brackets [] around the servername:

select  * 
from    [server-name].[db-name].[schema-name].[table-name]

Answer 2

Also visit this thread for further clarification: http://stackoverflow.com/questions/153861/brackets-in-sql-statements