Hello everybody,

I'm using sql server 2000 and i want

when insert a row into table1 automatically create the same row into the same table (with some values changed by me).

when delete a row into table1 automatically delete the other row-s into the same table

when update a row then update the other rows ...

i dont know how to implement such a thing and i don't know if it is possible without deadlocks etc.

Any comments will be great......

Thanks in advance

Nick

use triggers, look it up in Books On Line


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/