MARS do provide what you asked for:

Execute multiple queries on a single connection simultaneously

And asynchronuos excecution is being supported even by ODBC since a long time ago therefore the key...

Sorry I could not get back to you yesterday. I'll see if I can help you today!!

-- Populate Carriers

insert into Carriers( CarrierName, ID)

 select Column_Name, (Ordinal_Position - 10) as ID

 FROM information_schema.columns

 WHERE table_name='2004 UIL Prospects Appointments'

 and ORdinal_Position between 11 and 102

-- Populate Appointments

insert into Appointments( ID, CarrierID)...

when in doubt, google it out!  

You can sena a bunch of select statements in one batch and it will be executed in one go!  You will  get multiple resultsets that you can loop on at client side.

What you...

I am out of this thread because I see that the poster does not deserve the attention or respect of anyone here. I saw people trying to give him an...

I will also like to add that some times in BOL you have an ample respose to a question that can't be answered in two words and it makes it...

From 2000 Client tools you can manage 7.0, not the other way around 

and if those ACCESS fields are "yes"/"no" they are usually created in SQL Server as bit type and should that be the case just replace the  " = 'Y' "...

Again it is difficult to prescribe anything at this point of facts. (NO MORE GUESSING!)

If you ask for large amount of records, lock escalation comes into place and there will...

Never said I didn't Agree with your anwsers either

Ah, Scott One more thing!!

I noticed you said that ADO was using SERVER-SIDE cursor Type in the ADO recordset. While the .NET is using client side. The good thing about that is that...

Well if you read my FIRST reply

... To check that you have to take a Profiler trace and deal with the prepare...

I said before that you need a PROFILER TRACE to know the difference and that my guess is that it is PARAMETERIZING the UPDATES. It is difficult without the code...

So, Is it OK if I assume you are Agreeing with me?