August 21, 2001 at 5:37 am
I have 2 SQL 2000 SP1 installations and when I am in Ent. MGR, database, taskpad, table info all tables say they have zero rows when this is not the case, the size in K for the tables does appear to be correct. I have auto stats update option on the database and I used the db maint wizard to update statistics once a day with a 95% sample, I have changed this to 50 and to 100 with no effect. I have 2 SQL 2000 installations without SP1 and it reflects the correct number or rows in each table. ANY IDEAS????? thx in advance.
August 21, 2001 at 5:56 am
Try to run this query to see if you see the same results. This will show you what SQL Server thinks it has in the tables:
select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.xtype = 'u'
andi.indid < 2
order by o.name
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
August 21, 2001 at 6:05 am
I ran the query you supplied and it shows the correct # of rows. Interesting query.
August 21, 2001 at 3:49 pm
EM is probably using DMO to get its numbers. Maybe try profiliing EM to see what is getting sent to the server, if anything.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply