Hi All,
   Trying to run an sql statement

select * from employee a, DA-T-BACIM01.my_database_test.dbo.employee b
where a.employee_code=b.employee_no


I get the following error:
Error:170 at Line:1 Message:Line 1: Incorrect syntax near '-'.

I am trying to compare tables from one server to another. There are dashes in the server name.
Anyone know how I can bypass this problem?


Vin

try

[DA-T-BACIM01].my_database_test.dbo.employee

some people do not remember to name things properly. This will also give you problems when trying to use windows authentication.

By the way, have you set-up a linked server to the other server?



Sal

Hi,

SQL Server is ready to except any thing enclosed in square bracket. U can use balnk spaces also.U can use reserve words also as identifiers in this way.

Any table name, Server name, DB name with -, blank space etc which are not valid as per identifier naming convention must be enclose within [].

select * from employee a,
[DA-T-BACIM01].my_database_test.dbo.employee b
where a.employee_code=b.employee_no


This will work perfectly with SQL Server. But yes I am not sure how ur application is database nutral with such things.

Hope u got the point

B. Anant

worked!!!!!!!!! You guys rock.

We have the same problem. The answer is to enclose the server name in brackets as in [server-name].

Another way around the problem and the brackets would be to rename the server, eliminating the dashes or replacing them with underscores. This would be DA_T_BACIM01.

Of course the best way was already missed - NEVER USE DASHES OR SPACES IN SQL SERVER OBJECT NAMES, use underscores instead! Dashes and spaces are a royal pain!


Rand

rgerrald, have u ever tried to give a server name with underscores in?? U should try once. Install a server and give machine name like My_Server_2. See what does it say.





B. Anant

I have the same problem with dashes in MeSQL table column names. Unfortunately I can't change the column names.
I've tried everything - including your square brackets.
Please Help!