External references
chattabaugh
Posts: 12
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
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
Comments
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
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
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