tsql - SQL Server dbo and schema -

I stumbled into some strange T-SQL code in SQL Server 2005, which I'm trying to understand is that How can work be done.

If TBSCnario has two tables called in two separate schemas, then there is a cash schema and the second dimension is in the schema.

What do we expect when we query SELECT * FROM dbo.tblScenario? How to dbo a map of one of these schemas in a reliable and predicable way?

For some reason this really works but why do we not know

We are going to fix it, so it is clearly telling SELECT * FROM Dimension.tblScenario , But I was curious.

Thanks,

Phillip

check OLTP ... 1) Does DBO.tblScenario have a view?

OK, it seems that you are working with SQL Server Analysis Services (SSAS), which is related to dimensions, mimizing tables, etc. More info: