471,073 Members | 1,313 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

No of rows conflict in a table

Hi,

The 'properties' option of a table through the 'Enterprise Manager'
shows different no of records against the row selection through sql
query analyzer.

Any answers why so?

Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #1
1 1424

"John Jayaseelan" <jo*************@caravan-club.co.uk> wrote in message
news:40*********************@news.frii.net...
Hi,

The 'properties' option of a table through the 'Enterprise Manager'
shows different no of records against the row selection through sql
query analyzer.

Any answers why so?

Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Do you mean that SELECT COUNT(*) FROM dbo.MyTable doesn't give the same
results as the Properties dialogue? This is not unexpected, because the
Properties dialogue uses the rows column in sysindexes to get the rowcount,
but this can be inaccurate - see DBCC UPDATEUSAGE in Books Online for more
information.

You can try running this command, then check the Properties again:

exec sp_spaceused 'MyTable', 'true'

But the only reliable way to get an accurate rowcount is to use SELECT
COUNT(*).

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jason | last post: by
1 post views Thread by John Jayaseelan | last post: by
12 posts views Thread by Rick DeBay | last post: by
4 posts views Thread by crystal | last post: by
1 post views Thread by lorirobn | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.