Ms 2767withh DBCC show_statistics

Hello
One of my database is quite slow. The first action i did is check
statistics, using dbccshow_statistics.
But it seems statistics are not available (SQL server returns a 2767 msg,
saying it cannot find statistics)
Thus i used update statistics on one of the table. Query analysers says the
comand is complete. But reusing dbcc update statistics shows the same error
message (2767)
The server version is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Is there any explanation ? Any ways to solve the problem ?
Thank you
Xavier
Can you show us:
result from
EXEC sp_helpindex 'tablename'
Your UPDATE STATISTICS command
Your DBCC SHOWSTATISTICS command
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> Hello
> One of my database is quite slow. The first action i did is check
> statistics, using dbccshow_statistics.
> But it seems statistics are not available (SQL server returns a 2767 msg,
> saying it cannot find statistics)
> Thus i used update statistics on one of the table. Query analysers says the
> comand is complete. But reusing dbcc update statistics shows the same error
> message (2767)
> The server version is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: )
> Is there any explanation ? Any ways to solve the problem ?
> Thank you
> Xavier
>
>
|||Thank you tibor for your quick answer.
I noticed yesterday, after sending my message, that the owner of the job
maintaining the databse was unkown in the security folder of EM. I switched
to 'sa' instead of this user (that was a Nt local account).
I let the job work last night, and now i have statistics on my table.
I suppose the owner of the job had insufficient rights in the first place,
but i cannot explain why using the sa account on a query analyser yesterday,
stats wouldn't be updated.
Here are the commande i used :
as you will see, the index on this table are, hm, usiong too much columns i
think (especially reagrding density of some columns). Any advice welcome by
the way :=) .
That is why i was using the dbcc show_statistics
exec sp_helpindex 'ValeursCAR'
IX_ValeursCARnonclustered, unique located on PRIMARYVal_Montant, Val_Zon2,
Val_Zon3, Val_Zon4, Val_RefCheque
IX_ValeursCAR_1nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_10nonclustered located on PRIMARYVal_Lot_Nulot, Val_Dt_Trt,
Val_FlagReconc
IX_ValeursCar_11nonclustered located on PRIMARYVal_Dt_Trt
IX_ValeursCAR_2nonclustered located on PRIMARYVal_FlagReconc,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_3nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_4nonclustered located on PRIMARYVal_FlagReconc, Val_Hotesse,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_5nonclustered located on PRIMARYVal_FlagReconc,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_6nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_7nonclustered located on PRIMARYVal_Dt_Reception,
Val_Dt_Vente, Val_Rmt_Numero, Val_Hotesse, Val_Zon8, Val_FlagReconc
IX_ValeursCAR_8nonclustered located on PRIMARYVal_Dt_Reception,
Val_FlagReconc
IX_ValeursCAR_9nonclustered located on PRIMARYVal_Lot_Nulot, Val_Dt_Trt
PK_ValeursCARclustered, unique, primary key located on PRIMARYVal_Identite
DBCC SHOW_statistics (ValeursCAR,IX_ValeursCAR_2)
Does return now correct values. so i cannot send the error message ...sorry
its number was 2767
"Tibor Karaszi" wrote:

> Can you show us:
> result from
> EXEC sp_helpindex 'tablename'
> Your UPDATE STATISTICS command
> Your DBCC SHOWSTATISTICS command
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
> news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
>