Database table is not visible. How to make it visible?
Posted on 2009-06-30
I created a database with MS SQL Management Sudio and added a database to it. For now logging in is through the Windows NT authentication. My problem is that I am working on an application and plan and ODBC access to the database and table. I'm able to log on to the database. However the app cannot find the table. I compiled a Microsoft app that lists all tables under that database. Surprisingly, it lists all System Tables, all dbo schemas, and others not even shown in Management Studio. Yet my table is nowhere to be seen, though it is also listed in Management Studio as a dbo schema.
How do I make that visible? It seems to be some restriction in terms of security or similar but I don't know where to look, as I've tried comparing the other accesses (Master, etc) that are there.