Red Gate forums :: View topic - External 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

External references

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



Joined: 08 May 2006
Posts: 7

PostPosted: Mon May 08, 2006 10:09 pm    Post subject: External references Reply with quote

In trying to evaluate the software, I am having a problem getting it to reconize external references that corss a linked server

For example when evaluating the following object, I get the message "SQL Server Does not exists" when trying to resolve the external reference to LinkServer.DB.DBO.Bar. However when the procedure is executed it works correctly.

Create Procedure foo
AS
Exec LinkServer.DB.DBO.Bar
Go
Back to top
View user's profile Send private message
Dan J Archer



Joined: 10 Oct 2005
Posts: 81
Location: Red Gate Software

PostPosted: Fri May 12, 2006 11:45 am    Post subject: Reply with quote

Thanks for the report.

We're looking into this - it looks like our parser doesn't fully support linked servers.

It tries to translate that four part name such that LinkServer is a literal SQL Server instance name.

I'll pass this on to the appropriate development team. We may be able to add this support for a future release, provided that the server on the other end of the link is a SQL Server 2000 or 2005 instance. Meantime, you should still be able to use a literal server name, assuming that server is a SQL Server 2000 or 2005 instance.

Thanks,

Dan
Back to top
View user's profile Send private message
fernandosalvio



Joined: 23 May 2006
Posts: 1
Location: Sao Paulo, SP Brazil

PostPosted: Tue May 23, 2006 8:44 pm    Post subject: Reply with quote

Hi! I have the same problem.

This problem can be partially resolved creating "Alias" on "Client Network Utility" on the computer where the DT is running.

The dependent objects will apears on the diagram but with the message: "External Reference" - "Database not in project".

I use the right mouse click on object, "Add to Project" - "Resolve External References" and the dependent objects is show.

But the Message Report still full of this messages:

Category
Parsed Dependency Resolution

Received
23/5/2006 15:00:53

Unable to resolve object '[Alias].[DatabaseName].[dbo].[object]' in unknown database '[Alias].[DatabaseName]' referenced by stored procedure '[MyServer].[Database].[dbo].[Procedure]'. Ensure the server exists and that you have included the database in your SQL Dependency Viewer project.

Thanks.

Fernando Salvio
Back to top
View user's profile Send private message
Dan J Archer



Joined: 10 Oct 2005
Posts: 81
Location: Red Gate Software

PostPosted: Wed May 24, 2006 11:35 am    Post subject: Reply with quote

Thanks Fernando,

That's a very good workaround. If this works, I'd recommend others with this issue follow your lead for the moment.

The warning you're seeing is a standard one; Dependency Tracker flags any unresolved reference, whether it ultimately can be resolved by right clicking and Resolving External References or not.

All the best,

Dan
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