Posted by Erland Sommarskog on 07/19/06 21:40

ssingh (singh.181@gmail.com) writes:
> I want to select the names and number of rows of all tables in the
> current database, whose name starts with 'sys'
> my query is:
>...
> But when I count the number of rows of "sysobjects", I get
> numbers=1298, which is different from the result displayed above and
> same goes for "syscolumns".
> I also tried "dbcc updateusage [0]" to update the SQL Server but I
> didnt help me.
> Can anyone please advice me on this behaviour?

Add WITH COUNT_ROWS to DBCC UPDATEUSAGE.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: query to populate child table
• Prev in forum: Re: Second Transaction Log File
• Thread view: Re: select no. of rows from the current database

[Reply to this message]