Unable to resolve object '[INFORMATION_SCHEMA].[TABLES]'

georhill

The "message report" (v2.6.1.47) has many occurences of the error message above. In one example the stored procedure contains this code:
SELECT 1
FROM [INFORMATION_SCHEMA].[TABLES]
WHERE [TABLE_NAME] = 'NOTIFY_MEMBER_RENEWAL_CHRONICLE'
AND [TABLE_TYPE] = 'BASE TABLE'

which executes perfectly fine.

Does anyone have an idea what the tool is complaining about or how to resolve it? Thanks.

James B

Unfortunately, it looks like this is a known problem. We have it logged as a bug (ref. DT-283) but I don't know when it's likely to be fixed.

I'll add a note of this topic to the job for when it does get looked at though.