Problem on "Select count(*)"

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?

Thanks

Sand

Try fully qualifying the table name (database.schema.table) and using a new connection from the same PC each time you exeucte the select count(*)

You want to make sure you are selecting from the same database on the same server from the same table everytime. And a new connection to make sure you don't have rowcount or some other option interfering.

-Sue

problem intstalling SQLEXPR.EXE

everytime i try installing SQLEXPR.EXE.. it will give mi a problem saying SQL server 2005 setup has detect incompatible components from beta verisons of VS, .net framework, or SQL server 2005.

i did uninstall all beta version.. n try again.. but still e same problem..

how can it be solve and whats e probem?

Take a look at the setup logs to get a more specific idea which component is causing the problem. There a number of components that got installed when you installed the Beta, you need to get rid of all of them.

Setup logs are located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOGS.

There are several threads on solving this error in the SQL Setup forum, so you should search that forum for the details.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1