There are none - I created the DBF especially for the data export, and it is not used by anything else.

Yes, I just found this KB article in a discussion forum on http://www.alegsa.com.ar/Visitas/index4/Null%20in%20where%20clause%20problem%20sql.php

My SQL Server does have 4 CPUs and I do have parallelism enabled. When I execute the...

Ian,

No, the index on TABLE_A.Thoroughfare is not clustered. There is no clustered index on the table - I wonder how long it would take SQL to create a clustered index...

Andy,

Is there any performance difference doing it this way? My guess is that it is merely a syntactical variation, and the actual query run by SQL in both cases is...

Remi,

That worked well, thank you. I ran

set rowcount 100000

select 'Populating value of ThoroughfareID...'

while @@rowcount > 0

 update TABLE_A

 set ThoroughfareID = b.ID

 from TABLE_B b

 where b.Thoroughfare = TABLE_A.Thoroughfare

 and TABLE_A.ThoroughfareID is null

set rowcount 0

and all 26,000,000...

Thanks for the advice, John.  The inserts are being done by a 3rd-party application that I have no control over, so hence using the trigger.

Unfortunately the table has no indexes,...

I'm sure you'll agree the following code is simple and elegant. Hope it helps. Assuming there is a table COLORTABLE ( item int, color varchar(10) )

declare @colorlist varchar(1000)

select @colorlist  =...

I don't think Article 299575 applies in this case because I don't see any EXCEPTION_ACCESS_VIOLATION messages in the SQL Log, and I am not performing an ANSI join between...

That was it!  Many thanks

I don't think so. This article describes error 208 having the folowing text "Server: Msg 208, Level 16, State 1, Line Invalid object name 'syslogins'." (which I don't see at...

Thanks for the advice.

Sp3a has been applied, and MDAC 2.8, but the problem remains...

Thanks for your reply, Alamir.

However, I don't believe the problem is related to either locks (the problem exists even when no tables are being referenced, therefore no possibility of a...

Thanks for your reply.

All 10 queries were running from the same client - 10 query windows.

The "Query time-out" setting is 600 seconds. But isn't the Timeout property only valid for...

No, the times are different. In the tests I have run, sometimes the connection is dropped after 5 minutes, other times after 90 minutes or more.

Besides, I think the Timeout...

Lee, I found Microsoft Knowledge Base Article - 814113 (searching for Q814113 yeilded no results), but this is not the problem I am experiencing.

814113 described the following symptoms: "After you...