Hi everybody,

I need to add records from sale1 table to sale2. The two tables are identical.

I use SQL server interprise manager to write query - graphical. I click SQL icon to check it parse ok.

When I run it I have time out error!

If I use the same query but use criteria to limit records for inserting a month of a time, The query works fine.

How I set or overcome timeout error. I search book on line but do not understand much.

Much appreciated

TOM