Unable to resolve object '[INFORMATION_SCHEMA].[TABLES]'
georhill
Posts: 20
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.
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.
Comments
I'll add a note of this topic to the job for when it does get looked at though.
Redgate Software