I have a database that is hosted by a Microsoft 2000 SQL Server. I'm running into a strange problem that I'm not sure how to fix or how it started.
For the sake of this question, the database is named "MyDatabase". There is a SQL user named "MyUser".
When I launch Query Analyzer, I will login as this user (MyUser) and connect to the MyDatabase. The problem I started having is that anytime I perform a simple query on table I have to supply the database name in front of the table.
So for example, this used to work:
SELECT * FROM tableName;
Now I have to do it this way:
SELECT * FROM MyDatabase.tableName;
If I do it without the database name supplied like the first example, I will get this error:
"Invalid object tableName".
I used to NOT have to do this. I believe something is changed. Can someone please help me understand how to switch this back?