Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandlu
Starting Member
17 Posts |
 Posted - 2007-09-04 : 14:55:01
|
| HI,We have one table have problem when run "select count(*) from table". This is a sql 2000 server. it returned different count everytime when I ran the "select count(*) from table". I used DBCC to check the table and did not find any problems. I can fix it by recreate the table and reimport the data, but the problem come back after we update some data in the table monthly with a stored procedure. Any suggestion?ThanksSand |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 15:12:19
|
| by any chance is the table row count changing?or perhaps sp4 patching is in order? Is it still sp4 for 2000? check MS site if a new one is out.--------------------keeping it simple... |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-04 : 20:38:50
|
quote:
Originally posted by jen
by any chance is the table row count changing?or perhaps sp4 patching is in order? Is it still sp4 for 2000? check MS site if a new one is out.--------------------keeping it simple...
SP4 is still the latest, but this issue sounds like the count is actually changing, perhaps do a rowcount to confirm?
Future guru in the making. |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-09-11 : 20:00:29
|
| The table row count not change, but select count(*) change |
|
|
|
|
|
|
problem on select count(*)