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

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

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

Postby georhill » Tue Apr 05, 2011 6:52 pm

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.
georhill
 
Posts: 13
Joined: Thu Jan 27, 2011 8:31 pm

Postby james.billings » Wed Apr 06, 2011 7:18 pm

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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests