Thanks for pointing out the second bug- I have 2 projects that are affected by this! However, your suggested fix does not work.
This I think is more correct:
SELECT
COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMN_DEFAULT, NUMERIC_PRECISION, NUMERIC_SCALE, ORDINAL_POSITION
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
SUBSTRING(COLUMN_NAME, 1,5) <> '__sys'
SUBSTRING(COLUMN_NAME, 1,5) <> '__sys'
Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.