Objects not listed for sql database
Varun
Posts: 1
Hi All,
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?
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?
Tagged:
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com