Thanks for posting this work around, It was useful to me. I thought I would restate the change description in simple terms for anyone else who comes along as it took me a couple extra minutes to figure out... hope you don't mind.
To get the app to work you need to modify two files.
TableQuery.sql
Replace the line describing the leftJoin with
LEFT JOIN ::FN_LISTEXTENDEDPROPERTY('ProgrammaticAlias', 'user', 'dbo', 'table', default, default, default) AS ExtendedProperty ON (INFORMATION_SCHEMA.TABLES.TABLE_NAME = ExtendedProperty.objname COLLATE Latin1_General_CI_AI )
and in the file ColumnQuery Replace the leftJoin line with
LEFT JOIN ::fn_listextendedproperty('ProgrammaticAlias', 'user', 'dbo', 'table', '#TableName#', 'column', default) AS ExtendedProperties ON ( INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME = ExtendedProperties.objname COLLATE Latin1_General_CI_AI )
Recompile and you should be good to go.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Got the app to work with SQL2005 by changing the join for both the Table and Column queries. Just change the JOIN's ON clause to:
ON ( INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME = ExtendedProperties.objname COLLATE Latin1_General_CI_AI )
This fixes the collation error that you get with the shipping versions.
Thanks for posting this work around, It was useful to me. I thought I would restate the change description in simple terms for anyone else who comes along as it took me a couple extra minutes to figure out... hope you don't mind.
To get the app to work you need to modify two files.
TableQuery.sql
Replace the line describing the leftJoin with
LEFT JOIN ::FN_LISTEXTENDEDPROPERTY('ProgrammaticAlias', 'user', 'dbo', 'table', default, default, default) AS ExtendedProperty ON (INFORMATION_SCHEMA.TABLES.TABLE_NAME = ExtendedProperty.objname COLLATE Latin1_General_CI_AI )
and in the file ColumnQuery Replace the leftJoin line with
LEFT JOIN ::fn_listextendedproperty('ProgrammaticAlias', 'user', 'dbo', 'table', '#TableName#', 'column', default) AS ExtendedProperties ON ( INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME = ExtendedProperties.objname COLLATE Latin1_General_CI_AI )
Recompile and you should be good to go.