sorry for the delay - but the checkdb lasts a while, there are almost 250.000 tables in the db.

checkdb and again checktable - both without errors

but no difference today!!!...

no problem on sunday,

trying it to start again today after our business hour (in one hour)

the 6 records are old records (last year), we mentioned the error, because there where reports with different results.

to find the problem I created a simple select with and without...

no - there is absolute no indication for an error

every week on sunday

I executed the checktable befor rebuilding the index - there was no error log;

the question is, what can cause this difference of rows in the index

I checked it - there are no Nulls

the problem is, that the application (Navision) comes to different results, depending on what report was started. (with the profiler I saw the...

select COUNT(*) from [dbo].[AT101 Swietelsky Bau GmbH$Sachposten]with(index(0))

where

[Sachkontonr_]= '250020' and

Buchungsdatum <= '2011-09-30'

select COUNT(*) from [dbo].[AT101 Swietelsky Bau GmbH$Sachposten]with(index(7))

where

[Sachkontonr_]= '250020' and

Buchungsdatum <= '2011-09-30'

First selcect delivers: 1325748

second: 1325742

Hi,

Thank´s a lot - the script work´s well on SQL 2005. But it does not list users which have no user mapping.

The reason for the solution I need...

Hi,

that´s not my problem. I have a login, an the login has no databases mapped. So it´s not an orphaned, and the "sp_change_users_login 'Report' " reports nothing.

Hi, Thank´s a lot. I just wrote the following script, and it work´s fine

Use [Test]

declare

@username varchar(64)

declare c1 cursor for select name from sysusers

where uid > 1

...