|
|
Posted by ssingh on 09/30/60 11:53
Thank you Erland. It worked for me.
Erland Sommarskog wrote:
> 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
Navigation:
[Reply to this message]
|