Hi. I believe that there is a setting in the SQL Server engine itself to achieve that. Look around for PERSISTENT ... CURSORS or something similar. Might not be very documented though. JLuc