Eh, you misunderstood me. My example code using WAITFOR DELAY was only for getting time to test if an implicit transaction was takingg place or not. Several messages in this thread has pointed out that you should not be using SET ROWCOUNT at all. Calvin's example is the best yet.