Objects are not visible
romiltcs
Posts: 21
Hello,
I'm using Dependency tracker and after entering the SQL Server Instance, and selecting the needed database, i see a "Objects in Selected Database". In that window i am not able to see any such objects (tables, views, SPs, functions) etc.
I'm using Dependency tracker and after entering the SQL Server Instance, and selecting the needed database, i see a "Objects in Selected Database". In that window i am not able to see any such objects (tables, views, SPs, functions) etc.
Comments
The most obvious thing to check first is that the logon you use to connect to SQL Server has VIEW DEFINITION granted to it. This security right allows you to see the definition of schema objects in the database.
Hi Brain,
I just created a new test database through Windows Authentication in SQL Management Studio and then try viewing it through the dependency tracker but nothing was seen here.
To explain more a bit, you can the see image at http://tinypic.com/r/9jlxxw/5
Is the database in compatibility level 6.5?
Hello Brian,
I am using SQL Server 2008 so i guess the version has to be 6.5 or higher. Not sure though. Can you please guide me for the same so that i can check that and update you the same.
Thanks!
Thanks Brian.
I ran the query and the compatibility level is 100.
Thanks!
Hello,
I tried with login with SA Account. See below image. Username is SA
http://tinypic.com/r/ezyau/5
Thanks!
Awaiting your Reply....
Still awaiting some reply on this.
Sorry, everyone is stumped and since there is no error messge we have to make educated guesses as to what is wrong. Is the SQL Server the Express version? That's the only suspicion we have at the moment.
Yes Brian, this is SQL Express with advanced service (2008) version.
Any luck Brian?