I had to investigate a similar problem and discovered the cause was a junior DBA running the following piece of code at 11PM and then going home.

BEGIN TRAN;

UPDATE MyTable SET MyValue = @MyValue;

-- COMMIT;

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]