ColdFusion · Database exception
What does Invalid Object Name (SQL Server) mean in ColdFusion?
SQL Server can't find the table or view a query references under the login's default schema — frequently because the table was migrated or scripted in with a non-default owner (a custom account instead of dbo) rather than because the table is genuinely missing. The DSN's default database can also differ from where the table actually lives.
SQL Server can't find the table or view a query references under the login's default schema — frequently because the table was migrated or scripted in with a non-default owner (a custom account instead of dbo) rather than because the table is genuinely missing. The DSN's default database can also differ from where the table actually lives.
Qualify the reference fully (database.schema.table) to bypass default-schema ambiguity, and if migrated tables consistently show this, reassign their owner to dbo instead of patching every query that touches them.