A strange sql bug (multipart identifier) about sql server

Question

I encounter a strange bug - multpart identifier "tableabc..fielda" cannot be bound today.

In the above sql, I accidentally add one more dot in the query.

I key in 2 dots in the sql query.
It works in the development server (mssql 2005).
When it comes to staging server (also mssql 2005), the above error occurs.

What's the cause of that?
Both databases are mssql 2005. However, one works fine and another one fails.
Why?

Answer 1

Normally you use 2 dots to denote the default schema, i.e. database.schema.table as database..table

You seem to be suggesting that tableabc is a table, and fielda is a column, so you wouldn't have a level between them?

can you confirm what these objectnames are suppose to be?

Do these/this object exist on the staging server?

What is the default schema of the user you are connected as?