Red Gate forums :: View topic - Phantom Unresolved Internal References
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Phantom Unresolved Internal References

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ckl



Joined: 04 Feb 2008
Posts: 2

PostPosted: Mon Feb 04, 2008 7:21 pm    Post subject: Phantom Unresolved Internal References Reply with quote

I am getting some Unresolved Internal References on a couple of views, but when I go to the database schema in Management Studio (SMS), the object referred to is not mentioned. In each case the unresolved internal reference is a likely looking name (i.e. not random) but I cannot see where the view references the object. If I use SMS to list objects on which the view depends the phantom object is not listed.

Has anyone else seen this problem?

I am using SQL Server 2005 SP2, and Dependency Tracker V2.40.75.0

Thanks.
Back to top
View user's profile Send private message
ckl



Joined: 04 Feb 2008
Posts: 2

PostPosted: Tue Feb 05, 2008 3:00 am    Post subject: Phantom Unresolved Internal References (more info) Reply with quote

Some more information:

If I select Show SQL Script on the shortcut menu for the view, the first lines are

-- View
CREATE VIEW [dbo].[MyView]

but the view is actually called rpt_MyView. If I check this in SMS, the view is correctly called rpt_MyView, and if I script it in SMS the script contains rpt_MyView. Only Dependency Tracker seems to think the script should call it MyView. If I look at he name of the object in the Objects in Project window, it is called rpt_MyView.

If I rename the view to MyView in SMS and rerun the whole thing, Dependency Tracker is happy. If I rename it back Dependency Tracker gets upset again.

What on earth is going on? Anyone?

TIA

Charles
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Thu Mar 27, 2008 1:20 pm    Post subject: Reply with quote

Hi Charles,

It looks as though you are suffering from this SQL Compare issue. Since Dependency Tracker uses version 5.3 of the SQL Compare Engine logic, the problem will not be worked around until Dependency Tracker is built using the new components, which should happen in a few weeks.

To identify whether or not this is the issue, you may run the following query in Management Studio:
Code:
select c.text from syscomments c inner join sysobjects o on o.id=c.id where o.name='rpt_MyView'

This should show whether there is a mismatch between the name of the view in the metadata and the actual definition that created the view (the latter being the one Dependency Tracker uses).

The only workaround at this time would be to drop and re-create the view with the proper name.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group