External references

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

External references

Postby chattabaugh » Mon May 08, 2006 10:09 pm

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
chattabaugh
 
Posts: 7
Joined: Mon May 08, 2006 10:02 pm

Postby Dan J Archer » Fri May 12, 2006 11:45 am

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
Dan J Archer
 
Posts: 81
Joined: Mon Oct 10, 2005 11:15 am
Location: Red Gate Software

Postby fernandosalvio » Tue May 23, 2006 8:44 pm

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
fernandosalvio
 
Posts: 1
Joined: Tue May 23, 2006 6:44 pm
Location: Sao Paulo, SP Brazil

Postby Dan J Archer » Wed May 24, 2006 11:35 am

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
Dan J Archer
 
Posts: 81
Joined: Mon Oct 10, 2005 11:15 am
Location: Red Gate Software


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests