Activity overview
Latest activity by baggister
Hi Eddie,
Thanks for your reply. version is ----> 2.8.1.182
Re ..
"The Windows account that is running SQL Dependency Tracker does it security permissions to the external databases to detect the external reference?"
Not sure what you mean here - I run it as myself, and I have enough authority to create and delete tables, SPs etc.
But I suppose I'm a bit unclear exactly what is it supposed to do.
eg, my target database is TargetDB, and there's a stored procedure called TargetSP
I have another database on the same server called TestDB and there's a storedprocedure called TestSP, which executes TargetDB..TargetSP
There are no other relationships between the two.
I add objects to Project, select my server, select TargetDB from the selection of Databases, select only Tables, SPs, Views, Functions (not interested in anything else).
In options, I see that "Add objects that the selected objects are used by" is already ticked. Fine.
I also decide to tick "Add objects that the selected objects use ".
Then finally I also tick "Add External and unresolved references".
1. under the above situation, would you expect TestSP to be on the diagram?
2. If "add External and unresolved references" was Unticked, would you expect TestSP to be on the diagram?
I also note that there is an option on database level called "Cross-Database Ownership chaining Enabled".
I noticed that when "Cross-Database Ownership chaining Enabled" is not enabled, some objects do not appear on the diagram.
3. What is the significance of this option re Redgate Dependency Tracker?
Thanks / comments
Hi Eddie,
Thanks for your reply. version is ----> 2.8.1.182
Re ..
"The Windows account that is running SQL Dependency Tracker does it security permissions to the external databases to d...
2008r2 - external references, some databases ignored
sql server 2008r2
I noticed that some databases (external references) were completely ignored. (all settings ticked, all levels, objects uses, objects used by, resolve all external, etc).
After com...
External References - some Databases not picked up
Server - 2008R2
Selecting all tables, Stored Procedures, functions, views in a particular database, and in options, ticking everything (ie add objects selected used by, all levels, add objects sele...