| Author |
Message |
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
 Posted: Tue Nov 22, 2011 2:54 pm Post subject: Objects are not visible |
 |
|
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. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Wed Nov 23, 2011 6:51 pm Post subject: |
|
|
Hello,
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Fri Nov 25, 2011 8:18 am Post subject: Re: |
|
|
| Brian Donahue wrote: |
Hello,
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 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Fri Nov 25, 2011 9:59 am Post subject: |
|
|
Hello,
Is the database in compatibility level 6.5?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Mon Nov 28, 2011 9:37 am Post subject: Re: |
|
|
| Brian Donahue wrote: |
Hello,
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! |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Wed Nov 30, 2011 10:32 am Post subject: |
|
|
You can run the following query:
| Code: |
| exec sp_dbcmptlevel 'dbname' |
where dbname is the name of the database.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Mon Dec 05, 2011 3:07 pm Post subject: Re: |
|
|
| Brian Donahue wrote: |
You can run the following query:
| Code: |
| exec sp_dbcmptlevel 'dbname' |
where dbname is the name of the database. |
Thanks Brian.
I ran the query and the compatibility level is 100.
Thanks! |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Mon Dec 05, 2011 3:20 pm Post subject: |
|
|
Just to completely rule out permissions, have you tried connecting using the SA account?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Tue Dec 06, 2011 10:04 am Post subject: Re: |
|
|
| Brian Donahue wrote: |
| Just to completely rule out permissions, have you tried connecting using the SA account? |
Hello,
I tried with login with SA Account. See below image. Username is SA
http://tinypic.com/r/ezyau/5
Thanks! |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Thu Dec 08, 2011 10:37 am Post subject: Re: |
|
|
| romiltcs wrote: |
| Brian Donahue wrote: |
| Just to completely rule out permissions, have you tried connecting using the SA account? |
Hello,
I tried with login with SA Account. See below image. Username is SA
http://tinypic.com/r/ezyau/5
Thanks! |
Awaiting your Reply.... |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Thu Dec 15, 2011 1:52 pm Post subject: |
|
|
Hi
Still awaiting some reply on this. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Thu Dec 15, 2011 4:47 pm Post subject: |
|
|
Hi,
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Thu Dec 22, 2011 2:03 pm Post subject: Re: |
|
|
| Brian Donahue wrote: |
Hi,
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. |
|
| Back to top |
|
|
romiltcs
Joined: 17 Nov 2011
Posts: 16
|
| Posted: Wed Dec 28, 2011 9:42 am Post subject: Re: |
|
|
| romiltcs wrote: |
| Brian Donahue wrote: |
Hi,
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? |
|
| Back to top |
|
|
|
