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

georhillgeorhill Posts: 20
edited April 6, 2011 2:18PM in SQL Dependency Tracker
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.

Comments

  • James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.