Thanks for the tip. I'll remember that.

BTW, do you use the SQL debugger in VB to step through MS SQL Server stored procedures?

Paul



>You may already know about this, but one thing to careful about with @@ROWCOUNT in SQL Server is that it may be reset after each T-SQL statement, like @@ERROR is. Just to be careful, after I execute a SELECT, INSERT, whatever, I:
>
>SELECT @ErrorNo = @@ERROR, @RowCnt = @@ROWCOUNT
>
>Then at the end of the sproc, I use @RowCnt rather than @@ROWCOUNT
>