Comments
1 comment
-
Hi, thank you for your forum post.
SQL Dependency Tracker uses the SQL Compare engine code so requires the same permissions as SQL Compare. The list of permissions is available in the link below:
https://documentation.red-gate.com/display/SC11/Permissions+required+to+use+SQL+Compare
You may also require the GRANT VIEW SERVER STATE TO <user> permission.
Many Thanks
Eddie
Add comment
Please sign in to leave a comment.
I'm trying to generate dependency diagram for one my databases, but 'Add objects to project' window doesn't list the objects (tables and views), i even tried generating diagram from sql server management studio - dependency tracker windows opens with 'You have no objects in your project'. FYI my ID has permissions to view all tables and views in database, i can browse them using sql server management studio.
When i try generate diagram on 'master' database it works perfectly but not on a different database on same server. Am I missing some permissions or doing something wrong?