Help with linked table

[dpm1234]

Hi,

I'm trying to query a table on a remote server.

In Query Analyzer I type:
select * from BRM-ML123.dbname.dbo.table

and receive the following error:
Inccorect syntax near '-'

The dash seems to be giving me trouble. Any advice?

 

[swampBoogie]

select * from [BRM-ML123].dbname.dbo.table

 

[dpm1234]

Awesome! Thanks for the help!!