AllendeL4S
Perch
Hi Friends
I have a SQL database in HSPHERE. It works fine since I can connect from my web application with no issue.
I'm trying to connect remotely using SQL Server Management Studio and it connects to the server perfectly but it wont list my database.
It is weird since if I browse the databases at the moment of establishing the connection it lists it. Also, if I run a "select * from sysobjects" it will show all my tables and SP there...
The connection in the Object Explorer shows a white empty circle instead the regular green triangle.
Am I missing something here?
BTW How can I download the database to my PC?? I would like to do a backup but I wont be able till I can see the DB listed.
Thanks a lot
I have a SQL database in HSPHERE. It works fine since I can connect from my web application with no issue.
I'm trying to connect remotely using SQL Server Management Studio and it connects to the server perfectly but it wont list my database.
It is weird since if I browse the databases at the moment of establishing the connection it lists it. Also, if I run a "select * from sysobjects" it will show all my tables and SP there...
The connection in the Object Explorer shows a white empty circle instead the regular green triangle.
Am I missing something here?
BTW How can I download the database to my PC?? I would like to do a backup but I wont be able till I can see the DB listed.
Thanks a lot