Our SQL Server 2000, for debugging reasons, is setup using a case sensitive collation, although most databases are using case insensitive collations. My Generation worked great until we tried to get an column description (IColumn.Description). This property returns '' although we specified description for some columns. Investigating this, we discovered that MyGeneration 1.3.0.3 tried to execute
SELECT objName, value
FROM ::fn_listextendedproperty ('MS_Description', 'user', 'dbo', 'table', 'Addresses', 'column', null)
UNION
SELECT objName, value
FROM ::fn_listextendedproperty ('MS_Description', 'schema', 'dbo', 'table', 'Addresses', 'column', null)
to get descriptions. The query fails because system databases are case sensitive (specifically objName should objname).
Thanks in advance
E. Gimissis
