I have some issues viewing objects in a sql server 2008 database
I can connect to the database instance in open profiler (which uses windows authentication) using the Microsoft MSSQL Server JDBC Driver, however I can only see a few schemas, those schemas owned by dbo, guest, sys. However in this particular database the tables I want to perform data profilling on are in schemas not owned by dbo, and I can't see any of these in the DQ Repository window.
When connecting to a sql server 2005 database, using the same driver and windows authentication I can see all the schemas and objects within them but in this DB all schemas are owned by dbo.
In toad/SQL server management studio which connect using windows authentication too - I can see all the schemas/tables including those not owned by dbo. Is there any way around this, is it the JDBC drivers or open profiler, do i need to connect a different way, or do I need to get the DBA to change the access/permissions for my username?
Also while on the subject is there any way round the fact that I can't actually run SQL statements within open profiler, I am guessing its because of using windows authentication to connect to the DB?
Thanks for any help.