Hi Gail,

Thanks for your valuable reply, i will deleted all system statistices on table. by using this command

Drop statistics kw_1._WA_Sys_field2_6EF57B66

could tell me, why system automatically statistices created this...

Hi Gail thanks for reply..

Table name is KW_1, i got the result after running your below statement

SELECT object_name(id), name, INDEXPROPERTY(id, name, 'IsStatistics') FROM sysindexes

WHERE id = object_ID('KW_1')

KW_1PK_KW_10

KW_1_WA_Sys_field1_6EF57B661

KW_1_WA_Sys_field2_6EF57B661

KW_1_WA_Sys_field3_6EF57B661

KW_1_WA_Sys_field4_6EF57B661

KW_1_WA_Sys_field5_6EF57B661

KW_1_WA_Sys_field6_6EF57B661

KW_1_WA_Sys_field7_6EF57B661

KW_1_WA_Sys_field8_6EF57B661

KW_1_WA_Sys_field9_6EF57B661

KW_1_WA_Sys_field10_6EF57B661

KW_1_WA_Sys_field11_6EF57B661

KW_1_WA_Sys_field12_6EF57B661

KW_1_WA_Sys_field13_6EF57B661

KW_1_WA_Sys_field14_6EF57B661

KW_1_WA_Sys_field15_6EF57B661

KW_1_WA_Sys_field16_6EF57B661

KW_1_WA_Sys_field17_6EF57B661

KW_1_WA_Sys_field18_6EF57B661

KW_1_WA_Sys_field19_6EF57B661

KW_1_WA_Sys_field20_6EF57B661

KW_1_WA_Sys_field21_6EF57B661

KW_1_WA_Sys_field22_6EF57B661

KW_1_WA_Sys_field23_6EF57B661

KW_1_WA_Sys_field24_6EF57B661

KW_1_WA_Sys_field25_6EF57B661

KW_1_WA_Sys_field26_6EF57B661

KW_1_WA_Sys_field27_6EF57B661

KW_1_WA_Sys_field28_6EF57B661

KW_1_WA_Sys_field29_6EF57B661

KW_1_WA_Sys_field30_6EF57B661

KW_1_WA_Sys_field31_6EF57B661

KW_1_WA_Sys_field32_6EF57B661

KW_1_WA_Sys_field33_6EF57B661

KW_1_WA_Sys_field34_6EF57B661

KW_1_WA_Sys_field35_6EF57B661

KW_1_WA_Sys_field36_6EF57B661

KW_1_WA_Sys_field37_6EF57B661

KW_1_WA_Sys_field38_6EF57B661

KW_1_WA_Sys_field39_6EF57B661

KW_1_WA_Sys_field40_6EF57B661

KW_1_WA_Sys_field41_6EF57B661

KW_1_WA_Sys_field42_6EF57B661

KW_1_WA_Sys_field43_6EF57B661

KW_1_WA_Sys_field44_6EF57B661

KW_1_WA_Sys_field45_6EF57B661

KW_1_WA_Sys_field46_6EF57B661

KW_1_WA_Sys_field47_6EF57B661

KW_1_WA_Sys_field48_6EF57B661

KW_1_WA_Sys_field49_6EF57B661

KW_1_WA_Sys_field50_6EF57B661

KW_1_WA_Sys_field51_6EF57B661

KW_1_WA_Sys_field52_6EF57B661

KW_1_WA_Sys_field53_6EF57B661

KW_1_WA_Sys_field54_6EF57B661

KW_1_WA_Sys_field55_6EF57B661

KW_1_WA_Sys_field56_6EF57B661

KW_1_WA_Sys_field57_6EF57B661

KW_1_WA_Sys_field58_6EF57B661

KW_1_WA_Sys_field59_6EF57B661

KW_1_WA_Sys_field60_6EF57B661

KW_1_WA_Sys_field61_6EF57B661

KW_1_WA_Sys_field62_6EF57B661

KW_1_WA_Sys_field63_6EF57B661

KW_1_WA_Sys_field64_6EF57B661

KW_1_WA_Sys_field65_6EF57B661

KW_1_WA_Sys_field66_6EF57B661

KW_1_WA_Sys_field67_6EF57B661

KW_1_WA_Sys_field68_6EF57B661

KW_1_WA_Sys_field69_6EF57B661

KW_1_WA_Sys_field70_6EF57B661

KW_1_WA_Sys_field71_6EF57B661

KW_1_WA_Sys_field72_6EF57B661

KW_1_WA_Sys_field73_6EF57B661

KW_1_WA_Sys_field74_6EF57B661

KW_1_WA_Sys_field75_6EF57B661

KW_1_WA_Sys_field76_6EF57B661

KW_1_WA_Sys_field77_6EF57B661

KW_1_WA_Sys_field78_6EF57B661

KW_1_WA_Sys_field79_6EF57B661

KW_1_WA_Sys_field80_6EF57B661

KW_1_WA_Sys_field81_6EF57B661

KW_1_WA_Sys_field82_6EF57B661

KW_1_WA_Sys_field83_6EF57B661

KW_1_WA_Sys_field84_6EF57B661

KW_1_WA_Sys_field85_6EF57B661

KW_1_WA_Sys_field86_6EF57B661

KW_1_WA_Sys_field87_6EF57B661

KW_1_WA_Sys_field88_6EF57B661

KW_1_WA_Sys_field89_6EF57B661

KW_1_WA_Sys_field90_6EF57B661

KW_1_WA_Sys_field91_6EF57B661

KW_1_WA_Sys_field92_6EF57B661

KW_1_WA_Sys_field93_6EF57B661

KW_1_WA_Sys_field94_6EF57B661

KW_1_WA_Sys_field95_6EF57B661

KW_1_WA_Sys_field96_6EF57B661

KW_1_WA_Sys_field97_6EF57B661

KW_1_WA_Sys_field98_6EF57B661

KW_1_WA_Sys_field99_6EF57B661

KW_1_WA_Sys_field100_6EF57B661

KW_1_WA_Sys_field101_6EF57B661

KW_1_WA_Sys_field102_6EF57B661

KW_1_WA_Sys_field103_6EF57B661

KW_1_WA_Sys_field104_6EF57B661

KW_1_WA_Sys_field105_6EF57B661

KW_1_WA_Sys_field106_6EF57B661

KW_1_WA_Sys_field107_6EF57B661

KW_1_WA_Sys_field108_6EF57B661

KW_1_WA_Sys_field109_6EF57B661

KW_1_WA_Sys_field110_6EF57B661

KW_1_WA_Sys_field111_6EF57B661

KW_1_WA_Sys_field112_6EF57B661

KW_1_WA_Sys_field113_6EF57B661

KW_1_WA_Sys_field114_6EF57B661

KW_1_WA_Sys_field115_6EF57B661

KW_1_WA_Sys_field116_6EF57B661

KW_1_WA_Sys_field117_6EF57B661

KW_1_WA_Sys_field118_6EF57B661

KW_1_WA_Sys_field119_6EF57B661

KW_1_WA_Sys_field120_6EF57B661

KW_1_WA_Sys_field121_6EF57B661

KW_1_WA_Sys_field122_6EF57B661

KW_1_WA_Sys_field123_6EF57B661

KW_1_WA_Sys_field124_6EF57B661

KW_1_WA_Sys_field125_6EF57B661

KW_1_WA_Sys_field126_6EF57B661

KW_1_WA_Sys_field127_6EF57B661

KW_1_WA_Sys_field128_6EF57B661

KW_1_WA_Sys_field129_6EF57B661

KW_1_WA_Sys_field130_6EF57B661

KW_1_WA_Sys_field131_6EF57B661

KW_1_WA_Sys_field132_6EF57B661

KW_1_WA_Sys_field133_6EF57B661

KW_1_WA_Sys_field134_6EF57B661

KW_1_WA_Sys_field135_6EF57B661

KW_1_WA_Sys_field136_6EF57B661

KW_1_WA_Sys_field137_6EF57B661

KW_1_WA_Sys_field138_6EF57B661

KW_1_WA_Sys_field139_6EF57B661

KW_1_WA_Sys_field140_6EF57B661

KW_1_WA_Sys_field141_6EF57B661

KW_1_WA_Sys_field142_6EF57B661

KW_1_WA_Sys_field143_6EF57B661

KW_1_WA_Sys_field144_6EF57B661

KW_1_WA_Sys_field145_6EF57B661

KW_1_WA_Sys_field146_6EF57B661

KW_1_WA_Sys_field147_6EF57B661

KW_1_WA_Sys_field148_6EF57B661

KW_1_WA_Sys_field149_6EF57B661

KW_1_WA_Sys_field150_6EF57B661

KW_1_WA_Sys_field151_6EF57B661

KW_1_WA_Sys_field152_6EF57B661

KW_1_WA_Sys_field153_6EF57B661

KW_1_WA_Sys_field154_6EF57B661

KW_1_WA_Sys_field155_6EF57B661

KW_1_WA_Sys_field156_6EF57B661

KW_1_WA_Sys_field157_6EF57B661

KW_1_WA_Sys_field158_6EF57B661

KW_1_WA_Sys_field159_6EF57B661

KW_1_WA_Sys_field160_6EF57B661

KW_1_WA_Sys_field161_6EF57B661

KW_1_WA_Sys_field162_6EF57B661

KW_1_WA_Sys_field163_6EF57B661

KW_1_WA_Sys_field164_6EF57B661

KW_1_WA_Sys_field165_6EF57B661

KW_1_WA_Sys_field166_6EF57B661

KW_1_WA_Sys_field167_6EF57B661

KW_1_WA_Sys_field168_6EF57B661

KW_1_WA_Sys_field169_6EF57B661

KW_1_WA_Sys_field170_6EF57B661

KW_1_WA_Sys_field171_6EF57B661

KW_1_WA_Sys_field172_6EF57B661

KW_1_WA_Sys_field173_6EF57B661

KW_1_WA_Sys_field174_6EF57B661

KW_1_WA_Sys_field175_6EF57B661

KW_1_WA_Sys_field176_6EF57B661

KW_1_WA_Sys_field177_6EF57B661

KW_1_WA_Sys_field178_6EF57B661

KW_1_WA_Sys_field179_6EF57B661

KW_1_WA_Sys_field180_6EF57B661

KW_1_WA_Sys_field181_6EF57B661

KW_1_WA_Sys_field182_6EF57B661

KW_1_WA_Sys_field183_6EF57B661

KW_1_WA_Sys_field184_6EF57B661

KW_1_WA_Sys_field185_6EF57B661

KW_1_WA_Sys_field186_6EF57B661

KW_1_WA_Sys_field187_6EF57B661

KW_1_WA_Sys_field188_6EF57B661

KW_1_WA_Sys_field189_6EF57B661

KW_1_WA_Sys_field190_6EF57B661

KW_1_WA_Sys_field191_6EF57B661

KW_1_WA_Sys_field192_6EF57B661

KW_1_WA_Sys_field193_6EF57B661

KW_1_WA_Sys_field194_6EF57B661

KW_1_WA_Sys_field195_6EF57B661

KW_1_WA_Sys_field196_6EF57B661

KW_1_WA_Sys_field197_6EF57B661

KW_1_WA_Sys_field198_6EF57B661

KW_1_WA_Sys_field199_6EF57B661

KW_1_WA_Sys_field200_6EF57B661

KW_1_WA_Sys_field201_6EF57B661

KW_1_WA_Sys_field202_6EF57B661

KW_1_WA_Sys_field203_6EF57B661

KW_1_WA_Sys_field204_6EF57B661

KW_1_WA_Sys_field205_6EF57B661

KW_1_WA_Sys_field206_6EF57B661

KW_1_WA_Sys_field207_6EF57B661

KW_1_WA_Sys_field208_6EF57B661

KW_1_WA_Sys_field209_6EF57B661

KW_1_WA_Sys_field210_6EF57B661

KW_1_WA_Sys_field211_6EF57B661

KW_1_WA_Sys_field212_6EF57B661

KW_1_WA_Sys_field213_6EF57B661

KW_1_WA_Sys_field214_6EF57B661

KW_1_WA_Sys_field215_6EF57B661

KW_1_WA_Sys_field216_6EF57B661

KW_1_WA_Sys_field217_6EF57B661

KW_1_WA_Sys_field218_6EF57B661

KW_1_WA_Sys_field219_6EF57B661

KW_1_WA_Sys_field220_6EF57B661

KW_1_WA_Sys_field221_6EF57B661

KW_1_WA_Sys_field222_6EF57B661

KW_1_WA_Sys_field223_6EF57B661

KW_1_WA_Sys_field224_6EF57B661

KW_1_WA_Sys_field225_6EF57B661

KW_1_WA_Sys_field226_6EF57B661

KW_1_WA_Sys_field227_6EF57B661

KW_1_WA_Sys_field228_6EF57B661

KW_1_WA_Sys_field229_6EF57B661

KW_1_WA_Sys_field230_6EF57B661

KW_1_WA_Sys_field231_6EF57B661

KW_1_WA_Sys_field232_6EF57B661

KW_1_WA_Sys_field233_6EF57B661

KW_1_WA_Sys_field234_6EF57B661

KW_1_WA_Sys_field235_6EF57B661

KW_1_WA_Sys_field236_6EF57B661

KW_1_WA_Sys_field237_6EF57B661

KW_1_WA_Sys_field238_6EF57B661

KW_1_WA_Sys_field239_6EF57B661

KW_1_WA_Sys_field240_6EF57B661

KW_1_WA_Sys_field241_6EF57B661

KW_1_WA_Sys_field242_6EF57B661

KW_1_WA_Sys_field243_6EF57B661

KW_1_WA_Sys_field244_6EF57B661

KW_1_WA_Sys_field245_6EF57B661

KW_1_WA_Sys_field246_6EF57B661

KW_1_WA_Sys_field247_6EF57B661

KW_1_WA_Sys_field248_6EF57B661

KW_1_WA_Sys_field249_6EF57B661

further what i...

Thanks for all yours reply..

Actually what is the problem that replication? we are not create index on the databasel

One of the client people installed s/w in production envorinment. designed database,...

this error while running snapshots agents,

All user table , user has created one rowguid (uniqueidentifier) for all tables. is there problem for while running snapshots agents.

Thanks for your reply

In Artical properties, i unclick non clustred index, again i have faced the following error

Cannot create more than 249 nonclustered indices or column statistics on one table.(Source:...

Thanks for your reply....

i am getting clear but my production database TLog Every 30 Min, I recvoery data up last transaction backup at 3:00 PM. if server or database...

hi manu,

thanks for your valuable reply..

Hi Gail,

Thanks for your reply..

error log we can found that what exact problem for database suspet mode.

yes..Is this a theoretical question?

could you tell me, any other...

hi david, thanks for reply...

Disk configuration is RAID 1+0 - (total 4 HD)

this server not in SAN storage area.

disk type is - SCSI Ultra 320

all user database file in separate...

hi manu thanks for reply....

RAM - 4GB

OS- windows server 2003 enterprise edtion

CPU - Intel Pentium 4 CPU

thanks for your reply..

As per your Question,

1. Are you sure that there is no activity on the server? How did you determine that no one modified...

Hi thanks for reply.

server has using 3 GB RAM

processor - Intel xeon(R) CPU 5152 @ 2.66GHs.

OS - Windows server 2003 Enterprise Edtion (sp2)

DB- Sql server 2000 (sp3)

so, How can i...

i run sp_confiure, for the following result.

If there any changes required.

affinity mask-2147483648214748364700

allow updates0100

awe enabled0100

c2 audit mode0100

cost threshold for parallelism03276755

Cross DB Ownership Chaining0100

cursor threshold-12147483647-1-1

default full-text language0214748364710331033

default language0999900

fill factor (%)010000

index create memory...

hi,

Thanks for reply.

The most recent query?

The most recent data change?

Something else?

I want the most recent query?

Very usefull for me,If you give me all three query.

thanks

Hi,

Urgent Help.

I need the query for by the last transaction and access database with date.

thanks