SYMPTOM:
When user attempts to update the warehouse table name in Architect, following error message appears.
"The database table name xxx entered is invalid. The warehouse xxx does not contain such table"
SELECT DISTINCT S.name NAME_SPACE, T.name TAB_NAME?
FROM sys.all_objects T?
JOIN sys.schemas S on T.schema_id = S.schema_id?
WHERE T.type IN ('U', 'V') AND S.name IN ('dbo', N'#Login_Name#')
SELECT DISTINCT S.name NAME_SPACE, T.name TAB_NAME
FROM sys.all_objects T
JOIN sys.schemas S on T.schema_id = S.schema_id
WHERE T.type IN ('U', 'V') AND S.name IN ('xxx', N'#Login_Name#')