I need to use a select statement to query a linked server. The following does not work, probably because of the embedded spaces in the database name.
select * from [EOSK\DMZ].[BIG JOB COSTS].[dbo].[DNUM]
select * from [EOSK\DMZ].[BIG_JOB_COSTS].[dbo].[DNUM]
Why? The item with spaces in the table name is not under my control. Anything I can do.