MSSQL4 - Extneral Access

I am trying to access a database on MSSQL4 with SQL Server Manager 2008. I can successfully connect, but I can't see any of my databases.

I have a ticket open (ZHC-49114-232) which I tried to respond to 2x and my response is not showing up in the support ticket. I know that it can take some time for responses to show up, but it's been almost 2 hours.

The last response I got was that I'd have to use a SQL window and run queries to make changes to the database, but this is unacceptable. I need to be able to modify the table structure from within the SQL Server Manager.
 
I did request that in the ticket and they told me that SQL View is disabled.

I tried to reply saying that that was unacceptable, but my reply isn't showing up, which is why I came here.

This was their response:
If you are able to connect database by using sql management studio/sql lite manager and not able to see db that is not a issue, we have disable db view permission.
they can easily manage database and execute sql query by using below syntax

user db (database name)
go
your sql query
go
 
In the past I always just submitted a ticket for a SQL View login and it was done in a matter of minutes. This has taken all day to be resolved.
 
Back
Top