Can you give me an example, I am not sure how to use it.

Thanks Chris


No... @@ROWCOUNT contains the number of records affected by the last command sent on that connection. You can also use @@ROWCOUNT to see if a record was updated too.

>Bob,
>
>So, what your saying is count the number of records prior to the insert, then count them after? Do you know anything about sqlcommit()? At first glance, this looks like it is what I need.
>
>Thanks, Chris