R. Barry,

Thanks for your response.

Nice blog.

Tony

Pradeep,

I appreciate your time very much. You have helped me a lot.

I don't get that result any more. I must have had something wrong. Now I get:

(1 row(s) affected)

(1...

Pradeep,

That worked! Thank you very much.

It only changed the one row but the messages look like it did much more. Is this ok?

(16134 row(s) affected)

(16134 row(s) affected)

(1 row(s)...

Thanks for the response.

I tried this:

ALTER TRIGGER test_delete ON test FOR UPDATE AS

IF UPDATE (deleteflag) BEGIN

UPDATE test SET deletedate = GETDATE()

FROM test,deleted,inserted

WHERE deleted.deleteflag <> inserted.deleteflag

END

It updated every...