Bit rott (Or something)

[Blorf]

Hi.

Using SQL 2000 on Win 2003 server, we migrated from SQL 7 on windows 2000.

Everything worked, but now on a transaction table containing about 300K records (Purged some recently) there is a date / time field that is behaving oddly.

The records have an autonumber ID field, and a Date field. The date field is changing on old records. Example, records that were dated 2003 suddenly have todays date.

About 30 records do this per day.

I have verified that the records are really changing, but there is no reason for this, and I am worried there is something much worse than I see going on.

Any tips would be appreciated.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[mrdenny]

Run a trace on the server for anything that is updating records in that table. That will tell you who's changing what. You can then find them (or the process) and see what's up.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Blorf]

Hi. New to SQL admin. I read about tracing, but can not figure out how to trace specific to a table.

If it's simple enough, more info would be appreciated.

Either way, thank you very much for the help.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[mrdenny]

Open SQL Profiler. Create a new trace. On the filter tab (I think that's what it's called) find the text setting and put the table name in that field. This will filter the trace so that only queries that involve the table will be shown.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[dbomrrsm]

Under filters put the name of the table in ObjectName

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]