Friday, March 9, 2012

Newbie Can't See tables of DB in Enterprise Manager

Hello,
I'm trying to view the tables of a db on a SQL7 server, but cannot. I used
to be able to... The view says "Tables 289 Items" but then also says "There
are no items to show in this view" where the tables are normally listed.
Any ideas why?
Thanks,
IvanHi,
From Query Analyzer , execute the below code to get the table details.
Use <dbname>
go
sp_tables
Thanks
Hari
MCDBA
"Ivan Starr" <ivan@.ivanstarr.com> wrote in message
news:e5I$D1OPEHA.2920@.tk2msftngp13.phx.gbl...
> Hello,
> I'm trying to view the tables of a db on a SQL7 server, but cannot. I
used
> to be able to... The view says "Tables 289 Items" but then also says
"There
> are no items to show in this view" where the tables are normally listed.
> Any ideas why?
> Thanks,
> Ivan
>

No comments:

Post a Comment