Hi,

Yes, If the database is saved in SQL server 2008 (100) compatibility mode, then It makes NO difference if I bracket the host, database, schema and table names in the select statement. I get the error. If, on the other hand, I save the database compatibility to 2005 (90) everything works fine. It seems that the problem was because the database was saved in 2008 (100) compatibility mode. I would like to see if someone can duplicate this problem, so I will know if I have a problem in my database or if it is a problem with the 2008 format.

Summary:

Select * from [host].[database].[schema].

WILL FAIL for databases saved in 2008 compatibility (100) mode for a table name of STOPLIST.

Everything runs as expected in 2005 (90) compatibility.