I am using single trasanction to insert some 1000's of rows in a single transaction and it is need as requirement. Since the data to be inserted in the tables is varies logsegement size cann't be fixed. This porgram right now running in production, but it is filling up the logsegement when more number of rows are inserted.
My requirement is I need this insertion should be in a single trancation and logsegement should not be filled up. Can some one please tell me how to do this.
Thanks and Regards,
Last edited by Sabbi; 06-02-04 at 13:45.
Reason: spelling mistake
Based on your requirement, keep on extending the log until you come to a stage where it is no more extension is required. Other option is to do batch inserts in which case you can control the log filling up.