Problems with case sensitive SQL Server 2000

Please enter any bugs here. We will check this daily!

Problems with case sensitive SQL Server 2000

Postby egimis on Thu Dec 27, 2007 3:42 pm

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
egimis
Lurker
 
Posts: 1
Joined: Thu Dec 27, 2007 3:32 pm

Return to Defect Reporting (DON'T Post dOOdad bugs HERE)

Who is online

Users browsing this forum: No registered users and 1 guest

cron