at t=0

Table contains 50,000 rows

File contains 60,000 records

When I run the program and it finishes there are 110,000 recs. There should be 60,000 recs.

If I run the program again there should be 60,000 recs but there will be 170, 000 recs.

There must be an error but the app is not reporting the error. It just carries on.

Logging in as same user on that client machine and running delete through Enterprise server worked. The same app works on my DB.

I would think there is a difference between the DBs but I cannot figure what it is. I though permissions or it's trying to delete DImporter.tblDataImport rather than dbo.tblDataImport but there is only the dbo schema. It must be a permissions issue but why would it work on the same DB when using Enterprise manager.