Dear all,

I wrote a VB program to import data from ASCII to SQL SERVER,
Firstly, to a temporary table [say table A] before it goes into its final
destination [say table B]. The goal is to have application that will be running
in the background and refreshes every 30 minutes.

Importing is not incremental, does I need to delete what I have in my table
before appending into it.

But as the record in the table increases, If I issued a command like "delete
from tableB where branchcode = '00004'", it will just wait for some time
and evnetually timed out.

But using the same command at SQL Server query analyser will run smoothly
So I thought may be there is a property I need to set that has not been set

Thanks,

Mayowa