One member, spanish forum, has the following problem. He insert one table with many rows. That table has identity column. Each day he delete all rows and insert again using DTS. SQL begin inserting with the last id after delete. He need to begin with id = 1 each time. Is there any way, beside SET IDENTITY_INSERT table ON each time using DTS? Luis Martin Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.