Some tables in SQL Server require [user]. [Table] and others not, why is it and can I force it?

Question

As the name implies, I'm confused by why some tables in my database fall if you are something like:

SELECT * FROM [user].[table]

And yet it works great on other tables.

I am testing some code that will end up on a server that cries if you are not using [user]. [table], so I really would like to force this on my machine.

Can someone explain why this is happening and maybe show me how to fix it.

Additional Information

Here is the message that I get when I try to run a request using [user]. [table], not just [table];

[Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'Usr.tbl'

Answer 1

, [user], . , , , . - , , . , emptry . "YourDatabase- > Security- > Users" ( ), .

Answer 2

"" - ,

, dbo.table user.table .

SELECT * FROM table dbo.table. , / , thatschema.table

:

• ALTER SCHEMA .. TRANSFER..,
• , , CREATE, ALTER, SELECT, ,

. " " MSDN