I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>>I have been asked to work on a remote site. I started my EM and tried to
>>connect to the SQL server on the remote site. I connected just fine
>>(server had userid/password). But when I open the "Databases" folder I
>>get a "(no items)" instead of a list of databases. BUT, when I view other
>>folders I see various items. For example, Security/Login lists lots of
>>login entries. Just to see what would happen I right-clicked on Databases
>>and clicked All Tasks/Backup Database and got a list of databases that I
>>was NOT allowed to backup! But, still no list of databases.
>> Any ideas?
>>
>> BTW, I am using SQL Server 2000 EM.
>> TIA,
>> Larry Woods
>sql