Dear All,
I have just noticed the relationship between upper/lower case of letter used in table name and columns comments/table contents
As you can see on the pictures: in the 1 case the comments work correctly in the 2 case it is not
The only difference is dwh_dim_date and dwh_Dim_date - and this is the issue. Are you able to adjust the default procedure (but don't know where) to retrieve the data using upper() or lower() case to annihilate the tables naming issues?
in fact the queries :
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME = 'dwh_dim_date';
and
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME = 'dwh_Dim_date';
Give the same result - but there has to be the issue!
orzechto