We have an ASP.NET application that uses SQL statements, where table names are unqualified. When compiled, it works fine, but when uncompiled, it complains and errors out, saying these tables dont' exist.
(Qualified name looks like Select * from MyDatabase.mySchema.MyTable ;
Unqualified like Select * from MyTable)
If you try these queries on the database, by yourself, it will take only the qualified names.
What's going on? I thought Compiled vs Uncompiled apps should perform the same way codewise.
What exactly do you mean by "Compiled" here?
I don't think the problem you are having is what you think it is. Sounds more like a security context issue where the user context you are executing the queries under in one case defaults to passing queries to myschema and the other defaults to dbo.