RE: Wrong number of rows

From: Sasan Saidi (SasanSaidi_at_discussions.microsoft.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 10:18:09 -0800

Try running DBCC UPDATEUSAGE and check the values again.

Sasan Saidi
Senior DBA
MSc. in CS, MCSE 4, IBM Certified Websphere MQ Administrator

"Vik" wrote:

> In a table properties window, a number of rows is 2 rows more than the
> actual number of rows in the table, returned by COUNT(*) and counted
> manually. How could this happen? Is the table corrupted?
>
> Thank you.
>
>
>
>
>

Relevant Pages

  • Re: Thinking out loud re: MCSE
    ... Microsoft thinks they will value MCTS and MCITP more than MCP and MCSE. ... As to equivilent, actually each of the new certs comes with a sub-title, MCTS - Vista Configuraion, MCITP - System Administrator, MCITP - Enterprise Administrator, etc etc. ...
    (microsoft.public.cert.exam.mcse)
  • Re: FrontPage 2002 Server Extensions
    ... I've been an MCSE for years and have extensive experience ... through the FrontPage administrator but thanks for stating ... if anonymous ftp ... >> What I need is a way to get the FP2002 server extensions ...
    (microsoft.public.inetserver.iis.security)
  • Save
    ... the file is not read only and I have full right to the file as administrator. ... I opened a file that was created in word 2003 and am trying to save it as 2003 format. ... Karel Grulich, MCSE ...
    (microsoft.public.word.docmanagement)
  • Re: Share Permission Problem
    ... Even if I connect as administrator I do not get access. ... > MCP, MCSE, MCT, N+ ... >> when) one of the drives has started to behave strangley. ...
    (microsoft.public.win2000.security)
Loading