SQL Server Performance Forum – Threads Archive

How to handle a hypen in server name???

I am trying to query a couple of tables, using linked servers
with an openquery function.
The servers were originally named with hyphens in them…
How do I handle the hypens in Query Analyzer? any help would be appreciated.
thanks,
Angel

Brackets: [my-server]

SELECT * FROM [server-name]… Thsi shud work, or try to create alias for Linked server name rajiv
NewBie-23

Thanks! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by merrillaldrich Brackets: [my-server] <hr height="1" noshade id="quote"></blockquote id="quote">

]]>