Thanks !!

Once I do backup the old data, deleting seems to take a lot of time and also fills up the trasaction log. Is there no other way but to...

Thanks:-)

The Index Rebuilding worked for me.

No , but I do see a high memory usage. I wonder if this is what is causing the problem

But will lock problems effect the connection timeouts

Cursor is OpenKeyset

Visual Basic, and connecting throught ADO

Looks like the trigger was not a good idea. Have got it working by calling the DTS package from another process after the update has been done and the transaction...

I need to get a dump of some of the columns into a flat file on a server that cannot access the database when a column is updated. Like BULK...